"A PivotTable report cannot overlap another PivotTable report

jack10063

Board Regular
Joined
Aug 12, 2008
Messages
103
Hi!

I have multiple PivotTables in a worksheet and I am getting an error "A PivotTable report cannot overlap another PivotTable report" if I am putting too many rows in my first table.

So, is it somehow possible to define that Excel would create more empty rows and thus drop the tables that are below my first table if the first table would otherwise be overlapping..?

Thanks!

-Jack
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Not easily - would need some code to run every time the Pivot Table was updated.

If the tables are designed to expand vertically, can you arrange them horizontally instead?
 
Upvote 0
Yard,

Thanks for your answer. That's what I was actually expecting. I think I must have the tables expanding vertically because it is wanted that the total row is at bottom.

Would you have any ideas how to solve this with VBA and so that it wouldn't make it a lot slower to update the table. Is it somehow possible to activate the macro only when the "A PivotTable report cannot overlap another PivotTable report" occurs and then insert the empty rows needed..?

-Jack
 
Upvote 0
Hi,

Not what I meant. The tables will expand vertically as you describe - therefore if you position the tables side by side you might avoid the problem.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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