Excel formulas do not calculate in SharePoint itself: SharePoint stores and serves the workbook, while Excel for the web or the Excel desktop app evaluates its formulas. Open the file in Excel, then check whether the formula is stored as text, calculation is set to manual, or a browser feature or data connection is limiting the result.
What happens when you open an Excel file in SharePoint
A workbook in a SharePoint document library is still an Excel file. When you choose to open it in the browser, Excel for the web displays and works with the workbook; when you open it in the desktop app, Excel for Microsoft 365 on Windows does the calculation. SharePoint provides file storage, access controls, version history, and collaboration features, but it is not a separate spreadsheet calculation engine.
This distinction helps explain why the same workbook may look different in different places. A document preview may show saved results without providing the full Excel editing experience. A browser session may not be able to refresh a connection or use a particular desktop feature. And if someone has not saved recent changes, a different viewer may see the last saved result rather than the latest calculation.
First confirm that you have opened the actual workbook in Excel for the web or the desktop app, not just a library preview. If you are unsure, use the workbook’s Open option and select Excel for the web or Open in Desktop App. The exact options shown can depend on your organization’s SharePoint settings.
Identify what “not working” means
Before changing settings, note what you see. A formula may be visible in the cell instead of its result; a result may be outdated; Excel may show an error such as #VALUE! or #NAME?; or the result may differ between browser and desktop. These symptoms point to different causes, so copying the workbook or rebuilding the formula is rarely the best first move.
- The cell displays the formula: check whether the cell is formatted as Text, whether the entry begins with an apostrophe, or whether Show Formulas is on.
- The cell displays an old result: check calculation settings, saved changes, and whether a linked workbook or data connection needs refreshing.
- The cell displays an error: inspect the formula’s references, input values, function availability, and any external data it depends on.
- Only the browser version differs: compare the workbook in the desktop app and look for features or connections that behave differently online.
For a basic test, use a blank cell in the workbook. With the values 12, 18, and 25 in cells A2:A4, enter =SUM(A2:A4) in another cell. It should return 55. If it does, Excel is calculating simple formulas and the problem is more likely specific to the original cells, formula, or workbook feature. If it does not, check the entry and calculation settings before investigating more complex causes.
When a formula appears as text
If you see the formula characters in the cell rather than a result, Excel may be treating the entry as ordinary text. This commonly happens when the cell was set to the Text number format before the formula was entered, or when an apostrophe was added at the beginning to preserve the entry as text. The apostrophe may not be obvious in the cell itself.
In the desktop app, select the affected cell and inspect the Number Format control on the Home tab. If it is set to Text, change it to General, then make Excel re-read the entry: select the cell, press F2, and press Enter. If several cells are affected, select the range and apply the format before re-entering the formulas. Merely switching a cell from Text to General does not always convert content already stored as text.
Also check whether Show Formulas is enabled. In Excel for Windows, the Formulas tab has a Show Formulas control; the Ctrl+` keyboard shortcut toggles the display between formulas and results. The tilde-like character is the grave accent key, usually near the upper-left corner of a standard keyboard. If the whole sheet suddenly displays formulas, this setting is a more likely explanation than every formula having changed. Keyboard layouts vary, so the ribbon control is a useful alternative.
Check calculation mode and whether changes were saved
In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic. You can also check File > Options > Formulas and review Workbook Calculation. In Manual mode, changing an input may leave dependent formula results unchanged until calculation is triggered. Press F9 to calculate open workbooks, or change the workbook setting to Automatic if that suits the file’s intended use.
Calculation behavior can be confusing when a workbook has been edited on several computers or by several people. Calculation settings can be associated with the workbook, and an editor may have changed them while working in the desktop app. If the browser shows a stale value, open the file in the desktop app, check the calculation setting, allow recalculation, and save. Then reopen or refresh the browser view to see the saved state.
Do not assume that refreshing the browser will fix every stale result. A formula that depends on an external workbook, a data connection, or an unavailable add-in may need that source to be accessible and refreshed. Similarly, the browser cannot show unsaved changes made in another copy of the file. Confirm which copy is open and whether the latest edits have finished saving.
Look for formula errors and unsupported features
If Excel returns an error rather than showing the formula as text, inspect the formula and its inputs. Check for deleted or moved cells, misspelled function names, values stored as text, and ranges that do not include the expected data. A formula that works in one row but not another may refer to a different cell than intended. Select the cell and review the formula bar to see the actual expression.
Excel for the web supports many familiar Excel functions, but browser and desktop capabilities are not identical for every workbook feature. Some functions are available only in particular Excel versions. For example, XLOOKUP, FILTER, and LET require Microsoft 365 or Excel 2021 or later; a person opening the workbook in an older perpetual desktop version may see an unrecognized-function problem. If an unfamiliar function is involved, check the Excel version and function compatibility for every person who needs to use the file.
Some workbook features also depend on desktop Excel, add-ins, macros, or connected sources. Excel for the web does not run VBA macros. A workbook may still contain macros, but users should not expect a macro-dependent process to run in the browser. External links and data connections can also require permissions, sign-in, or a refresh that is unavailable or behaves differently online. Open the file in the desktop app when you need to diagnose a desktop-only feature, and check that the linked source is reachable.
Understand collaboration, syncing, and version history
SharePoint and Excel support collaborative editing, but coauthoring does not remove the need to let changes save. If a colleague changes an input while you are viewing a dependent result, allow the workbook to sync and check that you are looking at the same file and sheet. A local copy downloaded earlier, an email attachment, or a separately synced duplicate can look like the SharePoint workbook while containing different data or formulas.
When using a synced library through OneDrive, wait for synchronization to finish before comparing the desktop file with the browser version. Avoid making separate edits in an unsynced download and the online workbook, then assuming one will automatically contain the other’s changes. If formulas broke after a recent edit, SharePoint’s version history may help identify when the change occurred. Check the library’s file menu or details pane for Version history; available controls can vary by site permissions and configuration.
Before restoring an earlier version, consider that doing so can replace other people’s more recent edits. If the workbook is important, make a safe copy or coordinate with collaborators first. Version history can help recover a prior file state, but it does not explain by itself whether a formula failed because of calculation settings, a changed input, or an unavailable data source.
A practical troubleshooting order
Work from simple checks to more involved ones. This sequence helps isolate the cause without making unnecessary changes to a shared workbook:
- Open the file in Excel for the web or Excel desktop, rather than relying on a preview.
- Check whether the formula is visible as text, whether Show Formulas is on, and whether the cell uses the Text format.
- Test a simple formula in an unused cell, and compare the result with what the inputs should produce.
- In desktop Excel, check Formulas > Calculation Options and select Automatic if appropriate.
- Review error messages, input values, cell references, and the Excel version used by anyone opening the workbook.
- Check linked files, data connections, add-ins, or macros if the workbook depends on them.
- Confirm that the latest edits are saved and that everyone is working in the same SharePoint file.
- If the issue began after a change, inspect version history before deciding whether to restore an earlier version.
If the workbook works in the desktop app but not in the browser, keep using the desktop app for the affected task while you identify the specific limitation. If it fails in both, focus on the formula, cell format, calculation mode, and inputs rather than SharePoint. For a workbook used by a team, document any required Excel version or refresh steps so other editors know what to expect.
Frequently Asked Questions
Does SharePoint calculate Excel formulas?
No. SharePoint stores and manages the workbook. Excel for the web or the desktop app evaluates formulas when the workbook is opened and edited.
Why does Excel show 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 enabled. Change the format to General and re-enter the formula, and check the Show Formulas control.
Why are my formulas not updating in SharePoint?
Check whether calculation is set to Manual in desktop Excel, whether the latest edits have saved, and whether the formula relies on a linked workbook or connection that needs access or refreshing.
Will every Excel formula work in Excel for the web?
Many common functions work, but some functions require a newer Excel version and some workbook features depend on desktop Excel, add-ins, macros, or connections. Compare the versions and features involved.
Should I download the file if it does not work in the browser?
Opening it in the Excel desktop app is a useful diagnostic step, especially for macros, add-ins, and some connections. Keep edits in the same SharePoint workbook where possible, and make sure the file saves before comparing results.
Related
- Excel Essential Keyboard Shortcuts for Everyday Work
- Excel European Number Format: Decimals and Separators
- Excel Subscript Out of Range: Causes and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Power Query Key Not Matching Error: Causes and FixesThe Power Query error “The key didn’t match any rows in the table” usually means a query is…
- Check Circular References in Excel: Find and Fix ThemTo check for a circular reference in Excel for Microsoft 365 on Windows, open the Formulas tab, select…
- Excel UNIQUE and FILTER Not Working? FixesIn Excel for Microsoft 365, put FILTER inside UNIQUE to return distinct values that meet a condition. With…
- Repair Excel in Windows 10: Fix Common Excel ProblemsTo repair Excel in Windows 10, first restart your PC and check whether Excel opens in Safe Mode;…
- Excel Not Filling Sequential Numbers? Fix the SeriesIf Excel repeats a number instead of counting, enter the first two numbers, select both cells, and drag…
- Excel Circular Reference: Find the Cell and Fix ItIn Excel for Microsoft 365 on Windows, choose Formulas > Error Checking > Circular References, then click the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.