Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Clicking Row or Column Divider Causes Recalculation


View products that this article applies to.

This article was previously published under Q212162

↑ Back to the top


Symptoms

When you click a row or column divider in Microsoft Excel, all open workbooks may be unexpectedly recalculated.

↑ Back to the top


Cause

This behavior can occur 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.

↑ Back to the top


Workaround

To prevent Excel from recalculating values when you click the row or column header, set calculation to Manual. To do this, follow these steps:
  1. On the Tools menu, click Options.
  2. In the Options dialog box, click the Calculation tab. Under Calculation, click Manual.
NOTE: With manual calculation selected, formulas are not recalculated automatically. This may cause formulas to appear incorrect. To recalculate the values on the sheet at any time, press F9.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in Excel 2000.

↑ Back to the top


Keywords: KB212162, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 212162
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 239