How to surpress green triangle's in cells?

[DougStroud]

I have a long column tha contain those little green triangles. How can these be removed w/out clicking on each one and instructing to ignore? This would take forever...

Thanks,

Doug S.

 

[atmospheric]

Just a guess.....Tools/Options/Error Checking....untick "Unlocked Cells containing Formula's"

 

[DougStroud]

You guessed correctly,


thnks