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: Put cursor in the table Click Table Design menu 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.] 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?

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

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.

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: Put cursor in the table Click Table Design menu 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.] 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....

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

Can you talk through the testing that you did on 2504 and the specific build version that proved it is resolved? There don't appear to be release notes out for 2504 yet.

Excel crashes in Table Properties

Anonymous

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:

- Put cursor in the table
- Click Table Design menu
- 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.]
- 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?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

52 answers

Anonymous

2025-04-23T02:15:59+00:00

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
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-23T02:44:56+00:00
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.
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-23T02:54:23+00:00
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:

Put cursor in the table

Click Table Design menu

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.]

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....
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-23T03:18:15+00:00

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
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-24T10:37:49+00:00

Can you talk through the testing that you did on 2504 and the specific build version that proved it is resolved? There don't appear to be release notes out for 2504 yet.
Was this answer helpful?

0 comments No comments