jras414 wrote:
Hi All,

I am trying to format a pivot table so that it doesn't overtake and delete
any information contained in cells that are below it. When I refresh my
table's data, it sometimes becomes longer than it was originally formatted to
be, and it deletes the information in the cells below it;

My POV and advice is, never mix pivot tables and non-pivot table data in
the same worksheet. It might work in a one-off situation, but if you
want a repeatable process, don't do it.

Whatever formulas you placed alongside the PT can likely be reproduced
in a separate worksheet using GETPIVOTDATA--without ever worrying about
how the PT's display range changes.

The file linked below crudely demonstrates a work flow beginning with
raw data, summarizing with a pivot table, creating a presentation-ready
summary (using GETPIVOTDATA), and finally, a chart.

http://vfdrake.home.comcast.net/file...orkflow_eg.xls