overlapping Pivots

[oz032281]

Quick question,

Is there a way for excel to use VBA to allow for the adding of new rows as necessary when updating a pivot table. In other words if I have 2 pivots one ot top of eath other. When the first one is updated; if the source data has changed a bit it will need new rows to allow the data to be shown, otherwise you get an error message about overlapping tables. Is there a way to automate the procedure so that when the table is updated new rows are added and the error message does not occur.

Thank you,
osmer

 

[simselk]

Hi Osmer

I dont like your chances ... this is one problem with Excel because its capabilties can be limited; particularly with pivots.

I think it would be safer & easier just to have the pivots on separate sheets.

HTH

Simon