Excel Home

VIII -推迟数据透视表更新

译者:hxhgxy  来源:http://blogs.msdn.com/excel

PivotTables VIII: “Defer Layout Update”, or adding multiple fields in one fell swoop
数据透视表 VIII:“推迟布局更新”,还是猛然添加很多字段

In this article, I’ll cover a small yet very useful PivotTable feature – deferring PivotTable updates. In current versions of Excel, PivotTables are updated each time a field is added, removed, or moved to a different position. For PivotTables based on large data sets, these actions can take some time to complete, meaning, for example, you end up waiting 7 times if you create a new a PivotTable and add 7 fields.

To address this scenario, we have added a feature to Excel 12 that allows you to control when the PivotTable is updated. As some of you may have noticed in screenshots in previous blogs, there is a checkbox and a button at the bottom of the field list.
为了实现该方案,我们在Excel 12里添加了一个功能,让你可以控制何时更新数据透视表。你们中有些人可能已经注意到前面日志中的截屏,在字段列表的下面有一个勾选框和一个按钮。

“Defer Layout Update” controls

When this checkbox is checked, the “Update” button next to it becomes enabled, and now you can add, remove and move fields around without the PivotTable updating itself. When you are done arranging fields, you press the Update button, and the PivotTable does one and only one update.

Here’s an example. I created a new PivotTable, checked the Defer Layout Update check box, and then added four fields. At this point, my PivotTable is still empty. Now, I’ll press the “Update” button to apply the changes.


And the PivotTable is modified with a single update.


By the way, the label “Defer Layout Update” is a work in progress, so if you have a suggestion for something which better conveys to you what this feature is all about, please post your suggestions as comments here. We are currently evaluating different names for this feature and would love any feedback you might have.
顺便说一下,“Defer Layout Update”标签仍然是在进行中的工作,因此,如果你有什么建议能够更好地传递该功能是什么意思的话,请在下面的意见栏里发表你的建议。我们正在考虑该功能的不同名称,欢迎任何反馈。

In my next post I will start a series of topics covering PivotTables based on OLAP data sources. Specifically I’ll be highlighting support for all the great new features of Microsoft SQL Server 2005 Analysis Services.
在我的下一篇文章里,我将开始一系列关于基于OLAP数据源的数据透视表的主题。我将具体强调对Microsoft SQL Server 2005 Analysis Services强大新功能的支持。

Published Thursday, December 22, 2005 10:28 AM by David Gainer

注:本文翻译自http://blogs.msdn.com/excel,原文作者为David Gainer(a Microsoft employee),Excel home授权转载。严禁任何人以任何形式转载,违者必究。

未经允许不得转载:ExcelHome » VIII -推迟数据透视表更新
分享到: 更多 (0)

本站特聘法律顾问:李志群律师   沪ICP备11019229号-2

沪公网安备 31011702000001号