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?

I also have the same problem since a pair of months ago at least, I use excel 365 online and almost everytime I click on table properties excel crash.

My Connections tab is (as always) empty. I tried right-clicking both in the "Connections" header and in the empty list - nothing happens. Would you please clarify what you see? My queries only show up on the "Queries" tab. I tried right-clicking the relevant query and then Properties. But this gives a different properties window with three tabs: Usage, Definition and Used in. None of these has an "Adjust column width" option. Can you offer any advice?

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

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.

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-05T16:55:53+00:00

I also have the same problem since a pair of months ago at least, I use excel 365 online and almost everytime I click on table properties excel crash.
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2025-03-07T14:28:29+00:00

My Connections tab is (as always) empty. I tried right-clicking both in the "Connections" header and in the empty list - nothing happens. Would you please clarify what you see?

My queries only show up on the "Queries" tab. I tried right-clicking the relevant query and then Properties. But this gives a different properties window with three tabs: Usage, Definition and Used in. None of these has an "Adjust column width" option.

Can you offer any advice?
Was 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
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
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