Formula Errors

[Andrew]

When I copy over data from a database at work I get all
sorts of "Formula Errors" that aren't errors. You can
click on the little "!" and tell it to ignore it, but
there are a ton of them. Is there any way to tell it at
once to remove all of the errors?

Thanks for your help,

Andrew

 

[dav]

Under tools options error checking you can uncheck items
that you'd rather not have it show an error for.
Otherwise, click on a cell that has an error, highlight
from there to all other cells with error and then hit
the "!" and ignore.

 

[Alan]

Apologies for the incorrect date, this has been rectified now.

 

[Alan]

I believe you are referring to the Smart tags in later XL versions, Try
this,
Go 'Tools' > 'Options' > 'Error Checking' and uncheck some or all of the
rules there, the most common ones I found were
'Inconsistent formulas in region' and 'Unlocked cell containing formulas'
Personally, I got rid of all of them!
Regards,