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-02-09T04:20:38+00:00

    It crashes in Safe Mode too.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-02-09T04:14:34+00:00

    Tristan - what you describe is a way to access query properties. That's not the issue I've raised (see the Original Post). I'm trying to access the Table properties (eg. to tell PQ to not tinker with column widths in the Table). I'm not seeing any access to Table properties from the side menu - only from the Top "Table Design" menu.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-02-05T07:30:04+00:00

    I hope you have solved the issue, but if you are still facing it there are few fixes that you can try :

    Try running a repair on office from the control panel.  Disable all add-ins (File → Options → Add-ins) and see if that helps.

    Clear power query cache. Check for excel updates and lastly Try opening Excel in Safe Mode (Win + R → type excel /safe → Enter) and see if the problem still happens.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-01-23T12:25:28+00:00

    We tested the above, and it seems like it worked. It looks like MS have introduced a bug, as we starter experiencing this from Dec 2024

    Was this answer helpful?

    0 comments
  5. Anonymous
    2025-01-12T02:06:06+00:00

    Julian, looking in Aps and Features, I have these:

    The vsn of the first is: 16.0.18324.20092, and of the second is: 18.2501.1031.0

    Which is the relevant item?

    Was this answer helpful?

    0 comments