Forum Discussion
Re: Pivot table won't refresh.
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 s...
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.