Column Resizing and Pivot Tables
Does anyone out there get frustrated when updating or changing a pivot table
causes all columns in the worksheet to be resized? Does anyone know how to turn this "resizing" feature off? |
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTableTable Options Add a check mark to 'Preserve formatting', click OK Remove the check mark from AutoFormat Table Click OK Schmeebs wrote: Does anyone out there get frustrated when updating or changing a pivot table causes all columns in the worksheet to be resized? Does anyone know how to turn this "resizing" feature off? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 01:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com