Re: Pivot table won't refresh.

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