My Pivot table is not showing all the fields. I have some data that someone SQL-ed. I add two more columns to the data using Excel formulas. When I select the entire data and click on insert Pivot Table, the Table/Range says : "Table_Query_from_ACTSQLServer"
Now, at this point I have said "OK"
or manually selected the range to include the two new columns that I created but in either case the Pivot Table (in the new sheet) does not contain the two new rows that I created.
An additional piece of pertinent information might be that the workbook already contains Pivot Tables I made yesterday from the same data but that was before I had added the two new columns. I hope to be able to use the new columns to update all the earlier pivot tables, if only they show up on the field list. Please help!!
Best Answer
This question was asked and answered over on answers.microsoft.com here.
The best answer seemed to be to use an Excel Table as the data source range of the pivot instead of just cell ranges.
You may also be a victim of the Pivot Cache not being updated. Try clearing the old items/fields and refreshing each pivot table in your workbook. You can take a look at the walk-through that I used here
or here.