View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default how to get excel to calculate from ASP?

<<Normally, Excel waits until all macros have ended before calling the
recalculation engine.

Experiment results: No longer true, in Excel 2000. Setting
Application.Calculation = xlCalculationManual stops calculation, but it
automatically resumes as soon as Application.Calculation =
xlCalculationAutomatic is executed.

Excel Recalculation articles:

"Excel Recalculation"
http://msdn2.microsoft.com/en-us/library/bb687891.aspx

"Recalculation in Microsoft Excel 2002"
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
--
Regards,
Bill Renaud