Unprotected formula "error"

Every time I enter a formula now, even with AutoSum, I get an unprotected formula error and a little green triangle in the upper left corner of the cell. The "fix" is to protect the cell. This annoys me on several levels:

1. I might not want to protect the formulas against accidental change, especially if I am still developing the spreadsheet.
2. It rankles me every time I see "Help on this error" and "Ignore error." If it has to say anything, "Help on this issue" or "Ignore" would be preferable, as it is rather presumptive on Microsoft's part to declare that I too stupid to enter a formula correctly and have made a mistake, i.e., "Formula omits adjacent cells."

Anyway, kindly regard annoyance #2 as aimless rambling, and someone kindly tell me how to convince Excel not to flag my formulas as unprotected.

Good afternoon Andy33

Hmmmmm, used to bug me too, years ago. Till I turned it off.

You can turn all error checking off, or just select which "errors" you want highlighting.

I'm using Excel '13, but you just click on the "FILE" button > Options > Formulas and use the Error Checking section to turn it off completely, or Error Checking Rules to determine which "errors" will be pointed out to your clumsy error-prone self.

HTH

DominicB

Thank you. I knew there was some place I could turn it off. I would mark this as solved, but neither of the methods in FAQ work.