insert new rows upon refreshing pivot table report

[jgreene]

Hi,

I have Excel 2000. I want to place two pivot table
reports on top of one another (there will be a few empty
rows in between them, but they will essentially be on top
of each other). I will want to be able to add more data
to the original lists which the Pivot Table Reports are
pulling from. I can refresh the reports to show the
newly added information, but if I add more data than I
have free space for it, the top Pivot Table Report will
overwrite the information in the bottom Pivot Table
Report. I do not want to just create a lot of free space
in between the two reports, as I want them to always be
close to each other. Is there a way to set a Pivot Table
Report so that it automatically inserts new rows when
refreshing? I appreciate any advice that can be given.

Sincerely,

Jason

 

[Frank Kabel]

Hi
AFAIK there's no way to do this if you have two pivot tables on one
sheet