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