Excel 2003 - Error Checking Feature - Error?

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?
 
J

Jim Rech

"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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top