How to Disable Formula Error Warnings in Excel 2016
Question details
The user wants to stop Excel 2016 from displaying formula error warnings when opening a legacy workbook.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Opening an older workbook created over several years that repeatedly triggers formula error indicators.
- Observed behavior
- Excel 2016 continuously displays background formula error warnings and green triangle indicators upon opening the file.
Before turning off error warnings entirely, check if the warnings are indicating actual calculation issues or just formatting inconsistencies. While disabling the warnings hides the indicators, correcting the underlying broken formulas is highly recommended to ensure data accuracy.
Disable Background Error Checking in Excel Options
Turn off the background error checking feature globally to stop Excel from flagging cells with green triangles for formula errors.
This method disables the global background error checking in Excel 2016. It is highly effective for legacy workbooks where older formulas frequently trigger false positives.
Click on the 'File' tab in the top-left corner of the Excel 2016 ribbon, then select 'Options' from the bottom of the left-hand menu.
In the Excel Options dialog box, click on the 'Formulas' category located on the left pane.
Scroll down to the 'Error Checking' section and uncheck the box labeled 'Enable background error checking'. Click 'OK' to apply the changes.

Disable Specific Error Checking Rules
Keep general error checking active but turn off the specific rules that are triggering false alarms in your legacy workbook.
Manage Formula Errors Easily with WPS Spreadsheet
WPS Office provides a clean, user-friendly interface to manage formula errors, evaluate complex calculations, and customize error checking rules. It is fully compatible with Excel formats and offers a lightweight solution for large legacy files.
- 1. Open your Workbook in WPS: Launch WPS Office and open your existing .xlsx or .xls file.
- 2. Access Options: Click the 'Menu' button in the top left corner of the spreadsheet interface, then click on 'Options'.
- 3. Navigate to Error Checking: In the Options window, go to the 'Error Checking' tab on the left-hand side.
- 4. Toggle Error Indicators: Uncheck 'Enable background error checking' or clear specific rule checkboxes to hide unwanted green triangle indicators. Click OK to save your preferences.

Frequently Asked Questions
Why do formula error warnings keep reappearing after I reopen my Excel file?
This usually happens if the background error checking feature is still globally enabled and the workbook contains underlying formula inconsistencies. Unless the feature is disabled in Excel Options or the formulas are physically corrected and saved, Excel will recalculate and flag the errors every time the file is opened.
What does the green triangle in the corner of an Excel cell mean?
The green triangle is Excel's background error indicator. It means the application has found a potential problem with the cell's contents based on its error rules, such as a formula omitting adjacent cells, a number formatted as text, or an unprotected formula.
Can I hide error values like #DIV/0! or #N/A without disabling error checking globally?
Yes. You can use the IFERROR function in your formulas to replace error values with a blank space, zero, or custom text. For example, changing =A1/B1 to =IFERROR(A1/B1, "") will hide the error output inside the cell without turning off the global background error checking feature.
Are circular reference warnings the same as formula error warnings?
No. A circular reference occurs when a formula directly or indirectly refers to its own cell, causing an infinite calculation loop. This triggers a pop-up warning upon opening the workbook, which cannot be disabled via the standard 'Background error checking' checkbox. You must locate and resolve the circular reference to stop the prompt.




