Home

Re: Pivot table won't refresh.

%3CLINGO-SUB%20id%3D%22lingo-sub-737592%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737592%22%20slang%3D%22en-US%22%3EPivot%20table%20not%20getting%20refresh%2C%20after%20clicking%20refresh%2C%20%22%20msg%20showing%20PIVOT%20TAble%20cannot%20overlap%20another%20pivot%20table%2C%20but%20there%20is%20no%20another%20pivot%20table%20in%20that%20sheet.%22%3CBR%20%2F%3E%3CBR%20%2F%3EPls%20help%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20Refresh%20status%20not%20activated%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738929%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20won't%20refresh.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370940%22%20target%3D%22_blank%22%3E%40rajivjain%3C%2FA%3E%26nbsp%3B%20I%20moved%20your%20post%20to%20a%20new%20question.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20message%20may%20refer%20to%20pivot%20tables%20that%20are%20on%20other%20sheets%20than%20the%20current%20sheet.%20The%20refresh%20command%20refreshes%20all%20pivot%20tables%20that%20are%20running%20off%20the%20same%20pivot%20cache.%20Some%20settings%20like%20groupings%20will%20change%20on%20all%20pivot%20tables%20in%20the%20cache%20and%20that%20may%20cause%20pivot%20tables%20on%20other%20sheets%20to%20touch%20and%20overlap.%20Check%20the%20pivot%20tables%20on%20your%20other%20sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E
rajivjain
Occasional Visitor
Pivot table not getting refresh, after clicking refresh, " msg showing PIVOT TAble cannot overlap another pivot table, but there is no another pivot table in that sheet."

Pls help

Also Refresh status not activated
1 Reply

@rajivjain  I moved your post to a new question.

 

The message may refer to pivot tables that are on other sheets than the current sheet. The refresh command refreshes all pivot tables that are running off the same pivot cache. Some settings like groupings will change on all pivot tables in the cache and that may cause pivot tables on other sheets to touch and overlap. Check the pivot tables on your other sheets.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
9 Replies