Pivot Tables

Lee · Mar 2, 2004

Is there a way to preserve the formatting when refreshing
a Pivot Table? Specifically column width...

Thanks....

Frank Kabel · Mar 3, 2004

Hi
you may want to (un)check the 'Autoformat Table' in the PT
Options dialog box.

you also may have a look at
http://support.microsoft.com/default.aspx?scid=kb;en-ca;215904
whcih recommends to record a macro while formating