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-03-28T02:26:06+00:00

    This is exactly what I want to do. Just stop the table from automatically adjusting the width upon refresh!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-03-07T15:33:29+00:00

    Hi Gary - Right click on your query table and then choose External Data Properties. That's where the problems begin!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2025-03-05T16:55:53+00:00

    I also have the same problem since a pair of months ago at least, I use excel 365 online and almost everytime I click on table properties excel crash.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2025-01-06T23:42:38+00:00

    OK thanks, I've done as suggested.

    Was this answer helpful?

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

    Hello, rau1.

    Thank you for visiting the Microsoft Community.

    We understand the problem you are having. Your current issue appears to be a Power Query-related issue, we suggest you ask the following questions to ask questions and research:

    Power Query - Microsoft Fabric Community

    (Users who have the same problems as you in this area will prefer to ask questions and share their ideas.)

    The experts here will provide you with more specialized solutions to your Power Query problems.

    Sincere greetings

    Hannah.Z- MSFT |Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments