Excel Crashes in Table Properties

[Rau2024]

Excel has started crashing whenever I access Table Design / Properties for a table created by PowerQuery.

This is the scenario:

1. - Put cursor in the table

2. - Click Table Design menu

3. - 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.]

4. - 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?

[v-aatheeque]

Hi @SD007 

Apologize for the issue you are facing. The best course of action is to open a support ticket.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: 

https://support.fabric.microsoft.com/support

[Rau2024]

As an ordinary home user, I don't know how to do that.

[v-aatheeque]

Hi @Rau2024 

you can refer this link how to raise a support ticket :How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[SD007]

I have the exact same problem, did you find a fix?

[Rau2024]

I use Microsoft 365.  Can't imagine changing to anything else.

[v-aatheeque]

Hi @Rau2024,

Here are some steps you can take to troubleshoot the problem: 

• Make sure you're using the latest version of Microsoft Office. Open Excel and navigate to File > Account > Update Options > Update Now to check for updates.
• reinstalling Microsoft 365 can resolve persistent issues. You can completely uninstall and then reinstall Office from your Microsoft account portal.
• Ensure your Microsoft 365 is up to date by going to File > Account > Update Options > Update Now. New updates might contain fixes for this issue.
• Check for Add-ins: Sometimes, third-party add-ins can cause issues. Try disabling any add-ins you have installed. Go to File > Options > Add-ins, and at the bottom, select COM Add-ins and click Go. Uncheck any add-ins and see if the issue persists.
• If possible, try recreating the Power Query table to see if the issue persists with the new table.
• If none of the above solutions work, consider reaching out to Microsoft Fabric Support and Status | Microsoft Fabric for further assistance. They may have more sp...
  
  
  

  If this answer helped resolve your issue, please consider marking it as the accepted answer. And if you found my response helpful, I'd appreciate it if you could give me kudos. Thank you!

[SD007]

I have the same problem and have tried everything mentioned here but it is still the same even in safe mode.

[rubayatyasmin]

Hi, Can you try it on excel online version? A few days ago I was facing some issues while creating pivot table. My excel was crashing too. I had to change the Excel version. Did you try to recreate the table and see if it works?

If none of the solutions are working then create a support ticket. 

[Rau2024]

I'm using Microsoft 365 - so I don't know what "change the version" means.