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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-06-06T07:58:00+00:00

    What release version is the fix included in? I'm on the version below, and it still crashes.

    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 32-bit

    I reported earlier the problem fixed in a 2504 Build, as follows:

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-06-05T12:15:58+00:00

    What release version is the fix included in? I'm on the version below, and it still crashes.

    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 32-bit

    Was this answer helpful?

    0 comments