Control of pivot table column widths

G

Guest

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" ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Column Widths 3
Column Widths 1
Format pivot table / column width 2
Excel Column Widths When Printing 1
Formats of pivot tables changes when data is refreshed 2
Excel VBA For excel 0
Lock Pivot Table Column Width 2
Pivot Table column widths 2

Top