XL2002: Inconsistent Error Flags for Formulas in Worksheet Cells

Article translations Article translations
Article ID: 277614 - View products that this article applies to.
This article was previously published under Q277614
Expand all | Collapse all

SYMPTOMS

In Microsoft Excel, when a formula in a cell is modified, you may receive a warning flag with the following message:
The formula in this cell differs from the formulas in this area of the spreadsheet.
However, when a changed cell causes another cell to have a formula that is inconsistent with the cells in its immediate area, that cell may not be flagged as expected.

CAUSE

This behavior can occur when you change several cells in a range of cells that contain similar formulas, and the changes to those cells cause another cell to have an inconsistent formula.

STATUS

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

MORE INFORMATION

The warning flags are not the same as error messages. The flags do not necessarily indicate an error, and as long as the formula is valid, the formula continues to return valid data.

Properties

Article ID: 277614 - Last Review: January 29, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbbug kbpending KB277614

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com