Pivot Table Fields

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?
 
D

Debra Dalgleish

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.
 
Top