View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero Ed Ferrero is offline
external usenet poster
 
Posts: 115
Default Save new column width settings in pivot table

Hi Dan,

Go to Pivot Table options and uncheck the Autoformat Table option (make sure
that Preserve Formatting remains checked).

Ed Ferrero
www.edferrero.com

"Dan" wrote in message
...
Help!
How do I save the new settings for column width & alignment in a pivot
table? I changed the column widths and alignment on a pivot table but when
I
do an update the table reverts to a default width.
Thanks, Dan