Pivot Table fields

C

CLou

Is there a way to format multiple pivot table fields at
one time and have them refresh that way, rather than
having to select each column and choose the format
options?

Thanks
 
B

Bruce

CLou:
I think the solution for you is to open the Pivot Table
Toolbar and select the Field Settings icon. This sets the
format for all results for that particular field.
One limitation that I haven't found a way around is
getting a preferred column size to "stick" and not reset
after a table refresh.
Bruce
 
A

AlfD

Hi Bruce:

I find that the pivot table wizard Options>uncheck AutoFormat Tabl
helps with holding column widths on refresh.

Al
 
Top