ExcelBanter - Pivot Table Fields

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pivot Table Fields (https://www.excelbanter.com/excel-programming/438905-pivot-table-fields.html)

Fritz

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?

minimaster

Pivot Table Fields

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"

All times are GMT +1. The time now is 08:56 AM.