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 tested the above, and it seems like it worked. It looks like MS have introduced a bug, as we starter experiencing this from Dec 2024

I can confirm that this solution works!! Managing the query by right-clicking Queries & Connections and selecting Properties did the trick! I've been struggling with this for over a week now! Kudos Tristan, you are a lifesaver!

Following an update, the vns are now: 16.0.18324.20168, and as above, respectively. Crash still occurs.

Julian, looking in Aps and Features, I have these: The vsn of the first is: 16.0.18324.20092, and of the second is: 18.2501.1031.0 Which is the relevant item?

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

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-23T12:25:28+00:00

We tested the above, and it seems like it worked. It looks like MS have introduced a bug, as we starter experiencing this from Dec 2024
Was this answer helpful?

0 comments No comments
Anonymous

2025-01-21T20:47:23+00:00

I can confirm that this solution works!! Managing the query by right-clicking Queries & Connections and selecting Properties did the trick! I've been struggling with this for over a week now! Kudos Tristan, you are a lifesaver!
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2025-01-12T03:38:09+00:00

Following an update, the vns are now: 16.0.18324.20168, and as above, respectively. Crash still occurs.
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2025-01-12T02:06:06+00:00

Julian, looking in Aps and Features, I have these:

The vsn of the first is: 16.0.18324.20092, and of the second is: 18.2501.1031.0

Which is the relevant item?
Was this answer helpful?

0 comments No comments
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