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-04-08T05:55:32+00:00

    The issue seems to be resolved in:
    Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit

    ... at least it doesn't crash anymore on my files.

    In my Microsoft 365 version (2503 Build 18623.20156), the problem remains. There does not seem to be any later version available. "Check for and Apply Updates" (from the Account page in Excel) says I have the latest....

    Are using a Beta channel release or what?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-04-05T10:23:35+00:00

    The issue seems to be resolved in:
    Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit

    ... at least it doesn't crash anymore on my files.

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2025-03-07T14:28:29+00:00

    My Connections tab is (as always) empty. I tried right-clicking both in the "Connections" header and in the empty list - nothing happens. Would you please clarify what you see?

    My queries only show up on the "Queries" tab. I tried right-clicking the relevant query and then Properties. But this gives a different properties window with three tabs: Usage, Definition and Used in. None of these has an "Adjust column width" option.

    Can you offer any advice?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2025-02-10T08:39:40+00:00

    Was this answer helpful?

    0 comments