Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


There are two possible situations where you might see this message:

  • You see a green triangle in the upper-left corner of a cell that contains a formula.

  • You are evaluating errors in the Error Checking box.


By default, all cells are locked to protect them from accidental or unauthorized changes. In this case, the cell containing the formula is not locked for protection.


Lock the cell by doing one of the following:

  • Select the Error Checking button Button image next to the cell, and then select Lock Cell.

  • In the Error Checking box, select Lock Cell.

Protecting cells that contain formulas prevents them from being changed, and can help avoid future errors. However, locking the cell is a first step, and you must perform additional operations to protect the workbook, such as setting a password.

For more information about how to protect a workbook, see Protect a worksheet.

Note: You can leave the cell unlocked if you prefer to leave it unprotected. However, the message will continue to appear unless you disable this error checking rule.

For more information about how to control error checking, see Detect errors in formulas in Excel.

See Also

Lock cells to protect them

Display or hide formulas

Password protect a workbook

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!