XL97: where are my favourite MVP's ?

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

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
 
I have succeeded doing this in several workbooks, but I
can't repeat it each time in the same way.
Click to expand...
Why not?

Also, have you seen the articles below and other related ones at
support.microsoft.com?

XL97: Formatting Not Retained in PivotTable
http://support.microsoft.com/default.aspx?scid=kb;en-us;162028

XL: PivotTable Refresh Overwrites Formatting
http://support.microsoft.com/default.aspx?scid=kb;en-us;110602

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I don't believe there is a way to retain all formatting aspects with a pivot
table. If I recall, you were looking for column widths as one thing to
retain after you change the layout of a table. I doubt that would be
possible. The easiest would probably to build a macro to restore the page
to the format you want.
 
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.
 
Thank you MVP's Tushar and Tom for replying.
Meanwhile, I started doing some tests on different
workbooks.
I CAN apply colour and font formats inside the pivot (not
borders) in a NEW file.
However, if I open the old file (containing 15Mb of data
over 35 dimensions), the possibility of keeping these
formats suddenly dissapears, ALSO for the new workbook.
I would call this an oddity (or maybe the 15Mb file is
corrupted?)

Greetings and many thanks for sharing the knowledge,
Derek (from Belgium)

[Note: if conditional formatting is applied, ALL formats
get lost upon refreshing]
 
Hi Derek.

Have you right clicked the Pivot table, and in Options checked the "Preserve formatting" box?

Don't forget to apply your format to all the rows or columns you want, as some get hidden when you filter the data.


Regards Robert
"More Vodka Please"
 
Back
Top