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?

Thank you for the update, it took them long.

I can confirm that Microsoft have fixed the problem. Everything is working as it should for me.

Thanks Tristan, I have the same bug, your workaround has been a lifesaver.

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. Nothing extensive. I just repeated the steps I described earlier that (invariably) produced a crash. Now it does not. Another poster also noted that 2504 (he accessed it via the Beta channel) appeared to fix the problem. What’s been your experience? I don’t have access to the build detail right now. I did the Excel update just prior to my last post.

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-05-27T07:48:19+00:00

Thank you for the update, it took them long.
Was this answer helpful?

0 comments No comments
Anonymous

2025-05-27T07:36:24+00:00

I can confirm that Microsoft have fixed the problem. Everything is working as it should for me.
Was this answer helpful?

0 comments No comments
Anonymous

2025-05-23T00:03:25+00:00

Thanks Tristan,

I have the same bug, your workaround has been a lifesaver.
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-24T11:18:10+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.

Nothing extensive. I just repeated the steps I described earlier that (invariably) produced a crash. Now it does not. Another poster also noted that 2504 (he accessed it via the Beta channel) appeared to fix the problem. What’s been your experience?

I don’t have access to the build detail right now. I did the Excel update just prior to my last post.
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