Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
skeezix
 
Posts: n/a
Default How do I fix column widths in Excel Pivot Tables?

How do I fix column widths in Excel Pivot Tables so that width does not
change with each refresh?
  #2   Report Post  
terbstew
 
Posts: n/a
Default

If your pivot table is already created, select a cell within the table and
click on the Pivot Table Wizard Button. Select the Options button, deselect
the AutoFormat option box and select the Preserve Formatting option box.
If just creating your pivot table, at step 3 of 3 of the wizard click the
Options button and do as above.
Note: when formatting the table, if you have any categories in the "Page"
section, make sure it is set to "All" and not filtered otherwise it keeps the
original format set for each Page criteria. Took me a while to figure out
why it kept changing when I changed the criteria.


"skeezix" wrote:

How do I fix column widths in Excel Pivot Tables so that width does not
change with each refresh?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 08:27 PM
How can I see column headings of hidden columns in Excel before u. Beachcomber Excel Discussion (Misc queries) 10 December 10th 04 02:35 PM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 07:45 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 02:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 04:19 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"