Excel 2007 Pivot Tables: Refreshing upsets my manual formatting

1

How can I stop a refresh on Pivot Tables from ruining my manually configured columns widths? I'd like to be able to make the columns fixed. The columns will always be the same ones, but the data obviously changes and new data goes in to those columns.

Any pointers, guidance, or workarounds are much appreciated.

Mike.

RocketGoal

Posted 2010-06-09T18:30:07.493

Reputation: 1 468

Answers

3

Right mouse click in the pivot table and select PivotTable Options. Then on the layout & Format tab, unclick "Autofit column widths on update".

Knox

Posted 2010-06-09T18:30:07.493

Reputation: 1 168

Ironically I found this hidden gem this morning. – RocketGoal – 2010-06-11T13:19:26.743

don't ask me why the default is to adjust them. I'm always unclicking it. – Knox – 2010-06-11T21:17:56.727

Asked: 2010-06-09T18:30:07.493

Viewed: 893 times

Active: 2010-06-09T18:55:13.610