Replace crosstab table with PivotTable report ignoring criteria range.
用数据透视表报表替换交叉表，忽略条件范围。
The Refresh Data operation changed the PivotTable report.
“更新数据”操作更改了数据透视表报表。
You cannot apply data validation to cells in a PivotTable.
不能对透视表应用数据有效性检验。
The data range you have selected includes a PivotTable report.
选定的数据区域包括一张数据透视表报表。
Un-checking a checkbox will remove the field from the PivotTable.
不勾选复选框的话，这些字段就会从数据透视表中移除。
You can replicate the format of PivotTable and PivotChart views in a form.
可以复制窗体的数据透视表视图和数据透视图视图的格式。
To illustrate, here is the PivotTable I've been using for other examples today.
举例，这儿是今天我们在其他例子已经使用过的透视表。
You can also create PivotTable and PivotChart reports from a list of work items.
您也可以通过工作项列表创建数据透视表和数据透视图报表。
PivotTable view: A view that summarizes and analyzes data in a datasheet or form.
数据透视表视图：用于汇总并分析数据表或窗体中数据的视图。
References to subtotals and data items cannot be entered into PivotTable formulas.
在透视表公式中不能输入对分类汇总和数据项的引用。
Report filter. This area holds the fields that the whole PivotTable is filtered by.
报告筛选。这个区域保留整个数据透视表未被使用的字段。
Data will be saved with other PivotTables using the same source data as this PivotTable.
数据透视表保存的数据可与其他数据透视表共用同样源数据文件。
And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes.
现在透视表不再包括山地自行车和公路自车的分类汇总项目。
The Excel pivot table was correctly created so a PivotTable toolbar displays over the window.
Excelpivot表已正确创建，所以窗口上显示一个PivotTable工具栏。
As you add fields to the Values area of the PivotTable, the formatting is done automatically.
当你添加字段到数据透视表的数值区域时，格式会自动完成。
At the top are the PivotTable menu and some toolbar buttons to control the depth of the table.
顶部是PivotTable菜单和一些用于控制表深度的工具栏按钮。
Say you have the following PivotTable and you want to display all the available details for Canada.
比方说你有下面这样的透视表，你想显示所有“加拿大”有用的细节。
Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference.
在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。
There are four areas in a PivotTable, each of which is represented by a drop zone in the field list.
在数据透视表中有四个区域，在字段列表中每一个区域代表一个拖拽区域。
This TAB is designed to hold all the commands you would commonly use when working with a PivotTable.
这个标签用来容纳你在使用数据透视表时的所有常用命令。
This PivotTable is aggregating the source data using the Sum function. Now, let's try and change this to Count.
这个透视表是使用求和功能进行数据源汇总的。现在，让我们将它改为计数。
The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
数据透视表没有与下层数据共同保存。请使用“刷新数据”命令更新数据透视表。
They are part of a broader set of work that includes cell styles, chart styles, PivotTable styles, and document themes.
列表样式和单元格样式、图表样式、数据透视表样式以及文档主题一样，提供一组更便于操作的功能。
The example PHP application builds an Excel XML file that has one worksheet for the raw data and another for the PivotTable.
示例PHP应用程序构建一个ExcelXML文件，其中为原始数据和PivotTable 分别具有一个工作簿。
Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source.
下面是对话框的一个截图，举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。
Another thing we hear from PivotTable users all the time is that it is too difficult or slow to clear stuff off of a PivotTable.
我们从数据透视表用户那里经常听说的另外烦恼就是清除数据透视表中的数据太困难或是太慢。
Here is an example of a PivotTable displaying number formatting as defined on the server - in this case dollars with two decimals.
这里有个例子，数据透视表显示服务器上设计的数字格式——在本例中，为带两位小数位数的美元。
We got consistent feedback from many customers needing an easy way to turn this off so we added it to the PivotTable Options dialog.
我们从许多用户处得到同样的反馈，说是需要一种简单的方法关闭这个功能，于是我们将其添加到数据透视表选项对话框中。
"Tooltips on cells" controls whether tooltips are displayed when hovering over cells inside the PivotTable row, column and values areas.
“单元格工具提示”控制当鼠标停留在数据透视表的行、列及值区域里的单元格上面时是否显示工具提示。
"Tooltips on cells" controls whether tooltips are displayed when hovering over cells inside the PivotTable row, column and values areas.
“单元格工具提示”控制当鼠标停留在数据透视表的行、列及值区域里的单元格上面时是否显示工具提示。
应用推荐