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-01-06T23:42:38+00:00

    OK thanks, I've done as suggested.

    Was this answer helpful?

    0 comments
  2. 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