Pivot Table Question

J

John Calder

Hi

I run Win2K with Excel 2K

I have a pivot table with a number of headings. Whenever I refresh the table
the columns always adjust to autofit the headings. I would like to know is
there any way that you can fix the column widths on a pivot table so that
when you refresh the data they do not go back to the original with.

Thanks, any help is much appreciated

John
 
D

Debra Dalgleish

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
Click OK
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot table report invalid 0
Excel 2007 and refresh pivot table methodology 0
List all tables, including document structure 0
Excel 2013 Pivot Data Range formula reference problem 0
pivot table missing rows? 0
Excel 2007 Pivot Tables 1
Pivot Table Data Aggregation 0

Top