View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Volker Hetzer Volker Hetzer is offline
external usenet poster
 
Posts: 5
Default Stopping formula computations during entering data...

Hi!
We've got a sheet with lots of data and want to insert lots of
formulas using VBScript. Now, every time we insert a formula
the whole sheet gets recomputed and the thing runs three hours.
Is there a way to make Excel stop calculating and turn it on later?
Lots of Greetings!
Volker