Pivot Table fields

  • Thread starter Thread starter CLou
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - NUMBER FORMAT option does not appear in field settin 3
date filter in a pivot table 1
Pivot Table - Currency Format 1
Column width of Pivot Table data goes back to default when data refreshed 2
Mass format change of 'data' in pivot table 1
Pivot table grand total location 1
Pivot tables and column widths 1
Refreshing Pivot Tables 1

Back
Top