Excel crashes in Table Properties

Anonymous
2025-01-06T00:22:10+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?

Microsoft 365 and Office | Install, redeem, activate | Other | Other

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

Sort by: Newest
Most helpful Newest Oldest
  1. 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
  2. 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
  3. 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
  4. 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
  5. 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