D
David Lipetz
In Excel 2003 SP3, I though setting Calculation to Manual
(Tools/Options/Calculation/Manual) was an application setting rather than a
workbook setting.
However, I saved a workbook while Calc was set to Manual and distributed it
to a colleague for use. When it was openend, he reported that none of the
cells were populating correctly as they had been before. I called him and
discovered that calculation was set to Manual and that he did not make that
setting change.
After futzing around, it does appear that the setting is stored in the
workbook so opening a workbook can change the application setting. Is this
the correct behavior? I would prefer that Options be managed by the
application and not the workbook.
David
(Tools/Options/Calculation/Manual) was an application setting rather than a
workbook setting.
However, I saved a workbook while Calc was set to Manual and distributed it
to a colleague for use. When it was openend, he reported that none of the
cells were populating correctly as they had been before. I called him and
discovered that calculation was set to Manual and that he did not make that
setting change.
After futzing around, it does appear that the setting is stored in the
workbook so opening a workbook can change the application setting. Is this
the correct behavior? I would prefer that Options be managed by the
application and not the workbook.
David