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?

My similar image (Microsoft 365) looks pretty different! Clicking the Properties option (bottom of list) gets the Query properties, not the table properties.

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".

Hi Julian, Thanks for this as I didn't realise I could "downgrade" the 365 version of office. I did some googling for the process but then ran into another issue as it appears I can't downgrade directly to "16.0.18129.20200" as I then get an update error. So it looks like I need to step down one version at a time. At the moment it let me downgrade to 16.0.18227.20162, and from there to 16.0.18227.20152, at which point I'm still getting the Excel crash. So I'll keep stepping back a version at a time (& retesting Excel) until I can get as close as possible to the version you mentioned above. Regards, Brad

Hello, rau1. I am glad to hear your update on the problem, and hope that your problem can be solved more professionally and properly. Best Regards, Hannah.Z

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-12T01:47:24+00:00

My similar image (Microsoft 365) looks pretty different! Clicking the Properties option (bottom of list) gets the Query properties, not the table properties.
Was this answer helpful?

0 comments No comments
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-10T13:30:17+00:00

Hi Julian,

Thanks for this as I didn't realise I could "downgrade" the 365 version of office.

I did some googling for the process but then ran into another issue as it appears I can't downgrade directly to "16.0.18129.20200" as I then get an update error. So it looks like I need to step down one version at a time. At the moment it let me downgrade to 16.0.18227.20162, and from there to 16.0.18227.20152, at which point I'm still getting the Excel crash. So I'll keep stepping back a version at a time (& retesting Excel) until I can get as close as possible to the version you mentioned above.

Regards,

Brad
Was this answer helpful?

0 comments No comments
Anonymous

2025-01-09T01:26:10+00:00

Hello, rau1.

I am glad to hear your update on the problem, and hope that your problem can be solved more professionally and properly.

Best Regards,

Hannah.Z
Was this answer helpful?

0 comments No comments