Menu
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!!
466
If the PivotTable Field List task pane does not appear automatically, follow these steps to enable it: Click any cell in the pivot table layout. On the Excel Ribbon, click the PivotTable Analyze tab. Then in the Show group (at the far right), click the Field List command.
Make sure that the slicer you insert is present in your pivot table filter area. Then only it will work properly. E.g If you insert a slicer for Employees Name, That field should exist in your pivot table filter area as well.
Right click at any cell of the pivot table, and select Hide Field List option from the context menu. If you want to show the Field List again, right click at the pivot table, and select Show Field List.
Add an Additional Row or Column Field Click any cell in the PivotTable. The PivotTable Fields pane appears. You can also turn on the PivotTable Fields pane by clicking the Field List button on the Analyze tab. Click and drag a field to the Rows or Columns area.
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.
Shane Devenshire replied on January 22, 2011
Reply In reply to MacG31 post on January 21, 2011
Hi,
In 2007 you can solve this problem very simple by
1. defining the source data as a Table (Insert, Table).
2. Creating a new pivot table,
3. Adding a new field to the column adjacent to the right side of the Table (not the pivot table),
4. Refreshing.
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.
188
I just had almost an identical problem except initial data was not created from SQL query.
Simply walking through and refreshing all existing pivot tables in the workbook that used the data that I had added columns to, and then refreshing the new pivot table I wanted the new columns to appear as a pivot table field in, worked.
To refresh pivot table, right click in table and click refresh.
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
