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
--
Brevity is the soul of wit.


"Brian C" wrote:

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.

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??

"Dave F" wrote:

Tools--Options--Calculation--Manual Calculation

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

Dave
--
Brevity is the soul of wit.


"Brian C" wrote:

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.