Excel Workbook Has Stale Values? How to Find and Fix Them

Errors & fixes · Updated November 18, 2026

If an Excel workbook shows stale values, first check Formulas > Calculation Options > Automatic, then press Ctrl+Alt+F9 on Windows to force a full recalculation. If the numbers come from a query, PivotTable, or linked workbook, use Data > Refresh All or refresh that specific source; recalculating formulas does not refresh imported data.

A stale value is a result that no longer matches the inputs or source data you expect. The cause may be Excel’s calculation setting, an external connection, a PivotTable cache, or simply a cell that contains a fixed number rather than a formula. Identifying which kind of value you are looking at is the quickest route to a reliable fix.

How Excel updates workbook values

Excel workbooks can contain several kinds of values, and they do not all update in the same way. A formula such as a total recalculates from its referenced cells. A Power Query result or other imported table must be refreshed from its source. A PivotTable summarizes source data using its own cached data, which must also be refreshed. A number typed directly into a cell has no connection to its original source and will not change by itself.

These update mechanisms are separate. For example, recalculating a formula that totals a query table can update the total based on the rows currently in that table, but it will not fetch new rows from the database. Refreshing the query can bring in new rows, after which Excel may recalculate dependent formulas. Similarly, a workbook can have automatic formula calculation and still show an old PivotTable because the PivotTable has not been refreshed.

Excel may also display a saved, previously calculated result when a workbook is opened or previewed. Until calculation runs, that result can appear current even though the formula’s inputs have changed. This is one reason a file preview, email attachment thumbnail, or non-Excel viewer may not show the same result as the workbook after it opens and recalculates in Excel.

Check whether calculation is set to Automatic

In Excel for Microsoft 365 on Windows, open the Formulas tab and choose Calculation Options. Select Automatic. In Manual mode, formulas generally recalculate only when you request it, so changing an input may leave dependent cells displaying their earlier results.

To calculate after changing the setting, use one of these Windows shortcuts:

  • F9 calculates formulas in all open workbooks.
  • Shift+F9 calculates the active worksheet.
  • Ctrl+Alt+F9 forces calculation of all formulas in all open workbooks, even if Excel does not consider them changed.
  • Ctrl+Alt+Shift+F9 rebuilds the dependency information and then forces a full calculation. Use it when ordinary recalculation does not resolve a suspected dependency problem.

On some keyboards, you may need to hold Fn as well as the function key. In Excel for Mac, use the Formulas tab’s calculation commands, such as Calculate Now or Calculate Sheet, if the keyboard shortcuts differ on your keyboard. Excel for the web has calculation controls too, but the interface and available commands can differ from the Windows desktop app.

Calculation mode can be easy to overlook because a workbook may have been saved while set to Manual. If you work with several open workbooks, check the setting after opening the affected file rather than assuming it inherited the option you used in another session. Also consider whether Manual mode was chosen deliberately: very large or complex models may use it to avoid recalculating after every edit. If so, recalculate at planned points and make the mode clear to other people who use the file.

Refresh queries, connections, and linked workbooks

If the stale result comes from data outside the workbook, recalculation alone is not enough. Choose Data > Refresh All to refresh supported workbook connections and queries. To refresh one source, open Data > Queries & Connections, select the relevant query or connection, and use its refresh command. Labels and available options can vary with the source and Excel build.

For a query that should update when the workbook opens, inspect its properties in the Queries & Connections pane. Depending on the connection, options may include refreshing on open or refreshing at a set interval. A refresh can take time, require network access, or ask for credentials. Check the refresh status or any error message before concluding that the displayed table is current.

Formulas that refer to another workbook can also show old results if the source file is closed, unavailable, or has not been updated. Check the workbook link from the Data tab; Microsoft 365 may show a Workbook Links command. Confirm that the linked file path is correct and that you have permission to access it. Do not choose an option to break a link unless you intend to replace the formulas with fixed values, because breaking a link removes the live connection.

Refreshing external data can have consequences beyond changing a displayed number: it may retrieve a different set of records or use the latest contents of a shared source. If the workbook is used for a report, note when it was last refreshed and which source it uses. If a refresh fails, keep the existing workbook intact while you investigate access, credentials, source availability, and connection settings.

Refresh a PivotTable separately

A PivotTable may summarize a saved snapshot of its source rather than the latest rows in the source range. Click inside the PivotTable and select PivotTable Analyze > Refresh. To refresh PivotTables and connections across the workbook, use Data > Refresh All. After refresh, verify that the PivotTable source includes the new rows; refreshing cannot include records that fall outside a fixed source range.

For future updates, consider using an Excel table as the PivotTable source. Tables usually expand when data is added directly beneath them, making new rows easier to include on refresh. This is not a substitute for refreshing the PivotTable, and it does not solve every source-layout issue. If data is pasted outside the table or the PivotTable uses a different source, confirm the source range through the PivotTable’s data-source settings.

Another clue is that the underlying data looks right but the summary does not. In that case, refresh the PivotTable first, then check filters, slicers, grouped fields, and the selected source range. A filter can make a correct refreshed summary look incomplete, while a source range that excludes the newest records can make a refresh appear ineffective.

Confirm that the cell contains a formula

A cell may look like a calculated result while actually containing a number pasted as a value. Select it and inspect the formula bar. If it shows a number or text rather than a formula beginning with an equals sign, Excel has nothing to recalculate. You will need to restore the intended formula, re-import the data, or obtain an updated value from the original source.

To inspect many cells, use Home > Find & Select > Go To Special and choose Formulas or Constants. This can help distinguish calculated cells from fixed entries. The shortcut Ctrl+` toggles formula display on Windows, which is useful for scanning a worksheet; on a Mac, the key combination can vary with the keyboard layout, so the ribbon command may be easier.

Also check for formulas that point to the wrong cells or use a fixed reference where a changing reference was intended. A formula can calculate perfectly and still produce an outdated-looking answer because it refers to an old range, a different sheet, or a manually entered date. Use Formulas > Trace Precedents to inspect cells that feed a selected formula, and follow the references back to the actual inputs.

Common causes that look like stale values

  • Manual calculation: Formulas have changed, but Excel has not recalculated them yet.
  • Unrefreshed source data: A query, connection, or linked workbook has not retrieved the latest source contents.
  • PivotTable cache or source range: The summary has not been refreshed, or new records are outside its source range.
  • Fixed values: A formula was replaced by pasted values, or data was entered manually.
  • Filters and hidden rows: The value may be accurate for the visible subset, while a filter hides other records.
  • Formula logic or references: The formula is current but points at the wrong cells, range, or worksheet.
  • Delayed or unavailable source: A connection may still be refreshing, require credentials, or be unable to reach its source.

One common misconception is that pressing F9 updates everything in a workbook. It recalculates formulas, but it does not necessarily fetch fresh data from every external source or refresh every summary in the way a user expects. Likewise, a successful Refresh All does not prove that every formula is correct or that every source range includes the intended records. Treat calculation, data refresh, and formula validation as separate checks.

A reliable troubleshooting sequence

  1. Save a copy of the workbook if it is important, then note one specific cell or PivotTable that appears wrong.
  2. Inspect the cell’s formula bar and identify whether the displayed result comes from a formula, a fixed value, a PivotTable, or imported data.
  3. For a formula, set calculation to Automatic and run a full recalculation. Check its precedents and formula references if the result remains unexpected.
  4. For a query, connection, or linked workbook, refresh the relevant source and check for credentials, path, or connection errors.
  5. For a PivotTable, refresh it and verify both its source range and its filters.
  6. Compare the result with a known source record or a small independent calculation. Save only after confirming that the update is expected.

This order avoids changing several settings blindly. It also helps distinguish an Excel display or calculation issue from a source-data problem. If only one workbook is affected, compare its calculation mode, connection settings, and formulas with a working copy before making broader changes.

When to be cautious

Refreshing can change data in ways that affect reports, operational decisions, or later analysis. Before refreshing a shared or important workbook, check whether users expect a snapshot or the newest source data. A refresh may update records, alter totals, or expose a connection error where an older saved result had been visible. Keep a backup when the workbook contains important manual edits or has a complicated data model.

A workbook showing a warning about external links or connections should not be refreshed automatically if you do not recognize the source. Confirm who created the workbook and whether the referenced location is trusted. If the file came from an unknown sender, follow your organization’s security process rather than enabling connections or macros just to make the displayed numbers change. Refreshing a data connection is different from enabling macros, and neither action should be treated as a universal fix.

Frequently Asked Questions

Why does Excel not update formulas automatically?
Calculation may be set to Manual. Check Formulas > Calculation Options > Automatic, then recalculate. If only one result remains wrong, inspect the formula and its input references.

Does F9 refresh external data?
No. F9 recalculates formulas. Use Data > Refresh All or the relevant connection’s refresh command to retrieve external data, and refresh a PivotTable when its summary is out of date.

Why is my PivotTable showing old data after I changed the source?
PivotTables need to be refreshed, and their source range must include the changed or newly added records. Click inside the PivotTable and choose PivotTable Analyze > Refresh, then verify its source and filters.

Why does Excel show a number instead of a formula?
The cell may contain a fixed value, perhaps because the formula was overwritten or pasted as values. Select the cell and inspect the formula bar. If no formula appears, Excel cannot recalculate that entry.

Can I make a query refresh when I open the workbook?
Often, yes. Check the query or connection properties in Data > Queries & Connections for a refresh-on-open option. Availability depends on the connection, and the refresh may require network access or credentials.

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.