Pivot Table Formatting Question 1

[ccepaulb]

I have a pivot table set-up under a formatted table on an Excel worksheet. The problem I am having is that whenever I toggle or change something within my pivot table, it changes the formating of the cell and columns adjacent to it.
Is there a way to set-up a pivot table so that it does not change any formatting when changed? (especially the column widths)?

Thanks, Paul

 

[SkipVought]

Hi,

No -- record a macro that formats your sheet the way you want and use it after you refresh your table.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ccepaulb]

That's what I was afraid of...Thanks

 

[KenWright]

The following will change all fields to a number format, and you could simply assign it to a toolbar button and set it up to do the most common one you use, and then fix any odd cols manually.

Sub PivFormat()

For Each pt In ActiveSheet.PivotTables
For Each pf In pt.DataFields
pf.NumberFormat = "#,##" & s
Next pf
Next pt

End Sub


Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------