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.

Inconsistent formulas are not flagged as expected in Excel


View products that this article applies to.

This article was previously published under Q292475

↑ Back to the top


Symptoms

When you review the formulas in cells in a Microsoft Excel workbook, you may find a cell that is inconsistent with the surrounding formulas, but the cell is not flagged as inconsistent. Both background error checking and the rule for inconsistent formulas in a region are turned on.

↑ Back to the top


Cause

This behavior occurs when both of the following conditions are true in the surrounding formulas:
  • References to cells include the worksheet name.

    -and-
  • The worksheet name references are relative references instead of absolute references.

↑ Back to the top


Workaround

To work around this issue, avoid using worksheet names in references for cells in the same worksheet, and use absolute references to cells in other worksheets.

For example, if you want to reference cell C1 in a worksheet named Sheet1, change the following cell reference
=Sheet1!C1
to the following:
=C1
Also, change a relative reference to another sheet, such as
=Sheet2!C1
to an absolute reference such as the following:
=Sheet2!$C$1

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


Keywords: KB292475, kbpending, kbbug, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 292475
Revision : 3
Created on : 1/23/2007
Published on : 1/23/2007
Exists online : False
Views : 264