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?

What release version is the fix included in? I'm on the version below, and it still crashes. Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 32-bit I reported earlier the problem fixed in a 2504 Build, as follows:

What release version is the fix included in? I'm on the version below, and it still crashes. Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 32-bit

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: View --> Unhide Window --> PERSONAL.XLSB (you want to save the macro in the PERSONAL.XLSB workbook so you can access from any workbook) 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) (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

Thank you for the update, it took them long.

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

Excel crashes in Table Properties

Anonymous

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?

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

Anonymous

2025-06-06T07:58:00+00:00

What release version is the fix included in? I'm on the version below, and it still crashes.

Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 32-bit

I reported earlier the problem fixed in a 2504 Build, as follows:
Was this answer helpful?

0 comments No comments
Anonymous

2025-06-05T12:15:58+00:00

What release version is the fix included in? I'm on the version below, and it still crashes.

Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 32-bit
Was this answer helpful?

0 comments No comments
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 No comments
Anonymous

2025-05-27T07:48:19+00:00

Thank you for the update, it took them long.
Was this answer helpful?

0 comments No comments
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 No comments