XL97: AutoCalculate Is Inconsistent with Hidden Rows or Columns (178240)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 95 7.0a
This article was previously published under Q178240

SYMPTOMS

In Microsoft Excel, the AutoCalculate feature may display a sum on the status bar that appears to be incorrect.

NOTE: The AutoCalculate allows you to view the total value for a selected range of cells in the status bar.

CAUSE

This problem occurs when the cell range you select contains cells that are in hidden rows. The AutoCalculate feature ignores values in selected cells that are in hidden rows. Note that AutoCalculate does not ignore values in selected cells that are in hidden columns.

WORKAROUND

To work around this problem, unhide the hidden rows. To do this, follow these steps:

  1. Select cells in the row above and the row below the hidden rows.
  2. On the Format menu, point to Row, and then click Unhide.
NOTE: If the first row of a worksheet is hidden, click Go To on the Edit menu. Type A1 in the Reference box, and click OK. Point to Row on the Format menu, and then click Unhide.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about unhiding rows, click the Office Assistant, type How do I unhide rows? click Search, and then click to view "Display hidden rows or columns."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

120802 Office: How to Add/Remove a Single Office Program or Component

Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbprb kbui KB178240
©2004 Microsoft Corporation. All rights reserved.