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.
#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.
#3 by Kraig on September 23, 2011 - 6:55 pm
OMG! you saved me so much time as a newer user of pivot tables!!!!