Pivot Table Fields
 

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?

Pivot Table Fields
 

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.


Fritz wrote:
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?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com