Excel Web Formula Not Working? Causes and Fixes That Work

Errors & fixes · Updated November 19, 2026

In Excel for the web, a formula usually fails because it is stored as text, has a syntax or reference error, is not recalculating, or uses a function the web version cannot run. Check that the entry begins with an equals sign, set the cell to General and re-enter the formula if it displays literally, then review the error message and calculation settings.

Identify what is going wrong

Start by separating a formula that is not being calculated from one that is calculating but returning an unexpected result. The distinction matters: changing calculation settings will not fix a misspelled function, and rewriting a correct formula will not help if Excel is displaying formulas instead of their results.

Look for these clues before editing the workbook:

  • If the cell shows the formula characters themselves, such as =A2+B2, the cell may be text-formatted, may have a leading apostrophe, or the Show Formulas view may be on.
  • If the cell shows an error such as #VALUE! or #REF!, Excel is evaluating the formula but cannot produce the requested result.
  • If the displayed answer does not change after an input changes, check calculation mode and whether the formula refers to the cell you edited.
  • If you cannot type into the cell, the issue may be workbook permissions, a protected sheet, or read-only access rather than the formula.

Also confirm that you are editing the intended workbook and worksheet. In a shared workbook, another person may have changed a source cell, a named range, or a formula while you were looking at an earlier version.

When Excel displays the formula as text

A formula must be entered as a formula, not as a text string. It normally starts with =, and the cell must not be set to Text before the formula is entered. A leading apostrophe can also tell Excel to keep formula-like content as text. The apostrophe may not appear in the cell itself, so inspect the formula bar if the cell looks ordinary.

To fix a text-formatted formula, select the cell, choose the Home tab, open the Number Format list, and choose General. Then edit the cell and confirm the entry again. Changing the number format alone may not convert text already stored in the cell; re-entering it is the important step. You can also delete a stray apostrophe at the beginning of the entry.

If many cells show their formulas rather than results, check whether Show Formulas is enabled on the Formulas tab. Turn it off to return to the normal result view. This view changes how formulas are displayed; it does not replace or erase the formulas in the worksheet.

For example, with numbers 12 and 8 in A2 and B2, respectively, enter this formula in C2. The expected result is 20:

=A2+B2

Check formula syntax, separators, and references

Excel formulas follow a precise structure. A missing parenthesis, an extra character, a misspelled function name, or a reference to the wrong cell can prevent the intended calculation. Click the cell and inspect the formula bar, where you can compare the actual entry with what you meant to type. When building a formula, selecting cells with the mouse can help avoid typing a wrong address.

Argument separators can vary with regional settings. Many installations use commas between function arguments, while some locales use semicolons. If a formula copied from a website is rejected near a comma, check your Excel regional settings or try the separator used by your installation. The formula examples here use commas, as is common in English-language Excel.

With values 10, 20, 30, 40, and 50 in B2:B6, enter this formula in B7. It should return 150:

=SUM(B2:B6)

If the total is wrong rather than rejected, inspect the range boundaries. The example includes B2 through B6, but not B7 itself. Including a total cell within its own sum can create a circular reference. Also check whether values that look numeric are actually text, especially if they were imported from a website or pasted from another system.

References can change when a formula is copied. A2 is a relative reference, so it shifts when copied to another row or column. If a calculation should always use one fixed input, an absolute reference such as $A$2 is appropriate. For example, a copied formula can produce unexpected results if a tax rate or conversion factor reference shifts by one row. Inspect the resulting references in each copied formula rather than assuming the first formula controls the whole range.

Confirm that Excel is recalculating

Excel usually recalculates formulas automatically when their inputs change. However, a workbook saved with manual calculation can leave dependent results stale. In Excel for the web, open Formulas > Calculation Options and choose Automatic if that option is available. Recheck a result after changing one of its input cells.

Calculation settings can matter when a workbook moves between Excel desktop and the web. If a coworker used manual calculation in the desktop app, a value displayed in the browser may be an earlier calculated result. Setting automatic calculation and allowing the workbook to update can resolve that symptom. For a large workbook, recalculation may take time, so wait for the update to finish before deciding that the value is stuck.

Do not confuse an unchanged answer with a calculation failure. A formula may be correct and recalculate successfully while returning the same value because the edited cell is outside its references, the new input happens to produce the same answer, or the formula contains a fixed value instead of a cell reference. Trace which cells the formula actually uses.

Understand common formula errors

An error code is useful evidence. It identifies a category of problem, although it does not always identify the exact cell or cause. Read the formula and inspect its inputs before replacing it with a different calculation.

  • #DIV/0! means a calculation divided by zero or by a blank cell being treated as zero. Check the denominator and decide how a zero case should be handled.
  • #VALUE! often means the formula received a value of the wrong type, such as text where a number is expected. Check imported data, spaces, and cells that contain numbers stored as text.
  • #REF! indicates an invalid reference, often because a referenced row, column, or worksheet was deleted or moved in a way that broke the formula.
  • #NAME? commonly points to an unrecognized function name, an incorrectly typed name, or a named range that does not exist.
  • #N/A often appears when a lookup cannot find a match. Check spelling, extra spaces, data types, and whether the lookup range contains the expected item.
  • #SPILL! means a dynamic-array result cannot occupy the cells it needs, often because something already occupies part of the output range.

For a deliberate divide-by-zero fallback, with a numerator in A2 and a denominator in B2, enter this in C2. If B2 is zero or blank, the result is 0; otherwise, it returns A2 divided by B2:

=IFERROR(A2/B2,0)

That fallback is not automatically the right business choice. Returning zero can conceal missing or invalid data, so use it only if zero is a meaningful result for the worksheet. If an error should be investigated, it may be better to leave it visible or use a more informative message.

Check function and workbook compatibility

Excel for the web supports a broad range of Excel formulas, but some capabilities depend on the function, workbook content, and the Excel version used by collaborators. Dynamic-array functions such as FILTER and UNIQUE are available in Microsoft 365 and Excel 2021 or later; LAMBDA and TEXTSPLIT require Microsoft 365 or Excel 2024. If a workbook is opened in an older desktop edition, a function available in the browser may not work there in the same way.

A #NAME? error or a displayed prefix such as _xlfn. can signal that the version opening the workbook does not recognize a function. Check the function name and the Excel version before replacing a formula. Replacing a modern formula with a simpler one may help compatibility, but it can also change how the workbook behaves.

VBA-based custom functions are another important distinction. Excel for the web does not run VBA macros, so a formula that depends on a custom VBA function may not calculate as it does in desktop Excel. If the workbook relies on macros or add-ins, open it in a supported desktop version or ask its owner whether there is a web-compatible alternative. Do not delete macro-related content simply to make an error disappear unless you understand what the workbook uses.

Some formulas also depend on linked workbooks, data connections, or access rights. If a result relies on an external source, confirm that the source is available and that your account can access it. A formula error in that situation may not be caused by the formula’s spelling.

Rule out access, browser, and saving issues

If the formula cell cannot be edited, check whether the workbook opened in view-only mode, whether you have edit permission, and whether the worksheet or cell is protected. In a shared file, the owner or administrator may need to grant access or unlock the relevant cells. A formula cannot be corrected by changing number formats if you do not have permission to edit it.

If you can edit but results or changes appear inconsistent, confirm that the workbook has finished saving and that your connection is stable. Reloading the page can help with a temporary display problem, but first make sure any unsaved edits are not at risk. If a problem occurs only in one browser session, reopening the workbook or trying a supported, up-to-date browser can help distinguish a session issue from a workbook issue.

Before making broad changes to a shared or important workbook, use its version history or make a copy if you are unsure what an edit will affect. This is especially helpful when investigating named ranges, linked data, or formulas copied across many sheets. Avoid overwriting formulas with pasted values as a quick fix; that may hide the problem and remove the workbook’s ability to update automatically.

A practical troubleshooting sequence

Work from simple checks toward more disruptive changes. That makes it easier to identify the cause and reduces the chance of changing a valid workbook unnecessarily.

  1. Select the affected cell and read the formula bar. Confirm the formula begins with = and that it references the intended cells.
  2. If the formula is visible as text, choose General from Home > Number Format, remove any leading apostrophe, and re-enter the formula.
  3. If formulas across the sheet appear instead of their answers, check Formulas > Show Formulas.
  4. If an error code appears, use its meaning to inspect the relevant function, inputs, references, or output space.
  5. If a result is stale, check Formulas > Calculation Options and select Automatic where available, then allow recalculation.
  6. If the formula uses a recent function, a custom VBA function, a data connection, or another workbook, check compatibility and access.
  7. If editing is blocked, verify permissions and protection rather than repeatedly trying to change the formula.

As a basic test, with 5 in A2 and 7 in B2, put this in C2. It should return 12:

=A2+B2

If that simple formula works in a blank area but the original does not, the cause is more likely tied to the original formula, its cell format, its references, or its workbook dependencies than to basic formula entry.

Frequently Asked Questions

Why is Excel showing the formula instead of the answer?

The cell may be formatted as Text, the entry may start with an apostrophe, or Show Formulas may be on. Set the cell to General and re-enter the formula, then check the Show Formulas control on the Formulas tab.

Why does my Excel formula not update when I change a value?

Check Formulas > Calculation Options and choose Automatic if available. Also confirm the changed cell is included in the formula’s references; a formula can recalculate correctly without depending on the cell you edited.

Why does Excel for the web show #NAME?

Check for a misspelled function, an undefined named range, or a function that the version opening the workbook does not support. A formula that calls a VBA custom function will not run in Excel for the web.

Why does a formula work in desktop Excel but not in the browser?

The workbook may rely on VBA, a desktop add-in, an external connection, or a function whose support differs by Excel version. Identify the dependency and check whether it is available in Excel for the web before changing the formula.

Should I change a formula error to zero?

Only if zero is a meaningful and accurate result for that calculation. A zero can hide missing inputs or a broken reference, so investigate the cause before using an error-handling formula to replace the visible error.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.