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?

We updated 2 of our teams machines t windows 11 and those crash but the 2 machines left on Windows 10 can still access the properties on the queries My machine is Win 10. I assume the issue is more likely the vsn of Excel/MS365, more so than Windows. Waiting for vsn 2504 to see if that resolves the issue.

Brad It's happening to us too - We updated 2 of our teams machines t windows 11 and those crash but the 2 machines left on Windows 10 can still access the properties on the queries

The issue seems to be resolved in: Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit ... at least it doesn't crash anymore on my files. In my Microsoft 365 version (2503 Build 18623.20156), the problem remains. There does not seem to be any later version available. "Check for and Apply Updates" (from the Account page in Excel) says I have the latest.... Are using a Beta channel release or what?

The issue seems to be resolved in: Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit ... at least it doesn't crash anymore on my files.

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-04-23T02:44:56+00:00
We updated 2 of our teams machines t windows 11 and those crash but the 2 machines left on Windows 10 can still access the properties on the queries
My machine is Win 10. I assume the issue is more likely the vsn of Excel/MS365, more so than Windows. Waiting for vsn 2504 to see if that resolves the issue.
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-23T02:15:59+00:00

Brad

It's happening to us too - We updated 2 of our teams machines t windows 11 and those crash but the 2 machines left on Windows 10 can still access the properties on the queries
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-08T08:20:24+00:00

Yes, Beta channel.
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-08T05:55:32+00:00

The issue seems to be resolved in:
Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit

... at least it doesn't crash anymore on my files.

In my Microsoft 365 version (2503 Build 18623.20156), the problem remains. There does not seem to be any later version available. "Check for and Apply Updates" (from the Account page in Excel) says I have the latest....

Are using a Beta channel release or what?
Was this answer helpful?

0 comments No comments
Anonymous

2025-04-05T10:23:35+00:00

The issue seems to be resolved in:
Microsoft® Excel® for Microsoft 365 MSO (Version 2504 Build 16.0.18730.20000) 32-bit

... at least it doesn't crash anymore on my files.
Was this answer helpful?

0 comments No comments