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?

Hi, Hannah.Z, I'm sorry, but this is indeed an Excel problem. The 'Properties [Data Range Properties]' command/dialog is completely broken, and that functionality just happens to apply specifically to Query Tables. This is a big enough problem that for the first time I taught myself how to write a macro and assign it to a button in the Quick Access toolbar, and this is my first post ever on one of these forums. The solution that has worked for some but not others, involving right-clicking in Queries & Connections pane, to me seems to work through 'Connection Properties [Connection Properties]' dialog, which does not access many of the properties. (I'm using Excel; Queries but no Connections; and my primary use is to turn off the column-width adjustment.) The response below from okshef on Jan 29, 2025 on using VBA to change QueryTable properties is the only solution I've found that seems to work for everyone's needs. From looking at the list of properties in his code, 'Connection Properties' can be used to set a limited number of QueryTable properties. I'm trying to create templates that my less-technical colleagues can use to create their own queries/query tables, and I think it's asking too much for average users to have to deal with macros to handle basic table functionality. It's also clear from all the related posts that this bug was introduced with one of the updates that started rolling out late last year. I hope and beg that Microsoft will prioritize fixing this bug. Thanks very much, Earle 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

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

The issue seems to be resolved in: Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit ... at least it doesn't crash anymore on my files.

The issue seems to be resolved in: Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit ... at least it doesn't crash anymore on my files. In my Microsoft 365 version (2503 Build 18623.20156), the problem remains. There does not seem to be any later version available. "Check for and Apply Updates" (from the Account page in Excel) says I have the latest.... Are using a Beta channel release or what?

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-03-21T17:11:22+00:00

Hi, Hannah.Z,

I'm sorry, but this is indeed an Excel problem. The 'Properties [Data Range Properties]' command/dialog is completely broken, and that functionality just happens to apply specifically to Query Tables. This is a big enough problem that for the first time I taught myself how to write a macro and assign it to a button in the Quick Access toolbar, and this is my first post ever on one of these forums.

The solution that has worked for some but not others, involving right-clicking in Queries & Connections pane, to me seems to work through 'Connection Properties [Connection Properties]' dialog, which does not access many of the properties. (I'm using Excel; Queries but no Connections; and my primary use is to turn off the column-width adjustment.)

The response below from okshef on Jan 29, 2025 on using VBA to change QueryTable properties is the only solution I've found that seems to work for everyone's needs. From looking at the list of properties in his code, 'Connection Properties' can be used to set a limited number of QueryTable properties. I'm trying to create templates that my less-technical colleagues can use to create their own queries/query tables, and I think it's asking too much for average users to have to deal with macros to handle basic table functionality.

It's also clear from all the related posts that this bug was introduced with one of the updates that started rolling out late last year.

I hope and beg that Microsoft will prioritize fixing this bug.

Thanks very much,

Earle

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?

4 people found this answer helpful.

0 comments No comments
Anonymous

2025-03-28T02:26:06+00:00

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

1 person found this answer helpful.

0 comments No comments
Anonymous

2025-04-05T10:23:35+00:00

The issue seems to be resolved in:
Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit

... at least it doesn't crash anymore on my files.
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-08T05:55:32+00:00

The issue seems to be resolved in:
Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit

... at least it doesn't crash anymore on my files.

In my Microsoft 365 version (2503 Build 18623.20156), the problem remains. There does not seem to be any later version available. "Check for and Apply Updates" (from the Account page in Excel) says I have the latest....

Are using a Beta channel release or what?
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-08T08:20:24+00:00

Yes, Beta channel.
Was this answer helpful?

0 comments No comments