Pivot Table Fields

  • Thread starter Thread starter Fritz
  • Start date Start date
F

Fritz

I added a couple of columns to an Excel 2007 spreadsheet. When I went to
generate a pivot table, all but one of the fields that I added do not show in
the field list. I've refreshed the table, got out Excel & tried again all
with no luck. Anybody have any suggestions as to why all the fields are not
showing?
 
You'll have to change the source data range to include all the new columns.

Select a cell in the pivot table
On the Ribbon, click the Options tab
Click Change Data Source, and click Change Data Source
Change the Table/Range reference to include all the new columns.
 
Back
Top