Delay Calculation of Worksheet Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook that has many simple functions moving data around to
different cells and processing some if statements on some of the data. The
problem that I am running into is all of the data is initially pulled in from
a SQL DB, and I believe that the workbook is calculating many of it's if
statements, prior to all of the SQL data being loaded, therefore, it is
coming up with the wrong result. Is there a way to delay the calculation of
all the basic worksheet functions, so that I can ensure that all the data is
in the workbook from SQL, before they all fire. This may have to be done in
a macro, in which case I apoligize for putting this in the wrong catagory.

Thanks in advance.....any help would be appreciated.
 
Tools--Options--Calculation--Manual Calculation

Press F9 to force a calculation once you have set the wb to manual.

Dave
 
I had initially tried that, but it appears that all the formulas are already
calculated when I open the workbook, therefore, they are not delayed??
 
Back
Top