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: Oldest
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-09T16:29:36+00:00

    @rau1 - Exactly so.

    There is a post on the Feedback Portal that flags the bug, but then quotes the non-workaround which is less helpful. Suggest everyone upvotes it and adds to the comments.

    https://feedbackportal.microsoft.com/feedback/idea/6dcce8b8-e8be-ef11-95f6-0022484d7a88

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2025-02-10T08:39:40+00:00

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-02-17T06:28:37+00:00

    I have the same issues, seems support also cant seem to help: When going into an excel document with active connection, as soon as I select the table or connection itself and press properties then excel stop responding. Anyone having a resolution for this?

    Already tried al the overall actions line repair, safe mode, disabling add ins, setting up clean connection, re-installation, check licensing etc.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2025-02-22T00:49:05+00:00

    I tried a lot of things:

    • scf /scannow- DISM /Online /Cleanup-Image /RestoreHealth
    • Disabling Excel add-ins.
    • Removing any files (xlsb) in Excel temp.
    • Disabling GPU acceleration/multi-threaded processes.

    Event Viewer says: Faulting module name: ntdll.dll

    ntdll.dll is responsible for a few things like memory management, error handling, etc.I got the exception error code c0000374 which indicates a heap corruption error, meaning memory corruption, bad drivers, or software conflicts.

    Heap corruption errors can be caused by many system-level things like corrupt updates, but running both mentioned commands would have solved this if so.

    What actually worked: running Excel in Win 8 compatibility mode.

    I found when it crashed it was trying to find: 

    HKCU\Software\Classes\Wow6432Node\CLSID\{7B8A2D94-0AC9-11D1-896C-00C04FB6BFC4}

    So, perhaps Win 8 compat. mode looked elsewhere for this (HKLM), and the CLSID existed there.

    Merging this across to HKCU alone didn't fix the issue if ran w/o Win8 compat. mode so I guess there is a lot more to this; maybe there are other missing reg paths, or the compatibility mode bypasses security checks, maybe older DLLs in use also.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments