Formula Errors

How to Disable Formula Error Warnings in Excel 2016

Tauseeq MagsiTauseeq Magsi Nov 4, 2026 871 views

Question details

The user wants to stop Excel 2016 from displaying formula error warnings when opening a legacy workbook.

How to Disable Formula Error Warnings in Excel 2016
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 you start

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.

Solution 1Recommended

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.

1
Open Excel Options

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.

2
Navigate to Formulas Menu

In the Excel Options dialog box, click on the 'Formulas' category located on the left pane.

3
Disable Error Checking

Scroll down to the 'Error Checking' section and uncheck the box labeled 'Enable background error checking'. Click 'OK' to apply the changes.

Disable Background Error Checking in Excel Options
Note on Security Prompts: If the warning appears as a pop-up dialog when opening the file rather than a green triangle in a cell, it might be a security warning (like Macros or Protected View) or a circular reference warning. These are managed in the Trust Center, not under Error Checking.
Seamless Spreadsheet Alternative

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. 1. Open your Workbook in WPS: Launch WPS Office and open your existing .xlsx or .xls file.
  2. 2. Access Options: Click the 'Menu' button in the top left corner of the spreadsheet interface, then click on 'Options'.
  3. 3. Navigate to Error Checking: In the Options window, go to the 'Error Checking' tab on the left-hand side.
  4. 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.
Easily toggle background error checking rules on or off.Fully compatible with Microsoft Excel (.xlsx, .xls) formulas and workbooks.Free, lightweight, and fast to open large legacy workbooks without freezing.Familiar tabbed interface requiring zero learning curve.
QA img-9

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.