As far as color, If color is applied to an entire dimension, it appears to
stay as long as the field isn't hidden. For example, if I colored an entire
column within the table, then shifted the layout so the data was horizontal,
the coloring remained consistent. If you are coloring individual cells,
that seemed to remain as well as long as resolution (granularity?) remained
the same.

--
Regards,
Tom Ogilvy

"Derek" wrote in message
...
This must be a tough one, if none of the MVP's can answer
it.
*****************
Again .. (3rd attempt!)
In Excel 97, how to apply formatting inside a Pivot table
that remain after refreshing?

I have succeeded doing this in several workbooks, but I
can't repeat it each time in the same way.

thanks to anyone that can solve this question,
Derek