Excel crashes in Table Properties

Thanks Earle - this has been as close to the best solution so far. As soon as you access the "Properties" thru the "Queries & Connections" pane it seems to resolve the issue temporarily until you log out and back in. Agree with you that we all hope Microsoft can resolve this issue ASAP. In our case it only effects our PC's that have updated to Windows 11 - all Windows 10 machines are un-affected

I use PowerQuery quite a bit together with Excel (Microsoft 365).

Excel has started crashing whenever I access Table Design / Properties for a table created by PowerQuery.

This is the scenario:

1. • Put cursor in the table
2. • Click Table Design menu
3. • click "Properties" (which is present in the "External Data Table" section of the ribbon). [Note: Properties will be greyed out for an ordinary table - AFAIK, it's only accessible for a Table created by PQ.]
4. • make some change in the window that pops up

In all existing workbooks, and even a brand new one I create, following Step 3 (or sometimes Step 4) Excel crashes - and it usually restarts. So, the properties function under Table Design is inaccessible!

What could be causing this? How to fix it?

Lo and Behold - an update to Excel

has just become available and appears to resolve the problem....

• We updated 2 of our teams machines t windows 11 and those crash but the 2 machines left on Windows 10 can still access the properties on the queries

My machine is Win 10. I assume the issue is more likely the vsn of Excel/MS365, more so than Windows. Waiting for vsn 2504 to see if that resolves the issue.

Brad

It's happening to us too - We updated 2 of our teams machines t windows 11 and those crash but the 2 machines left on Windows 10 can still access the properties on the queries

Yes, Beta channel.