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've had this exact issue with a user today. I have rolled back to version 16.0.18129.20200 which works fine. It did work in safe mode so it may be an add in causing the issue.

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

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

No problem Brad, glad it was helpful for you.

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.

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-10T11:49:52+00:00

I've had this exact issue with a user today. I have rolled back to version 16.0.18129.20200 which works fine. It did work in safe mode so it may be an add in causing the issue.
Was this answer helpful?

2 people found 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-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
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-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