Pivot Table Question

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

Guest

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
 
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
 
You're welcome! Thanks for letting me know that it worked for you.
 
You must log in or register to reply here.

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

Excel VBA For excel 0
Excel 2007 Pivot Tables 1
Pivot table report invalid 0
Pivot Table Problem 4
Pivot tables 2
Pivot Table Question 3
Pivot Table Help! 1
Access #Error & Excel Pivot 0

Back
Top