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?

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

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

I started noticing this issue about a couple of months ago, and saw this thread about a month ago. I thought it would have been fixed by now. Can Microsoft get their act together and just fix this thing? It's actually pathetic.

Hi Gary - Right click on your query table and then choose External Data Properties. That's where the problems begin!

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-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-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
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Anonymous

2025-03-19T10:51:47+00:00

I started noticing this issue about a couple of months ago, and saw this thread about a month ago. I thought it would have been fixed by now. Can Microsoft get their act together and just fix this thing? It's actually pathetic.
Was this answer helpful?

6 people found this answer helpful.

0 comments No comments
Anonymous

2025-03-07T15:33:29+00:00

Hi Gary - Right click on your query table and then choose External Data Properties. That's where the problems begin!
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments