Peter Aitken

Posts: n/a

Thanks!

"Debra Dalgleish" wrote in message
...
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

Peter Aitken wrote:
Am I correct in believing that there is no way to change the column
widths in a PivotTable and have them preserved during updates?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Sorting in PivotTable	Aaron Howe	Excel Discussion (Misc queries)	5	July 12th 05 09:49 PM
Pivottable - consolidating data -	winwinweb	Excel Worksheet Functions	1	February 15th 05 01:18 AM
Pivottable Dates	JayBee	Excel Discussion (Misc queries)	5	January 15th 05 08:43 PM
PivotTable - Count by Month	Gigi	Excel Worksheet Functions	3	January 1st 05 12:30 PM
PivotTable Column Field Values	Michael Rekas	Excel Discussion (Misc queries)	2	December 10th 04 02:18 PM

All times are GMT +1. The time now is 05:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us