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"
我的Pivot表没有显示所有的字段。我有一些数据是别人整理的。我使用Excel公式向数据添加了另外两列。当我选择整个数据并单击insert Pivot表时，表/范围显示:“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.
现在，我已经输入了“OK”，或者手动选择了范围来包含我创建的两个新列，但是无论哪种情况，Pivot表(在新表中)都不包含我创建的两个新行。
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!!
另一个相关信息可能是，工作簿中已经包含了我昨天从相同数据中生成的数据透视表，但那是在我添加两个新列之前。我希望能够使用新的列更新所有早期的pivot表，只要它们出现在字段列表中。请帮助! !
2 个解决方案
#1
4
This question was asked and answered over on answers.microsoft.com here.
这个问题在这里的answer .microsoft.com上被提出并回答。
The best answer seemed to be to use an Excel Table as the data source range of the pivot instead of just cell ranges.
最好的答案似乎是使用Excel表作为pivot的数据源范围，而不仅仅是单元格范围。
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.Shane Devenshire在2011年1月22日回复了2011年1月21日MacG31的回复，2007年你可以很简单的解决这个问题。将源数据定义为表(插入、表)。2。创建一个新的pivot表，3。将一个新字段添加到表右侧的列(而不是pivot表)，4。让人耳目一新。
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.
您也可能是没有更新Pivot缓存的受害者。尝试清理旧的项目/字段并刷新工作簿中的每个pivot表。你可以看看我在这里或这里使用过的那种通道。
#2
0
I just had almost an identical problem except initial data was not created from SQL query.
我刚刚遇到了一个几乎相同的问题，只是初始数据不是由SQL查询创建的。
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.
简单地遍历并刷新工作簿中使用添加了列的数据的所有现有的pivot表，然后刷新我希望新列作为pivot表字段出现的新pivot表，就可以了。
To refresh pivot table, right click in table and click refresh.
要刷新pivot表，右键单击表并单击refresh。
#1
4
This question was asked and answered over on answers.microsoft.com here.
这个问题在这里的answer .microsoft.com上被提出并回答。
The best answer seemed to be to use an Excel Table as the data source range of the pivot instead of just cell ranges.
最好的答案似乎是使用Excel表作为pivot的数据源范围，而不仅仅是单元格范围。
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.Shane Devenshire在2011年1月22日回复了2011年1月21日MacG31的回复，2007年你可以很简单的解决这个问题。将源数据定义为表(插入、表)。2。创建一个新的pivot表，3。将一个新字段添加到表右侧的列(而不是pivot表)，4。让人耳目一新。
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.
您也可能是没有更新Pivot缓存的受害者。尝试清理旧的项目/字段并刷新工作簿中的每个pivot表。你可以看看我在这里或这里使用过的那种通道。
#2
0
I just had almost an identical problem except initial data was not created from SQL query.
我刚刚遇到了一个几乎相同的问题，只是初始数据不是由SQL查询创建的。
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.
简单地遍历并刷新工作簿中使用添加了列的数据的所有现有的pivot表，然后刷新我希望新列作为pivot表字段出现的新pivot表，就可以了。
To refresh pivot table, right click in table and click refresh.
要刷新pivot表，右键单击表并单击refresh。