Pivot Table - Overlapping Issue

LTAJSR
LTAJSR used Ask the Experts™
on


 When new data is updated, the tables sometimes get to long and overlap the one at the bottom.  Is there a way to prompt inserting of cells to compensate for new data and to avoid overlapping?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
No, there is no way to avoid overlapping of the pivot tables.

jppinto
Commented:
The best way to avoid overlapping is to put one pivot table on each sheet or else you can get an error if the pivot tables get over one each other.

jppinto

Commented:
Any updates on this one?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial