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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Fields not showing 2
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot table formulas 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Pivot Table field names don't match 1
Count of Non-Zero pivot table entries 1
Pivot Table Refresh not working properly 1

Back
Top