ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 2736|回复: 2

Pivot Tables Behind the Scenes(透视表的幕后工作)

[复制链接]

TA的精华主题

TA的得分主题

发表于 2005-8-10 11:48 | 显示全部楼层 |阅读模式

As you might have guessed, all of this awesome functionality is not free. It's important to know that pivot tables do come with a few file space and memory implications for your system. To get an idea of what this means, let's take a look at what happens behind the scenes when you create a pivot table.

When you initiate the creation of a pivot table report, Excel takes a snapshot of your dataset and stores it in a pivot cache. A pivot cache is nothing more than a special memory sub-system in which your data source is duplicated for quick access. Although the pivot cache is not a physical object that you can see, you can think of it as a container that stores the snapshot of the data source.

Each pivot table report you create from a separate data source will create its own pivot cache that will increase your memory usage and file size. The increase in memory usage and file size depends on the size of the original data source that is being duplicated to create the pivot cache.

Your pivot table report is essentially a view that gets its data solely from the pivot cache. This means that your pivot table report and your data source are disconnected.

CAUTION

Any changes you make to your data source will not be picked up by your pivot table report until you take another snapshot of the data source, or "refresh" the pivot cache. Refreshing is easychoose the red exclamation point on the pivot table toolbar.

The benefit you get by working against the pivot cache and not your original data source is optimization. Any changes you make to the pivot table report, such as rearranging fields, adding new fields, or hiding items, are made rapidly and with minimal overhead.

纯转载,这个英文也不是很难,书名叫 Pivot Table Data CrunchingBy Bill Jelen, Michael Alexander...............................................Publisher: QuePub Date: June 21, 2005ISBN: 0-7897-3435-4Pages: 288

TLF上找来的

[此贴子已经被作者于2005-8-10 11:56:25编辑过]

TA的精华主题

TA的得分主题

发表于 2005-8-10 11:51 | 显示全部楼层
晕!

TA的精华主题

TA的得分主题

 楼主| 发表于 2005-8-10 11:52 | 显示全部楼层

Limitations of Pivot Table Reports

Pivot table reports have limitations that you must be aware of. Although some of these limitations remain constant regardless of available system memory, others are dependent on available system memory:

The number of row fields you can place in a pivot table is only limited by available memory.

Starting with Excel 2003, the number of unique items in a row field is limited to 32,500. Prior Excel versions have a limit of 8,000 unique row items in a row field.

You can have no more than 256 column fields (may be limited by available memory).

Starting with Excel 2003, the number of unique items in a column field is limited to 32,500. Prior Excel versions have a limit of 8,000 unique column items in a column field.

You can have no more than 256 page fields (may be limited by available memory).

Starting with Excel 2003, the number of unique items in a page field is limited to 32,500. Prior Excel versions have a limit of 8,000 unique page items in a page field.

You can have no more than 256 data fields.

The number of calculated items you can use in a pivot table is only limited by available memory.

The number of pivot table reports on a spreadsheet is only limited by available memory.

您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-11-1 11:33 , Processed in 0.027062 second(s), 9 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表