Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between Application.Calculate and Application.CalculateFull?

Tags:

excel

vba

What is the difference between Application.Calculate and 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.

like image 875
zaptask Avatar asked May 26 '16 11:05

zaptask


1 Answers

Calculate calculates only new, changed and volatile formulas.

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

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

like image 156
Rory Avatar answered Oct 19 '22 22:10

Rory