XL5: Cells Recalculate When You Choose the Options Command

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you choose Options from the Tools menu, Microsoft Excel starts calculating the cells on your worksheet, and the Options dialog box is not displayed until Microsoft Excel finishes calculating the worksheet, or until you interrupt the calculation.

NOTE: This behavior is really only noticeable with worksheets that contain a large number of formulas that take a few minutes to be calculated.


CAUSE

This behavior occurs because cells on the active worksheet are calculated when you open a workbook, even if the cells were already in the process of being calculated. When you choose Options from the Tools menu, Microsoft Excel opens the file XL5GALRY.XLS to access the chart autoformats. This causes the cells on the active worksheet to be recalculated.

Note that this behavior only occurs if you have not used the Options dialog box in the current session of Microsoft Excel. Microsoft Excel only opens the XL5GALRY.XLS file one time per session, the first time you choose Options from the Tools menu.

WORKAROUNDS

To work around this behavior, do either of the following:


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c.


MORE INFORMATION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

Q111491 XL5: XL5GALRY.XLS Opened As Hidden Workbook


REFERENCES

For an Overview Of Controlling Calculation, choose the Search button in Help and type:

controlling, calculation

Additional query words:

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: September 20, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.