Waiting for recalculation in Excel 2007

Add-in Express™ Support Service
That's what is more important than anything else

Waiting for recalculation in Excel 2007
 
Johan Lombaard




Posts: 3
Joined: 2007-09-17
I have a complex spreadsheet with a formula that takes relatively long to calculate ( it references other sheets ).
My code has a loop that puts values in the input cell and retrieves them from the formula's output.
In Excel 2003 it works fine, but in 2007 it "runs away" from the recalculation, resulting in "old" values being retrieved.
Is there a way to force my code to wait for the recalculation to finish, or is there a function that I can pass the formula to and get the value back ?
Posted 10 Oct, 2007 10:30:27 Top
Sergey Grischenko


Add-in Express team


Posts: 7228
Joined: 2004-07-05
Hi Johan.

I would advise you to use UDF or XLL add-ins to always retrieve the actual values from your formulas.
Posted 10 Oct, 2007 11:00:23 Top
Johan Lombaard




Posts: 3
Joined: 2007-09-17
Hi Sergey
Thanks for the reply. Please forgive my ignorance, but what do you mean by "UDF or CLL" add-ins. I could not find a reference to it in the Add-In-Express .NET documentation.
Posted 11 Oct, 2007 03:01:51 Top
Sergey Grischenko


Add-in Express team


Posts: 7228
Joined: 2004-07-05
Hi Johan.

The UDF is a User Defined Function. You can develop such functions using the 'COM Excel Add-in Module' new item wizard in Visual Studio.
The XLL is an add-in developed using the XLL technology of Excel. To get the XLL module in your project please use 'ADX XLL Add-in' wizard.
Posted 11 Oct, 2007 11:58:09 Top