Application.Calculate和Application.CalculateFull有什么区别? [英] What is the difference between Application.Calculate and Application.CalculateFull?

问题描述

Application.Calculate和Application.CalculateFull有什么区别?

https://msdn.microsoft.com/en-us /library/office/ff195517.aspx

https://msdn.microsoft.com/en-us /library/office/ff194064.aspx

对此我不知道它们是否会导致不同的结果，或者它们的范围或效率是否不同.

Looking at this I don't know if they may result in different results or their scope or efficiency is different.

推荐答案

Calculate仅计算新的，更改的和易变的公式.

Calculate calculates only new, changed and volatile formulas.

CalculateFull会计算所有公式.通常，这会比较慢.

CalculateFull calculates all formulas regardless. As a general rule, this will therefore be slower.

CalculateFullRebuild计算所有公式并重建整个计算依赖关系树.这将是最慢的.

CalculateFullRebuild calculates all formulas and rebuilds the entire calculation dependency tree. This will be the slowest of all.

这篇关于Application.Calculate和Application.CalculateFull有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！