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