Excel 2007 / 2010 + Pivot Table Column Width

Well, I’m going to write this particular blog post at the risk of looking incredibly silly, however it may help someone…

I’m in the process of creating some internal reports using Excel 2010 Beta on top of an Analysis Services back end. This requires the creation of a number of Pivot Tables, and some super slinky Slicers, and the report is looking really nice.

One small glitch in the process is that whenever I change Slicer values, the Pivot Table columns automatically resize, leaving me with a number of cells with the inevitable “###” values. This requires me to auto expand the column to see the values again. Not an ideal solution to present to my Financial Director J

To overcome this small issue, simply go to the Pivot Table options, and unselect the “Autofit column widths on update” check box. Set the column widths to what you need, and you’re in the game.

Advertisements

  1. #1 by Unknown on March 11, 2010 - 5:42 pm

    Every time I create a new pivot table the default is to have "Autofit column widths on update" turned on.Is there a way to change the default to "Off"?

    • #2 by Gavin Russell-Rockliff on November 8, 2010 - 9:38 am

      Hey, nothing obvious to answer that one unfortunately 🙂
      Will keep looking around, or will just post a Connect feature to allow that default to change.

  2. #3 by Kraig on September 23, 2011 - 6:55 pm

    OMG! you saved me so much time as a newer user of pivot tables!!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: