XL97: Clicking Row or Column Divider Causes Recalculation
Article ID: 167672
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q167672
SYMPTOMS
When you click a row or column divider in Microsoft Excel, all open
workbooks are unexpectedly recalculated.
CAUSE
This problem occurs if both of the following conditions are true:
- Calculation for the active workbook is set to Automatic.
-and-
- You click the row or column divider but do not resize the column or row.
STATUS
Microsoft has confirmed this to be a problem with the Microsoft products
listed at the beginning of this article.
WORKAROUND
To prevent Microsoft Excel from recalculating values when you click the row
or column header, set the calculation mode to Manual. To do this, use the
following steps:
- On the Tools menu, click Options.
- In the Options dialog box, click the Calculation tab. Click Manual
to select the manual calculation mode.
NOTE: With the manual calculation mode, formulas are not recalculated
automatically. This may cause formulas to appear incorrect. To recalculate
the values on the sheet at any time, press F9.
Additional query words: XL97
Keywords: kbprb KB167672