Excel Stale Value Error: What It Means and How to Fix It

Excel’s “stale value” is usually not a standard formula error such as #VALUE!; it means a displayed result may not reflect the latest calculation or source data. In Microsoft 365 for Windows, first choose Formulas > Calculation Options > Automatic if formulas look outdated, then press F9; for linked data or queries, use Data > Refresh All.

What “stale value” means in Excel

Excel uses “stale” in a general sense: a value is old relative to something that could have updated. The old value may still be visible and may look perfectly normal, even though an input changed or a connected source has newer information. This is different from a formula error. A cell showing #VALUE! contains an error result; a stale value is typically a value that has not been recalculated or refreshed yet.

There is no single universal “stale value” error code that identifies one cause. The clue may instead be a workbook’s calculation status, a connected data type, an external data connection, or a message from an add-in or reporting system. Before changing formulas, work out what the cell depends on: other worksheet cells, an online data type, a query, an external workbook, or a service outside Excel.

For example, if a sales total depends on cells that have changed but calculation is set to Manual, Excel can continue displaying the previous total. If a cell contains a linked stock data type, its last displayed price may remain visible until Excel refreshes the connected information. Both can look “stale,” but the fixes are different.

How stale formula results happen

Ordinarily, Excel recalculates dependent formulas when you change their inputs. A workbook can instead be set to Manual calculation, which delays that work. This setting is useful for very large or complex workbooks because recalculating after every edit can take time. The trade-off is that results may not update until you request a calculation.

On Windows, check Formulas > Calculation Options. If Manual is selected, choose Automatic and then press F9 to calculate formulas. Excel’s calculation mode can affect other open workbooks in the same Excel session, so changing it may influence more than the file currently on screen. If the displayed result still seems wrong, Ctrl+Alt+F9 forces a full calculation of all formulas in open workbooks, rather than only the cells Excel identifies as needing recalculation.

Calculation mode is not the only possibility. A formula can appear unchanged because it refers to the wrong cells, because an input is text rather than a number, or because a formula depends on an external workbook that is unavailable. Those are not necessarily stale-calculation problems. Check the formula bar, its references, and the source cells before assuming that recalculation will fix the result.

Refresh linked data types and online information

Excel’s linked data types, such as Stocks and Geography, connect recognized entries to information from an online source. A cell can hold a linked record rather than only plain text; formulas can then retrieve fields from that record. The information shown is not guaranteed to update continuously. Availability and refresh behavior can depend on the data type, the service, network access, and the workbook’s settings.

To request an update in Microsoft 365 for Windows, go to Data > Refresh All. This also refreshes other supported connections in the workbook, so it may take longer than updating one item. If the workbook contains a query or external connection, refreshing everything may prompt for credentials or report that a source cannot be reached. A successful refresh means Excel has retrieved available source data; it does not guarantee that the source itself is real-time or error-free.

If just one linked data type looks old, select its cell and use the refresh option available from the Data tab or the cell’s context menu, if shown in your Excel build. You can also inspect the data type card by selecting the cell and opening its card. That can help confirm what record Excel matched and which fields are available. If the entry was matched to the wrong company or place, correct the match; refreshing the wrong record will not make its values relevant.

Refresh queries, connections, and external workbooks

Power Query results and other imported tables do not necessarily update just because the original source file or database changed. Use Data > Refresh All to request a refresh of supported workbook connections. To inspect queries in Microsoft 365 for Windows, choose Data > Queries & Connections. The pane lists queries and connections and can help identify which imported table supplies the value you are investigating.

A refresh can fail or return unchanged data for reasons outside the cell formula: the source file may have moved, a database may be offline, access credentials may have expired, or a query may be configured to load a different file or table than expected. Read any refresh message rather than repeatedly clicking Refresh All. If the data is loaded from a shared file, confirm that the source has actually been saved with the newer information and that you have permission to access it.

Formulas can also refer to cells in another workbook. If that source workbook is closed, Excel may use a saved result or ask whether to update links when the destination workbook opens. The displayed value is only as current as the linked workbook’s available data and the update process. Check the link’s source and whether the source file is accessible; do not assume the destination workbook can fetch a current value from a file that has been moved or renamed.

A practical order for diagnosing the problem

Start with the least disruptive checks, and note the value before refreshing if it is important for an audit or comparison. These steps help separate calculation issues from connection issues:

Identify what the cell contains. Select it and inspect the formula bar. A formula, linked data type, imported table value, and typed-in constant require different updates.
Check calculation mode. Choose Formulas > Calculation Options > Automatic. Press F9. If dependent formulas still appear outdated, use Ctrl+Alt+F9 for a full calculation.
Check the inputs. Confirm that source cells changed as expected, formula references point to the intended range, and the cell is not displaying a cached result from another workbook.
Refresh connected data. For linked data types, queries, and supported connections, use Data > Refresh All. Watch for prompts or errors that explain why a source was not updated.
Verify the result against its source. Compare a few records with the original source or inspect the linked data type card. If the source itself has not changed, Excel may be displaying its latest available value.

For a simple calculation check, suppose B2:B4 contain 12, 8, and 10. With those numbers in B2:B4, the formula =SUM(B2:B4) returns 30. If the expected total is 35, recalculation will not fix the discrepancy unless one of the inputs or the range is wrong. This illustrates why checking the inputs and formula is as important as pressing a calculation shortcut.

Why refresh may not change the value

A refresh is a request, not a guarantee that a different value will appear. The source may not have changed since the last update, may publish information with a delay, or may provide only a particular snapshot. A query may also apply filters or transformations that exclude a newly added record. In these cases Excel may be working as configured even though the result is not what you expected.

Network access and authentication matter too. A connection can require credentials, a secure sign-in, or permission to view the source. If Excel reports a connection error, resolve that issue before interpreting the cell as current. Avoid sharing passwords or sensitive connection details in a workbook simply to make a refresh succeed; use the organization’s approved access method.

Finally, some values are intentionally fixed. A pasted value does not retain a live link to the formula or source from which it came. Refreshing cannot update plain text or a number typed directly into a cell. If the cell should update, restore the intended formula or connection rather than repeatedly refreshing unrelated workbook data.

Windows, Mac, and Excel for the web

The instructions above use Microsoft 365 for Windows. Excel for Mac also offers calculation settings and data refresh tools, but ribbon placement and the exact keyboard shortcut can differ by version. Use the Formulas and Data tabs to locate calculation and refresh commands on Mac; menu labels or available connection types may not match Windows exactly. On Mac, use the Excel menu’s keyboard-shortcut help or the command’s displayed shortcut rather than assuming a Windows key combination works unchanged.

Excel for the web can recalculate many workbook formulas and refresh some data, but feature support depends on the connection and data type. A workbook that relies on a desktop-only connection, a particular authentication method, or an unsupported feature may need to be refreshed in the desktop app. If a web refresh is unavailable or fails, open the workbook in Excel for Microsoft 365 on Windows or Mac and check the connection there.

Common misconceptions

“Stale” does not automatically mean “incorrect.” It means the value might not be current, and the relevant source determines what current means. For an imported report, current may mean the last successful scheduled refresh; for a formula, it means calculated from the workbook’s present inputs; for an online data type, it means the latest information Excel can retrieve from its provider.

It is also not the same as a circular reference or a broken formula. A circular reference occurs when formulas depend on one another in a loop, while a broken reference may show #REF!. A stale-looking number can exist without either problem. Diagnose the cell’s source first, then use calculation or refresh tools appropriate to that source.

Frequently Asked Questions

Is “stale value” an Excel error code?
No. It is generally a description of an outdated result or connected value, not a standard worksheet error such as #VALUE! or #REF!. The cause could be calculation mode, a data connection, or a value that was entered as a constant.

How do I force Excel to recalculate everything?
In Excel for Microsoft 365 on Windows, press Ctrl+Alt+F9 to force a full calculation of formulas in open workbooks. First check Formulas > Calculation Options and choose Automatic if you want formulas to recalculate as inputs change.

Does Data > Refresh All update every cell?
No. It requests updates for supported connections and linked information; it does not refresh ordinary typed values or fix incorrect formulas. Some sources can fail, require sign-in, or return the same data because no newer source value is available.

Why is my stock value stale even after refreshing?
The source may not have a newer value available, the connection may be unavailable, or Excel may have matched a different company than intended. Check the linked data type card and any refresh messages. Do not assume a connected stock value is a real-time market quote.

Can I fix a stale value by reopening the workbook?
Sometimes reopening prompts Excel to recalculate formulas or update links, but it is not a reliable fix for every cause. Check calculation mode and use the appropriate refresh command; if the source is unavailable or the cell is a fixed value, reopening alone will not make it current.

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.