Announcement

Collapse
No announcement yet.

PivotTable Error: A pivot table cannot overlap another pivot table report

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • PivotTable Error: A pivot table cannot overlap another pivot table report



    Hi!

    My question is: I am trying to refresh a pivot table and I get an error message "A pivot table cannot overlap another pivot table report". This is a spreadsheet that was passed onto me from another co-worker. To be honest with you I know how to bulid a pivot table but I do not know how to manipulate one. I read online about macros but I am not sure how to set one up to find the problem and then how to go on and fix it.

    Please advise.
    Thank you!

  • #2
    Re: Pivot Tables

    Welcome to Ozgrid.

    Pivot Tables should be on their own sheet.

    Try moving the PT to a new sheet
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

    Comment


    • #3


      Re: Pivot Tables

      Thank you! I will try this. I appreciate your help with this

      Comment

      Working...
      X