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?

Rau - hope the image below makes more sense? I see that newer Power Queries are listed under 'Queries' but older Microsoft Queries are under 'Connections'. Hope that helps. Regards

Tristan - not sure what you are doing after "select 'Connections'.....? In my case, the side menu will list various Queries if I click "Queries", but if I click "Connections" (in the side panel), nothing shows (ie. 0 connections). And I'm unclear what you propose to "right click"? Nothing in my side-panel responds to a "right click".

I have the same problem with Excel crashing. I am using Microsoft Query to connect to a SQL database. I did find another solution that worked for me: instead of selecting a cell inside my data table, then selecting 'Table Design' and 'Properties' (which crashes Excel every time), instead go straight to the main 'Data' ribbon tab, then 'Queries & Connections' which opens up the side menu. Then from there you can select 'Connections', right click and open up the familiar Properties window! Bit long-winded but it works! There clearly is a bug that we have to hope Microsoft will fix soon! Hope someone else finds this useful.

No problem Brad, glad it was helpful for you.

Hi Julian, Just an update: I wasn't able to downgrade to 16.0.18129.20200, but I was able to downgrade to 16.0.18129.20158 and I can confirm that Excel is no longer crashing! Thanks very much for the advice. I've turned off auto-updating for now. Regards, Brad

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-01-11T13:41:59+00:00

Rau - hope the image below makes more sense? I see that newer Power Queries are listed under 'Queries' but older Microsoft Queries are under 'Connections'.

Hope that helps.

Regards
Was this answer helpful?

0 comments No comments
Anonymous

2025-01-11T12:16:29+00:00

Tristan - not sure what you are doing after "select 'Connections'.....? In my case, the side menu will list various Queries if I click "Queries", but if I click "Connections" (in the side panel), nothing shows (ie. 0 connections). And I'm unclear what you propose to "right click"? Nothing in my side-panel responds to a "right click".
Was this answer helpful?

0 comments No comments
Anonymous

2025-01-11T09:52:12+00:00

I have the same problem with Excel crashing. I am using Microsoft Query to connect to a SQL database. I did find another solution that worked for me: instead of selecting a cell inside my data table, then selecting 'Table Design' and 'Properties' (which crashes Excel every time), instead go straight to the main 'Data' ribbon tab, then 'Queries & Connections' which opens up the side menu. Then from there you can select 'Connections', right click and open up the familiar Properties window! Bit long-winded but it works! There clearly is a bug that we have to hope Microsoft will fix soon! Hope someone else finds this useful.
Was this answer helpful?

10+ people found this answer helpful.

0 comments No comments
Anonymous

2025-01-10T15:19:07+00:00

No problem Brad, glad it was helpful for you.
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2025-01-10T13:43:20+00:00

Hi Julian,

Just an update:

I wasn't able to downgrade to 16.0.18129.20200, but I was able to downgrade to 16.0.18129.20158 and I can confirm that Excel is no longer crashing!

Thanks very much for the advice. I've turned off auto-updating for now.

Regards,

Brad
Was this answer helpful?

2 people found this answer helpful.

0 comments No comments