Excel 2003 - Error Checking Feature - Error?

  • Thread starter Thread starter PT
  • Start date Start date
P

PT

I have a spreadsheet with a single column of numbers, including a few
formulas creating sums of figures in the column. The spreadsheet was
created in Excel 2000, and has no errors.

However in Excel 2003, several of the formula cells have a small triangle in
the upper LH corner. If I select these cells, I see an icon with a yellow
exclamation point. If I click it open, it tells me that my cell contains a
formula error (it doesn't). Furthermore the error it thinks it discovered
is "Formula in this cell refers to a range that has additional cells next to
it". If I allow it to "correct the error", it does so, leaving the
identical formula in the cell.

What is going on?
 
"Error checking" was a new feature in Excel 2002. It doesn't mean there is
an error just that there might be. In this case Excel sees there is similar
data adjacent to the range your formula is referencing, so you might not be
referencing the entire range you should.

You can modify the errors this feature reports, or turn it completely off,
under Tools, Options, Error Checking.
 
Back
Top