Control of pivot table column widths

S

Silverhawk1

Is there a command that will prevent the widths of columns in pivot tables from changing when they are "refreshed" ?
 
D

DDM

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
Click to expand...
from changing when they are "refreshed" ?
 
Top