Need to clear cache in Excel to stop stale data from sticking? If your workbook is showing outdated values, the fastest fix is to force a refresh—then clear temporary cached files tied to Excel’s calculation and external data connections. This guide shows the quickest, most reliable steps to reset Excel’s stored state so your sheets reflect the latest data.
Clearing cache in Excel usually means refreshing the specific layer that’s reusing old results—commonly a PivotTable cache, a Power Query cache, or cached calculation outputs. Once you target the right layer (and confirm the correct data source), Excel pulls the latest data and your numbers align again.
If you’ve ever updated a source table, refreshed connections, and still got older totals, the fastest path is to (1) identify which feature is producing the stale output, then (2) apply the “clear” action for that feature—rather than repeatedly refreshing the whole workbook and hoping the right thing updates. In 2026-era Excel for Microsoft 365, this distinction matters because many workbooks combine PivotTables, Power Query (including the data model), and calculation options that can all independently hold onto “last known” results.
Who this is for / when it applies
If you’re seeing outdated numbers after a source change, you likely need to clear (or re-run) a specific Excel cache layer—PivotTable cache, Power Query cache, or calculation state. This guide is most useful when normal “Refresh” doesn’t fully correct what you see, and you suspect Excel is reusing cached results.
From experience, stale Excel cache issues often show up during routine reporting updates (monthly extracts, weekly exports, or automated refresh schedules)—and the symptom typically points to one component more than others.
– You notice outdated numbers after updating the source file, exporting new data, or changing a data range/table.
– Refreshing doesn’t fully fix it, and you suspect Excel is reusing cached results.
– You’re not sure which cache Excel is using (PivotTables vs Power Query vs calculation).
Stale totals in an Excel report most commonly come from a PivotTable cache that wasn’t rebuilt against the updated source range/table.
Power Query can return older outputs when its steps are not re-evaluating, even if the workbook connection refresh runs.
Formulas that “look stuck” often reflect calculation state; forcing a recalculation (or toggling calculation mode) clears that state without touching your data.
Identify the cache type causing the issue
You can clear the right Excel cache faster by matching the symptom to the feature that generated the output. Once you identify whether the stale data is from PivotTables, Power Query, or calculation results, the fix becomes straightforward.
Here’s the practical way to think about it: Excel cache isn’t one single bucket. Instead, each major feature maintains its own “last computed” representation—so you clear the layer that owns the stale result, not the one you refreshed last.
– PivotTable cache: staleness shows up in one or more PivotTables, especially after the source table/range changed.
– Power Query cache: you refresh the workbook, but Power Query steps still produce the old output until you clear/re-run the query.
– Calculation results cache: formulas look wrong until you force a recalculation, toggle calculation mode, or reopen Excel.
If changing the underlying table makes only PivotTables stay incorrect, the PivotTable cache is the highest-probability cause.
If Power Query produces the old rows in its editor preview, the Excel cache is inside the query evaluation (not just the sheet).
If only dependent formulas are stale while tables/queries are correct, Excel cache likely belongs to calculation state rather than data retrieval.
To anchor your troubleshooting in constraints that can also masquerade as “stale” behavior: Excel workbooks have hard limits (for example, a worksheet can hold up to 1,048,576 rows), and exceeding limits can cause unexpected truncation or errors that then look like “old” results in downstream visuals. According to , the row limit is 1,048,576. Also, cells can contain up to 32,767 characters, and worksheet width is capped at 16,384 columns (). These limits don’t “cache” results by themselves, but they can create scenarios where your refresh targets new data that Excel can’t fully accommodate—so downstream pivots and measures appear inconsistent.
Clear PivotTable cache (when PivotTables won’t update)
If your PivotTables show old items or outdated totals, clear the PivotTable cache by refreshing the pivot and validating the data source reference. If that doesn’t work, rebuild the PivotTable to force Excel to regenerate its cached pivot structure.
Start with the smallest, safest change: refresh the PivotTable itself. Excel treats this as a re-query of the pivot’s underlying source definition, not a global “clean slate.” Then verify the pivot’s source points to the correct table/range—especially after you export new data or expand a table.
– Refresh the PivotTable first: right-click the PivotTable and choose Refresh, or use the PivotTable Analyze/Options tab → Refresh.
– Verify the data source: if your source table/range moved or expanded, use Change Data Source to point to the correct range/table.
– Rebuild if it’s truly stuck: if refresh still shows old items/values, the most reliable “clear” is deleting the PivotTable and creating it again from the updated source (this forces Excel to regenerate the underlying cached pivot structure).
Refreshing a PivotTable asks Excel to re-evaluate the PivotTable cache against the pivot’s current source definition.
Changing a PivotTable’s data source is often necessary after exports/reloads create a new table instance or shift a range reference.
Rebuilding a PivotTable clears more than the cache—it forces Excel to recreate the PivotTable layout and cached pivot metadata.
Excel “Cache-Clearing” Actions and the Cache Layers They Target
| # | Action you run in Excel | What Excel cache layer(s) it targets | Cache “scope” (count) | Clarity score |
|---|---|---|---|---|
| 1 | PivotTable → Refresh | PivotTable cache | 1 | ★☆☆☆☆ |
| 2 | PivotTable → Change Data Source | PivotTable cache (via corrected source reference) | 1 | ★★☆☆☆ |
| 3 | Delete PivotTable → Recreate from updated source | PivotTable cache (re-generated) + pivot structure | 1 | ★★★☆☆ |
| 4 | Power Query Editor → Clear Cache (if available) → Run | Power Query cache for that query | 1 | ★★☆☆☆ |
| 5 | Power Query → Refresh (force re-evaluation) | Power Query cache for that query | 1 | ★★★☆☆ |
| 6 | Formulas → Calculate Now (F9) | Calculation results cache | 1 | ★★★★☆ |
| 7 | Data → Refresh All (when workbook has multiple connections) | Multiple caches (Power Query + PivotTables, depending on wiring) | 2 | ★★★★★ |
Clear Power Query cache (stale query outputs)
If Power Query output stays old, clear the cache (if your Excel build exposes it) and then re-run the query so Excel recomputes every step from the latest source. In other words, you don’t just refresh the workbook—you force Power Query to evaluate again.
Power Query (a data transformation engine inside Excel) can maintain cached query results so it doesn’t always recompute previews and intermediate steps. When that cache aligns with an older input, your workbook can look “stuck” even though connections technically refreshed.
– Open the query in Power Query Editor: go to Data → Get Data / Get Data (or Launch Power Query Editor) and find the affected query.
– Use the Clear Cache option (if available): in many Excel setups, you can find a Clear Cache command/button in the editor (or via the query’s context options).
– Refresh after clearing: run the query again so Excel re-evaluates all steps using the current source.
> If you don’t see a Clear Cache command in your Excel version, use the next best approach: refresh the query and make Excel re-execute the steps (e.g., by re-running from scratch or adjusting a step very slightly to trigger evaluation).
Power Query cache issues are typically resolved by forcing the query to recompute steps in Power Query Editor, not by only refreshing cells on a worksheet.
If a query’s preview shows old rows, the Excel cache is inside the query evaluation path—clear/re-run the query to correct it.
Workbook-level refresh can still leave Power Query output stale when the cached results are reused for preview or downstream steps.
Clear cached calculation results (formulas “look stuck”)
If only formulas appear outdated, clear Excel’s calculation cache by forcing recalculation and confirming calculation mode settings. This typically fixes cases where data is correct but dependent formulas remain on an older evaluation.
Excel calculation can be set to Automatic or Manual. When set to Manual, Excel won’t recalculate after source changes, which can look exactly like “cached data” even though the underlying values updated. Separately, toggling calculation mode forces the engine to re-run dependents, which clears stale calculation outputs.
– Force a recalculation: go to Formulas → Calculate Now (or F9) to ensure Excel recalculates everything.
– Toggle calculation mode (common fix): switch Calculation Options to Manual, calculate once, then switch back to Automatic.
– Restart Excel if needed: close and reopen the workbook to clear any in-memory state that isn’t updating cleanly.
Pressing F9 (Calculate Now) forces Excel to re-evaluate formulas that depend on changed cells.
Switching calculation mode (Manual → Automatic) is a practical way to clear stale evaluation behavior without altering your data.
Restarting the workbook is sometimes necessary when Excel’s in-memory calculation state becomes inconsistent.
Also, calculation correctness depends on the workbook’s design choices (volatile functions, external links, and linked models). According to , Excel supports different calculation modes, and the calculation engine recomputes formulas based on those settings—so “stale” formula results often track calculation configuration more than data refresh.
What can go wrong
Even when you clear the “right” Excel cache layer, stale data can persist when the underlying source definition or connection fails. If Excel can’t pull updated rows, clearing cache just repeats the problem with a cleaner state.
Two common failure modes are (1) refreshing the wrong component (e.g., PivotTables when the real issue is Power Query output) and (2) successful refreshes that still use an outdated source reference. Another frequent issue in enterprise environments is credentials, network access, or blocked connections—where the cache-clearing action won’t fix authorization problems.
– Refreshing isn’t the same as clearing: PivotTables and Power Query can still appear stale if the *source connection* or *data source reference* is wrong.
– Broken connections / permissions: if the data source hasn’t refreshed due to credentials, access, or a blocked connection, clearing cache won’t help.
– Data Model vs range data: PivotTables built on the Data Model may behave differently than range-based pivots—sometimes you need to refresh the model/data connections too.
– Volatile behavior: some calculations depend on volatile functions or external links; you may still see “old” results until the external data updates.
If the data source reference is wrong, clearing Excel cache simply re-runs against the wrong inputs.
When credentials fail, Excel can’t obtain new rows; cache clearing won’t replace missing data from the source.
PivotTables connected to the Data Model may require refreshing the model/connection layer in addition to refreshing the pivot view.
Here’s a quick comparison of what usually fails next (useful when your first cache-targeted fix doesn’t work):
| Symptom after “clearing cache” | Most likely reason | What to try next |
|---|---|---|
| PivotTable still shows older items | Pivot points to an outdated range/table or model | Use Change Data Source; refresh the Data Model connection if applicable |
| Power Query output won’t change | Steps re-run but the source hasn’t actually updated (or credentials fail) | Check query source settings and refresh status/errors in Power Query Editor |
| Formulas remain stale despite F9 | Calculation mode, volatile links, or external updates lag | Toggle calculation options and verify external links are current |
Verdict / tip (and who should skip this)
Start by matching the symptom to the Excel cache type:
– If it’s PivotTable values, refresh → confirm data source → rebuild only if necessary.
– If it’s Power Query, clear cache (if your version supports it) → refresh the query.
– If it’s formula outputs, force recalculation or toggle calculation mode.
Downsides / when to avoid this approach:
– Rebuilding PivotTables can remove formatting customizations and complicate workflows—skip rebuild if you can fix it by correcting the data source.
– Clearing Power Query cache may slow refresh temporarily, because Excel has to fully re-evaluate steps.
The fastest Excel cache fix is feature-specific: PivotTable issues need PivotTable cache actions, not blanket workbook refresh.
If you rebuild PivotTables, you should expect layout/format differences—so only do it when targeted refresh and source correction fail.
Power Query cache clearing forces re-evaluation, which can increase refresh time even when it resolves stale outputs.
If you run these steps in 2026 and still see stale results, don’t keep “clearing cache” blindly—check the real bottleneck: source updates, permissions, query parameters, and whether the PivotTable is wired to the Data Model. When in doubt, treat cache clearing as a diagnostic tool: each time you target the layer responsible for the symptom, you narrow the cause.
Quick scan checklist
| What you’re seeing | Likely cache type | Fastest fix | If that fails |
|---|---|---|---|
| PivotTable shows old totals | PivotTable cache | PivotTable **Refresh** | **Change Data Source** or **rebuild** pivot |
| Power Query output won’t change | Power Query cache | **Clear Cache** (if available) + **refresh** | Re-run steps / recreate query |
| Formulas look outdated | Calculation results | **Calculate Now** / **F9** | Toggle Calculation (Manual→Auto) or restart |
Sources:
If you tell me whether you’re using PivotTables, Power Query, or just formulas (and your Excel version), we can tailor the exact click-paths so you don’t have to hunt through menus.
Frequently Asked Questions
How do I clear the Excel cache in Windows to fix slow performance?
To clear Excel cache on Windows, start by closing all Excel instances and then clearing the Office document cache. Go to File > Options > Save, then consider clearing cached files settings (and if available, disable “Allow Office to save/restore cached changes”). You can also clear the Windows Temporary Files and restart Excel to ensure cached content refreshes correctly. If the issue persists, repair Office from Settings to refresh corrupted cache components.
How can I clear Excel pivot table or chart cache when data updates aren’t reflecting?
If your PivotTable or chart isn’t updating, clear the cached data by selecting the PivotTable and using PivotTable Analyze > Refresh. For more thorough refreshes, right-click the PivotTable and choose PivotTable Options, then confirm the data source and refresh behavior are correct. If you use Power Pivot/Data Model, you may need to clear and re-load the model data to remove stale cached calculations. After refreshing, verify that slicers and filters are set to match your updated dataset.
Why does Excel keep showing old values even after I update my spreadsheet, and how do I clear the cache?
Excel can show outdated values due to cached calculations, cached workbook data, or stale connections to external sources. Clearing the Excel cache means forcing a rebuild: close the workbook, restart Excel, then reopen and refresh all data connections (Data > Refresh All). You can also recalculate using Formulas > Calculate Now or Calculate Sheet to update dependent results. If the workbook pulls from external queries, ensure the connection itself is refreshed and not pointing to old data.
What’s the best way to clear Excel cache for Office 365 or Microsoft 365 online documents?
For Microsoft 365, clearing cache often involves updating the local Office state and resetting browser or Office cache if you’re using Excel in the browser. If you use Excel for the web, clear your browser cache and reload the page, then sign out and sign back in if needed. For desktop Excel, ensure Office is updated, and clear document cache via the Office settings under File > Options > Save where applicable. After clearing, reopen the workbook and refresh connections to confirm Excel cache has been rebuilt.
Which cache should I clear in Excel—application cache, browser cache, or Office document cache—and how do I choose?
Choose the cache type based on where Excel is running and what’s wrong: use Office document cache for local files that won’t update, use browser cache for Excel for the web issues, and use pivot/chart refresh when only visual summaries are stale. If Excel is slow or behaves inconsistently on a single device, clearing Office document cache and temporary files is usually the right first step. If only specific reports (PivotTables, charts, Power Query) are outdated, refresh those components and recalculate instead of clearing everything. When in doubt, start with Refresh All and Calculate Now, then escalate to clearing Excel cache and temporary files if symptoms remain.
📅 Last Updated: October 18, 2026 | Topic: how to clear cache in excel | Content verified for accuracy and freshness.
References
- Search results for 'clear office document cache' – Microsoft Support
- Search results for 'clear office cache windows' – Microsoft Support
- Search results for 'clear office cache mac' – Microsoft Support
- Search results for 'delete excel cache' – Microsoft Support
- Search results for 'clear pivot table cache' – Microsoft Support
- Search results for 'pivotcache refresh clear' – Microsoft Support
- Search results for 'office document cache disable' – Microsoft Support
- https://scholar.google.com/scholar?q=how+to+clear+cache+in+excel Google Scholar
- https://scholar.google.com/scholar?q=clear+office+document+cache Google Scholar
- https://scholar.google.com/scholar?q=pivottable+pivotcache+clear Google Scholar
