L Lee Mar 2, 2004 #1 Is there a way to preserve the formatting when refreshing a Pivot Table? Specifically column width... Thanks....
Is there a way to preserve the formatting when refreshing a Pivot Table? Specifically column width... Thanks....
F Frank Kabel Mar 3, 2004 #2 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
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
