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