A
Andrew Haddleton
I have a suite of complex spreadsheets working in Excel
2000 (and previously Excel 1997). I havew tried to
upgrade to Excel XP and notice a problem.
My spreadsheet system has VB code which enters formulas
and data into workbooks. While this is going on I put a
Application.Calculation = xlCalculationManual and turn it
back to automatic at the end of the code which is
inserting. Suddenly in Excel XP when the line is reached
that turns off calculation the code stops for a noticeable
period of time - almost like every cell is being
recalculated even when it doesn't need to be. This did
not happen in previous versions of Excel and wonder if
anyhone knows what is going on and how I can get round it
Thanks for reading
2000 (and previously Excel 1997). I havew tried to
upgrade to Excel XP and notice a problem.
My spreadsheet system has VB code which enters formulas
and data into workbooks. While this is going on I put a
Application.Calculation = xlCalculationManual and turn it
back to automatic at the end of the code which is
inserting. Suddenly in Excel XP when the line is reached
that turns off calculation the code stops for a noticeable
period of time - almost like every cell is being
recalculated even when it doesn't need to be. This did
not happen in previous versions of Excel and wonder if
anyhone knows what is going on and how I can get round it
Thanks for reading