New fields not showin up in pivot table.
 

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?

New fields not showin up in pivot table.
 

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 he

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

Jim Moberg wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html