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
Highlighted

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