Power Query Refresh Not Updating Table Data in Excel

Question

I'm experiencing an issue with Power Query refresh in Excel. I'm using Excel Microsoft Office Home and Business 2016 and the issue started after the May 30th, 2024 update.

Here's a detailed description of the problem:

• I upload data from various sources using Power Query.
• When I refresh the data, everything refreshes at the Power Query level (I see the new information in Power Query Editor).
• There are no error messages displayed during the refresh process.
• However, the new information isn't reflected in the final table in the Excel worksheet (new data is not loading to the table).
• I need to manually manipulate table properties and refresh again for the new data to appear.
  To get the new data to appear, I typically need to manually modify the external data properties in the table.
• Specifically, I uncheck the boxes for "Insert cells for new data, clear unused cells," and then select "Insert entire rows for new data, clear unused cells".

After making these changes and refreshing again, the new data appears in the table.

I've noticed that manually modifying the external data properties in the table after refresh seems to work as a workaround. However, is there a way to configure Power Query to automatically update the table without requiring this manual step? This issue is affecting all my colleagues, and the resulting data suffers from this delay.

***Moved from Microsoft 365 and Office / Excel / For business / Windows***

Answer 1

Hi Mr. George S.,

Thanks for visiting Microsoft Community.

I wish I could handle your problem, however, the issue on Power Query is more suitable for publishing on Microsoft Learn , you can click on "Ask a question", there are experts who can provide more professional solutions in that place.

Here is a link to the forum where you can raise specific scenarios and share your idea to help solve the problem.

Sincerely hope that your question will be dealt with appropriately after contact the correct department. Thank you for your understanding!

Best Regards,

Jonathan Z - MSFT | Microsoft Community Support Specialist

Answer 2

Hi Jonathan.Z,

Thank you very much for your assistance and for directing me to the relevant information on the Microsoft support page.

I appreciate you taking the time to help me troubleshoot this issue.

Sincerely,
Mr. George S.

Answer 3

Hi Mr. George,

I try to do the manipulation you are describing but I don't find the checkboxes you are mentioning.

Could you help me to find them?

Answer 4

Hi StokesXS,

Sure.

1. Click anywhere within your table.
2. On the Table Design tab (on the Ribbon), in the External Table Data group, click Properties.

Regards,
Mr. George S.

Answer 5

Hello again Mr George,

Thank you very much for your help.

Unfortunately, it didn't solved the issue on my side.

However, I found that the query load every cells except the one containing numbers.

Do you know why is it happening?

Regards,