Excel Online: Pivot Table not refreshing

I created a file in Excel (365 v1809) and put it on SharePoint.  The team using the file is accessing it through Excel Online.  

Users enter data on one tab, and then other tabs hold pivot tables (with shared pivot cache) which create different operational views of the data. 

Scenario1: User adds a new row to the data entry table and refreshes the pivot table.

Outcome: Pivot table refreshes with new data.

Scenario2: User modifies data in existing row of the data entry table and refreshes the pivot table.

Outcome: Refresh does not update the data within the pivot table.

Solutions attempted:
1 - Deleted the Pivot Table and rebuilt
2 - Turned off caching of data for the pivot table

When I use the file from my desktop Excel install the tables refresh normally.

Please help.

 

Question Info


Last updated November 11, 2019 Views 273 Applies to:
One additional piece of information.  When I copied the file to another SharePoint site and was the only one using it through Excel Online, the pivot table refreshed appriopriately.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I have also now rebuilt the file with distinct Pivot Caches for each Pivot Table and am continuing to have this issue.

Additional example:

- Added a new column to the source data table with a formula that performs a lookup to another tab on the same file.  The original value when I added the column (no data) is still present in the Pivot Table even if I refresh through Excel Online.  The lookup values in the source data is updating, but not the Pivot Table.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.