New fields not showin up in pivot table.

J

Jim Moberg

I have a pivot table that reads it's data from a separate worksheet (sheet 1)
in the same workbook. I recently added some fields to the query in MS-Query
and put the data into sheet 1. I was expecting to see the new fields in the
Pivot Table field list and they are not. Any ideas as to why this is
happening?
 
D

Debra Dalgleish

If the new fields are outside the pivot table's data range, they won't
show up in the field list. To adjust the range:

Right-click a cell in the pivot table
Choose PivotTable Wizard
Click the Back button, and select the new range
Click Finish.

Or use a dynamic range as the pivot table source, and it will adjust
automatically. There are instructions here:

http://www.contextures.com/xlPivot01.html
 
Top