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?
|