From: Fritz on
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?

From: minimaster on
Did you add the new columns in the pivot table source data definition?
The dialog for that can be found on the ribbon "Pivottable Tools /
Options" - "Change Data source"