更新相机工具快照 [英] updating camera tool snapshots
问题描述
我有一本工作簿,重新计算时非常慢。 当我重新计算工作簿中任何工作表上的任何单元格时,有什么东西导致了很大的延迟。 事实证明,这是导致延迟的一些相机工具快照。
首先,快速总结一下我的工作簿。 我在一个工作表中有原始数据,然后我有另外3个工作表,其中包含以不同方式汇总/分析原始数据的表格。 在另一张工作表中,我使用相机工具从这3张工作表中创建了几张表中的快照
,以便以不同的方式将它们组合在一起进行打印。 我从来不知道相机工具是如此耗费计算资源。 我使用该工具是因为它允许复制的表反映我在格式化到原始表时所做的任何
更改,而不必在多个工作表上进行更改。 有没有更好的方法呢?
I have a workbook and it was really slow when recalculating. Something was causing a big lag anytime I recalculated any cells on any of the sheets in the workbook. Turns out that it was some camera tool snapshots that were causing the lag. First, a quick summary of my workbook. I've got raw data in one worksheet then I've got 3 other worksheets which contain tables which summarize/analyze the raw data in different ways. On another worksheet, I used the camera tool to create snapshots of a few tables from those 3 worksheets to group their tables together in a different way for printing. I never knew that the camera tool was such a drain on calculation resources. I used that tool because it lets the copied tables reflect any changes I make in formatting to the original tables instead of having to make the changes on multiple sheets. Is there a better way to do this?
我做了一些搜索,我确实找到了一个技巧让Excel认为相机快照是静态图像,使用命名范围和"触发" 。细胞 基本上当"触发"时单元格为TRUE,相机快照为
live,如果为FALSE,则快照为静态。 但我想知道是否有一种标准化的方法,比如vba属性或者相当于Application.EnableEvents或ScreenUpdating但是对于相机工具图片? (我
确实尝试将ScreenUpdating设置为false但它没有帮助。)
I did some searching around and I did manage to find a trick to make Excel think the camera snapshots are static images, using a named range and a "trigger" cell. Basically when the "trigger" cell is TRUE, the camera snapshots are live and when it is FALSE the snapshots are static. But I was wondering if there is a standardized way of doing this, something like a vba property or the equivalent of Application.EnableEvents or ScreenUpdating but for camera tool pictures? (I did try setting ScreenUpdating to false but it didn't help.)
推荐答案
这是一个记录良好的问题(即快照自动时性能不佳)。
This is a well-documented problem (i.e. poor performance when snapshots are automatic).
最好手动完成,如下所示:
Best to do them manually as documented here:
您可以将它放在计时器上或使用按钮....无论如何。
You could put it on a timer or use a button....whatever.
这篇关于更新相机工具快照的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!