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