Control of pivot table column widths

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a command that will prevent the widths of columns in pivot tables from changing when they are "refreshed" ?
 
Silverhawk, it's the AutoFormat table option on the Pivot Table Options
dialog box. Right-click any pivot table cell and select Table Options.
Deselect AutoFormat table, then OK.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


Silverhawk1 said:
Is there a command that will prevent the widths of columns in pivot tables
from changing when they are "refreshed" ?
 
Back
Top