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.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Fields not showing 2
Pivot Table Field no showing 0
Dates In Excel 5
Pivot table 0
Pivot Table Counting Text Data 0
Power Pivot. Yikes. 0

Top