formula error triangles

[Les P]

Could anybody tell me how to get rid of, or edit, those
annoying error triangles in excel xp. It picks up errors
that aren't, such as calculating a mean for a range and
omitting an ajoining column that you don't want included
anyway gets reported as an error with black triangles in
every cell of that column.

Many thanks

 

[Biff]

Tools>Options>Error Checking Tab>Rules

Uncheck which ever you don't want. Personally, I have them
all unchecked!

Biff

 

[papou]

Hi
Chech for options in Tools, Options and "Error tracking" tab (please note I
have a French version of Excel so this option may vary (this may be a bad
translation)

HTH
Cordially
Pascal