ID: Q125271
5.00 WINDOWS kbother
The information in this article applies to:
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.
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.
To work around this behavior, do either of the following:
-or-
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.
For additional information, please see the following article(s) in the Microsoft Knowledge Base:
ARTICLE-ID: Q111491
TITLE : XL5: XL5GALRY.XLS Opened As Hidden Workbook
For an Overview Of Controlling Calculation, choose the Search button in Help and type:
controlling, calculation
Additional reference words: 5.00
Version : 5.00
Platform : WINDOWSLast Reviewed: September 14, 1996