Formula Errors

How to Stop Division-by-Zero Error Pop-Ups in Excel for the Web

Huma Ashraf ChHuma Ashraf Ch Nov 13, 2026 869 views

Question details

User wants to stop Excel for the Web from showing error indicators or pop-ups for division-by-zero results when they cannot edit the workbook formulas.

How to Stop Division-by-Zero Error Pop-Ups in Excel for the Web
Product
Microsoft Excel for the Web
Device & OS
not provided
Scenario
A shared or protected Excel for the Web workbook displays #DIV/0! error pop-ups or indicators, and the user needs to suppress them without editing permissions.
Observed behavior
Excel for the Web shows error notifications or indicators when formulas divide by zero, and no user setting disables them in a read-only workbook.
Before you start

Before changing any formulas, check the workbook permission level in Excel for the Web. If the file is read-only or shared with view-only access, error indicators can only be changed by the owner or a user with edit rights.

Solution 1Recommended

Ask the Workbook Owner to Wrap Division Formulas in IFERROR or an IF Denominator Check

Use this when you only have view or comment access and cannot edit the formulas; the owner can prevent the pop-ups at the formula level.

Excel for the Web does not expose a user setting to turn off division-by-zero error notifications in read-only workbooks. The reliable fix is to change the formula so it no longer returns #DIV/0!.

1
Check your access level

Open the workbook in Excel for the Web, select the Share button, and see whether your permission is Can edit or Can view.

2
Contact the owner or administrator

Send the owner the sheet name and cell reference of the #DIV/0! error and ask them to edit the formula with IFERROR or IF(B2=0,"",A2/B2).

3
Verify after the edit

Refresh the workbook and confirm the division-by-zero error indicator or pop-up no longer appears for the affected cells.

Ask the Workbook Owner to Wrap Division Formulas in IFERROR or an IF Denominator Check
Best practice: Wrapping the calculation with IFERROR keeps the data clean while still showing intentional blanks or custom labels.
Free Microsoft Office alternative

Edit and Prevent Division-by-Zero Errors in WPS Spreadsheets

If Excel for the Web restricts you from fixing the workbook, WPS Spreadsheets gives you a free, lightweight Office alternative to open and edit .xlsx files locally, wrap formulas in IFERROR, and use familiar Excel-style menus without a Microsoft 365 subscription.

  1. 1. Download and install WPS Office: Get WPS Office from the official WPS website and install WPS Spreadsheets on your Windows, macOS, or mobile device.
  2. 2. Open the existing Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx file that previously showed division-by-zero errors.
  3. 3. Apply an IFERROR formula: Click the affected cell, enter =IFERROR(A2/B2,"") or =IF(B2=0,"",A2/B2), and press Enter to remove the #DIV/0! error.
Full compatibility with Microsoft Excel .xlsx, .xls, and CSV filesFree editing of formulas such as IFERROR and IF to prevent #DIV/0! errorsFamiliar ribbon interface for easy migration from ExcelLightweight offline desktop and mobile apps that open shared workbooks when Excel for the Web is read-only
microsoft office alternative - wps office

Frequently Asked Questions

Can I turn off Excel for the Web error pop-ups without editing the workbook?

No. Excel for the Web does not provide a user setting to disable division-by-zero error indicators in read-only or view-only workbooks. You need edit permission or must ask the workbook owner to change the formula.

What formula stops division-by-zero errors?

Use =IFERROR(A2/B2,"") to return a blank when the denominator is zero, or =IF(B2=0,"",A2/B2) to check the denominator before dividing.

Does IFERROR work in Excel for the Web?

Yes. IFERROR is available in Excel for the Web when you enter edit mode and is compatible with WPS Spreadsheets and desktop Excel.

Can WPS Spreadsheets open my Excel file and remove #DIV/0! errors?

Yes. WPS Spreadsheets can open .xlsx files, edit the formulas, and save the workbook with IFERROR or IF checks so the division-by-zero error no longer appears.

Why should a workbook separate input, calculation, and reporting areas?

Separating input, calculation, and reporting areas makes formulas easier to audit and reduces repeated #DIV/0! indicators because error handling can be applied once in the calculation area.