Excel: pivot table not displaying all fields

Question

The My Pivot table does not show all fields. I have some data that someone SQL-ed. I add two more columns to the data using Excel formulas. When I select all the data and click on "Insert Pivot Table", the table / range says:"Table_Query_from_ACTSQLServer"

Now, at this point, I said "OK"or manually selected a range to include the two new columns that I created, but in any case the pivot table (on a new sheet) does not contain two new rows that I created.

An additional piece of relevant information may be that the workbook already contains pivot tables that I made yesterday from the same data, but that was before I added two new columns. I hope I can use the new columns to update all earlier pivot tables only if they appear in the field list. Please, help!

Answer 1

This question has been asked and answered at answer.microsoft.com here .

The best answer seemed to be to use an Excel spreadsheet as the data source range for the pivot table, and not just for cell ranges.

22 2011 .
MacG31 21 2011 .
,
2007 1. (, ).
2. ,
3. ( ),
4. .

, Pivot Cache . / . ,
.

Answer 2

, , SQL-.

, , , , , , .

, "".