Home

Excel Online: Pivot Table not refreshing

%3CLINGO-SUB%20id%3D%22lingo-sub-275734%22%20slang%3D%22en-US%22%3EExcel%20Online%3A%20Pivot%20Table%20not%20refreshing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275734%22%20slang%3D%22en-US%22%3E%3CP%3EReposting%20from%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_other-mso_online%2Fexcel-online-pivot-table-not-refreshing%2Fab01272d-4388-4388-8152-3c3bb69c4429%3Ftm%3D1539876911116%26amp%3BrtAction%3D1539961633286%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Answers%3C%2FA%3E%20to%20get%20more%20traffic%20and%20hopefully%20an%20answer%20to%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20file%20in%20Excel%20(365%20v1809)%20and%20put%20it%20on%20SharePoint.%26nbsp%3B%20The%20team%20using%20the%20file%20is%20accessing%20it%20through%20Excel%20Online.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EUsers%20enter%20data%20on%20one%20tab%2C%20and%20then%20other%20tabs%20hold%20pivot%20tables%20(with%20shared%20pivot%20cache)%20which%20create%20different%20operational%20views%20of%20the%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EScenario1%3A%20User%20adds%20a%20new%20row%20to%20the%20data%20entry%20table%20and%20refreshes%20the%20pivot%20table.%3C%2FP%3E%3CP%3EOutcome%3A%20Pivot%20table%20refreshes%20with%20new%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenario2%3A%20User%20modifies%20data%20in%20existing%20row%20of%20the%20data%20entry%20table%20and%20refreshes%20the%20pivot%20table.%3C%2FP%3E%3CP%3EOutcome%3A%20Refresh%20does%20not%20update%20the%20data%20within%20the%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenario3%3A%26nbsp%3BAdded%20a%20new%20column%20to%20the%20source%20data%20table%20with%20a%20formula%20that%20performs%20a%20lookup%20to%20another%20tab%20on%20the%20same%20file.%26nbsp%3B%20The%20original%20value%20when%20I%20added%20the%20column%20(no%20data)%20is%20still%20present%20in%20the%20Pivot%20Table%20even%20if%20I%20refresh%20through%20Excel%20Online.%26nbsp%3B%20The%20lookup%20values%20in%20the%20source%20data%20is%20updating%2C%20but%20not%20the%20Pivot%20Table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3ESolutions%20attempted%3A%3CBR%20%2F%3E1%20-%20Deleted%20the%20Pivot%20Table%20and%20rebuilt%3CBR%20%2F%3E2%20-%20Turned%20off%20caching%20of%20data%20for%20the%20pivot%20table%3C%2FP%3E%3CP%20class%3D%22%22%3E3%20-%20Created%20distinct%20pivot%20cache%20for%20each%20table%3C%2FP%3E%3CP%20class%3D%22%22%3E4%20-%20Copied%20file%20to%20another%20SharePoint%20site%2C%20then%20deleted%2Freplaced%20the%20file%20on%20the%20original%20site%20(no%20other%20changes).%26nbsp%3B%20This%20temporarily%20fixed%20the%20issue%20but%20it%20has%20come%20back%20again.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EWhen%20I%20use%20the%20file%20from%20my%20desktop%20Excel%20install%20the%20tables%20refresh%20normally.%3C%2FP%3E%3CP%20class%3D%22%22%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-275734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-432681%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3A%20Pivot%20Table%20not%20refreshing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-432681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F230616%22%20target%3D%22_blank%22%3E%40Christopher%20Sundar%3C%2FA%3E%26nbsp%3Bhave%20you%20figured%20out%20a%20solution%20yet%3F%20I'm%20having%20a%20very%20similar%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433365%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3A%20Pivot%20Table%20not%20refreshing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318875%22%20target%3D%22_blank%22%3E%40adnic2019%3C%2FA%3E%26nbsp%3BNo.%26nbsp%3B%20I%20ended%20up%20linking%20the%20file%20to%20PowerBI%20and%20leveraging%20that%20tool%20for%20reporting.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Christopher Sundar
New Contributor

Reposting from Microsoft Answers to get more traffic and hopefully an answer to the problem.

 

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.

 

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

 

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

3 - Created distinct pivot cache for each table

4 - Copied file to another SharePoint site, then deleted/replaced the file on the original site (no other changes).  This temporarily fixed the issue but it has come back again.  

 

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

Please help.

2 Replies

@Christopher Sundar have you figured out a solution yet? I'm having a very similar problem.

Highlighted

@adnic2019 No.  I ended up linking the file to PowerBI and leveraging that tool for reporting.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies