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-04-24T11:18:10+00:00

    Can you talk through the testing that you did on 2504 and the specific build version that proved it is resolved? There don't appear to be release notes out for 2504 yet.

    Nothing extensive. I just repeated the steps I described earlier that (invariably) produced a crash. Now it does not. Another poster also noted that 2504 (he accessed it via the Beta channel) appeared to fix the problem. What’s been your experience?

    I don’t have access to the build detail right now. I did the Excel update just prior to my last post.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-05-23T00:03:25+00:00

    Thanks Tristan,

    I have the same bug, your workaround has been a lifesaver.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-05-27T07:36:24+00:00

    I can confirm that Microsoft have fixed the problem. Everything is working as it should for me.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-05-27T07:48:19+00:00

    Thank you for the update, it took them long.

    Was this answer helpful?

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