Question about the number of formulas calculate per minutes


#1

Hello,

I currently have a page containing many formulas. Do you know how to make sure that certain parts of the sheet are calculated before others so that you can perform these 10,000 calculations without having a bug? For example, limit the number of calculations to be done per minute or even make sure to validate by hand part by part?

thank you very much !


#2

Calculating different parts can probably be done with additional if statements in the formulas and triggering new formulas when earlier formulas produce a certain result. Otherwise VBA is a good tool for this task.

Reducing the number of calculations can also be handled with adding delay, if you mean Seotools formulas such as Xpath etc.