XL97: AutoCalculate Is Inconsistent with Hidden Rows or Columns

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, versions 7.0, 7.0a

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component