Hey all,

Haven't been able to track this one down.

I have a report page with three pivot tables, one below the other. Is there
anyway to maintain their spacial relationship when they get updated? That is,
if new information is added in the source data, and pivottable 1 gets larger
(more rows) that data dumps over whatever is in those rows below. I would
like the refresh action to insert rows when necessary so that pivots 2 and 3
move down accordingly. Same for when data is removed from source data (less
important).

Any ideas?

Thanks.