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-05-27T13:57:15+00:00

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

    For anyone still waiting for Version 2504 (bug is still present in newest version, 2503, rolled out at my company), this is how I added the macro and added it to the Quick Access Toolbar:

    1. View --> Unhide Window --> PERSONAL.XLSB

    (you want to save the macro in the PERSONAL.XLSB workbook so you can access from any workbook)

    1. View --> Macros --> View Macros

    2a. in 'Macro Name', enter name you want to use (I did DontAdjustColumnWidth) --> Create

     (VBA editor should open with a Module window in PERSONAL.XLSB)

    2b. Enter italicized text below (see OKshef's post for full list)

    2c. Save and close VBA editor

    (You should be able to run the macro [make sure you're in a cell in your query table]; next step is optional)

    1. (To add the macro to a button in the Quick Access Toolbar) Customize Quick Access Toolbar --> More Commands... --> Choose commands from: --> Macros --> 'Add>>' to location of choice within QAT --> use 'Modify...' if desired to change display name and/or select symbol for button --> OK --> OK

    Sub DontAdjustColumnWidth()

    '

    ' For QueryTable, set properties NOT to adjust column width with Refresh

    With Selection.ListObject.QueryTable

    .AdjustColumnWidth = False

    End With

    End Sub

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-21T20:47:23+00:00

    I can confirm that this solution works!! Managing the query by right-clicking Queries & Connections and selecting Properties did the trick! I've been struggling with this for over a week now! Kudos Tristan, you are a lifesaver!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2025-01-12T03:38:09+00:00

    Following an update, the vns are now: 16.0.18324.20168, and as above, respectively. Crash still occurs.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2025-01-10T15:19:07+00:00

    No problem Brad, glad it was helpful for you.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2025-01-08T14:53:38+00:00

    I'm having a similar issue that I only noticed towards the end of December with Excel 365 crashing whenever I edit external data properties for any type of database connection I've been using, including a legacy Microsoft Query. Excel restarts without warning and the event viewer refers to exception code 0xc0000374 with the faulting module name being ntdll.dll, version 10.0.19041.5007. Googling this isn't much help as it appears this is rather a generic issue to do with heap corruption.

    I've tried an online repair of Excel, as well as running the Windows system file checker, but to no avail. I'm running Windows 10 Pro 64-bit and my Windows updates are up-to-date. I am running the 32-bit version of Excel 365 as we're still needing to access a legacy ODBC connection that only supports 32-bit.

    Just today there was a new Office (AKA Microsoft) 365 update available so I've proceeded with it too, but I'm still getting the same crash in Excel.

    I've tried clearing data caches and deleting temporary files, and I've also tried using a different user profile on the same computer, but also no joy.

    As I'm not only getting crashes with Power Query related tables but also Microsoft Query related tables, I chose to post here rather than in the Microsoft Fabric Community forum where I see the OP did indeed raise his issue again.

    At this point I'll probably wait for Tuesday's Windows updates and if those don't solve the issue, I see no other course of action other than to go through the hassle of performing a Windows reset and then reinstalling all my applications.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments