"Pivot Table cannot overlap Another Pivot Table" m

M

mbinva

New Member
Joined
Apr 15, 2003
Messages
4
Help! I have a workbook full of pivot tables from which I create reports (with 2 worksheets of corresponding data). For some unknown reason, this month when I updated the data and went to refresh the pivot tables, I get the following message: "Pivot Table cannot overlap Another Pivot Table"

There is no reason for me to get this message - I did not change the layout on the worksheet and there is not more than one pivot table on the sheet. Further, I get this on many of my sheets, not just one. I also tried going back to an earlier version of my file, updating it, and the same thing happened.

Can anyone help me with this? I really do not want to have to recreate my workbook/pivot tables, and I do not want to run across this in the future without a solution.

Thanks much.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Re: "Pivot Table cannot overlap Another Pivot Table&quo

mbinva said:
...there is not more than one pivot table on the sheet...
Click to expand...

Are you sure? Do you have any hidden columns/rows?
 
Upvote 0
The basis data for some of your pivots is different. This makes some pivot tables bigger that the first time you recorded them. Thus overlapping eachother.

get it: last moth you had info on e.g. 4 different people and this moth there are 5 different, making your pivot table somewhat bigger.

Try giving them more space.
 
Upvote 0
Mark, no hidden worksheets either.

Dinictus, that sounds like it might be it. Although I have been expanding the data on a monthly basis for 9 months now so I am not sure why this is happening now.

When you say give them more space, what exactly do you mean? Some of my tables are only 4 columns, 3 rows and the rest of the sheet is empty (therefore there is plenty of space?).

Thanks for the help.
 
Upvote 0
I mean because one pivot is now bigger than last time, it uses cells that are designated for another pivor table. So you have to move the second pivot a little to the right or down (whatever floats your boat)

Go into VBA an change the pivot table destination. Or when you are recording it all :oops: , record it again with more space for each pivot.

That oughtta do it for sure.

Note: is the error happens early in the macro, the rest of the macro will also not run. If you debug on the error, you will see excactly where the issue lies! :cool:
 
Upvote 0
Dinictus said:
I mean because one pivot is now bigger than last time, it uses cells that are designated for another pivor table...
Click to expand...

I believe that mbinva has already stipulated (in his original posting) that "...there is not more than one pivot table on the sheet...".
 
Upvote 0
You're right. :wink:

Well in that case, going into debug would surely give some insight in his problem. Its a stange error if there are no other pivots on a sheet.

perhaps you programmed a 2nd pivot somewhere and deleted it later in your programme? (didn't clean up so they overlap now)
 
Upvote 0
Figured it out!

It turns out that the problem was my very last (backup data) worksheet which did indeed have two overlapping pivot tables. The 7-8 sheets that I was getting errors on did not have more than one pivot table but must have been linked in some way to the one worksheet that did.

Thanks to both of you for the help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
831
adambc
A
P
  • Question
Copying Pivot table retains previous workbook link
Replies
0
Views
207
PCRIDE
P
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
161
sschaefer
S
W
  • Solved
Multiple pivot tables on the same sheet
Replies
2
Views
284
Woftae
W

Forum statistics

Threads
1,214,839
Messages
6,121,887
Members
449,057
Latest member
Moo4247

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top