Excel web app version - Pivot table - Refresh data on file open - not working

Question

Hi

We have been using excel for a number of years in the online web app version and have created lots of reports with pivot tables. These have been set to 'refresh data on file open' and have been working fine until recently.

In the last couple of days we have noticed that the excel web app version has stopped refreshing on page open and the only way to refresh the pivots is manually, which is not helpful for reporting.

We have tried a number of different accounts (personal and work so can't be a specific setup issue) and the behaviour is the same on all excel documents (new & existing).

Has something changed or broken with the refreshing of pivot tables on document open in the online web app version? Interestingly the same documents opened in desktop excel behave as expected.

Thanks

Answer 1

From your description issue seems coming from Update in Excel web.

I'd suggest you raise a support ticket to Microsoft.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

Answer 2

Hi djpax2016,

Good day!

Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation and we will update the thread shortly.

Appreciate your patience and understanding and thank for your time and cooperation.

Sincerely,

George | Microsoft Community Moderator