How to Stop Division-by-Zero Error Pop-Ups in Excel for the Web
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.

- 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 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.
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!.
Open the workbook in Excel for the Web, select the Share button, and see whether your permission is Can edit or Can view.
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).
Refresh the workbook and confirm the division-by-zero error indicator or pop-up no longer appears for the affected cells.

Edit the Formula with IFERROR or an IF Denominator Check in Excel for the Web
Use this if you have edit access and want to immediately hide division-by-zero error indicators in your own copy or workbook.
Restructure the Workbook into Input, Calculation, and Report Areas
Use this when the workbook is shared or frequently updated, because a separate calculation area makes division-by-zero errors easier to control.
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. 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. Open the existing Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx file that previously showed division-by-zero errors.
- 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.

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.




