Forum Discussion

rajivjain's avatar
rajivjain
Copper Contributor
Jul 04, 2019

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 status not activated

1 Reply

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jul 05, 2019

    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.

Resources