Excel 2000 vs Excel XP

[Steve Enk]

I have a worksheet that, when brought up under Excel XP,
goes thru an extensive recalculation of all of the cells.
The worksheet has quite a bit of data in it, uses the
Transform function a lot, etc. If any change is made to
the worksheet, the whole process starts over again.
However, when this worksheet is opened under Excel 2000 it
doesn't do this. Not does it go thru this recalc when a
change is made. The obvious Recalcution option is set to
Automatic in both cases.

There must be some option that is affecting this that is
different between the two versions of Excel. The same
problem occurs when going to Excel 2003.

Has anyone encountered this?

 

[Charles Williams]

Hi Steve,

If in Automatic mode Excel XP recalculates a workbook when it opens it if it
was last recalculated and saved in a previous version. I think this recalc
is probably a full calculation (all the formulae in the workbook).
(Excel 2003 does the same).

So if you save it using Excel XP this behaviour will probably stop.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm