How to clean Excel cache: A practical guide
A practical, step-by-step guide to safely clear Excel cache on Windows and macOS, including Office caches, AutoRecover data, and recent-file lists. Learn when to clear, what to delete, and how to verify Excel runs smoothly.
By the end of this guide you’ll know how to safely clear Excel cache across Windows and macOS, including Office File Cache, AutoRecover data, and recent-file caches. This practical guide on how to clean excel cache can speed workbook opens, reduce freezes, and fix odd behavior without risking your actual data. You’ll learn when to act, what to delete, and how to verify Excel still works afterward.
Why clearing Excel cache matters
Excel, like other complex apps, uses caches to speed up tasks such as opening workbooks, loading data connections, and restoring recent sessions. When caches become stale or overly large, you may notice slower openings, brief freezes, or odd glitches in formulas or data connections. Clearing caches is a low-risk maintenance step that helps reset these temporary data stores, often restoring snappy behavior without touching your actual worksheets. According to XLS Library, many users report noticeable performance improvements after performing a cautious cache cleanup. This guide focuses on practical, Windows- and macOS–friendly steps you can perform without professional tools, keeping your data intact while removing only what Excel no longer needs to operate efficiently.
Where Excel stores cache and what to clear
Different components contribute to caching in Excel. Core caches include the Office document cache and temporary files that Excel uses while opening and editing workbooks. Power Query, data connections, and the AutoRecover system also generate caches that can grow over time. The goal is not to delete everything at once, but to target caches that are known to cause issues when they become stale, while preserving critical data. If you routinely use Power Query or large data models, plan an occasional cache refresh as part of your maintenance cycle. The XLS Library team notes that cache behavior varies by OS and Office version, so you may see different folder names but the principle remains: identify and clear temporary cache locations, not your actual workbook files.
Safe ways to clear cache: prerequisites and precautions
Before you start, back up any unsaved work and close all Excel instances. Clearing caches while Excel is running can leave inconsistent states or corrupted temporary files. Use the following approach to minimize risk:
- Work on a clean system snapshot if possible, or perform the cleanup during off-hours.
- Do not delete entire folders unless you know the contents are temporary cache data.
- Focus on the obvious cache locations: temporary files, Office cache, and Power Query caches.
- After clearing caches, restart Excel and reopen a few files to confirm normal behavior.
The goal is to clear stale, large, or corrupted cache entries, not to disrupt active data.
Step-by-step: how to clear caches on Windows and macOS
This section provides a practical, device-agnostic outline. The STEP-BY-STEP block below contains explicit actions; this segment explains the rationale and context so you understand why each step matters.
After clearing: testing and verification
After performing the cleanup, re-open a set of representative workbooks and run common tasks: search, formulas, data connections, and any add-ins you rely on. Check opening time, responsiveness, and accuracy of results. If you notice any lingering issues, retrace steps or restore from your backup if needed. Regularly verifying performance helps you decide whether you should schedule periodic cache maintenance.
Maintaining Excel performance over time
To prevent cache bloat, adopt a light maintenance routine: perform cache cleanup every few months or after major data-import activities, keep Excel and Office up to date, and regularly clear out very large temporary files that accumulate during heavy editing sessions. Pair cache maintenance with general OS housekeeping (disk cleanup, startup optimizations) for best results. Over time, these small precautions compound into noticeably faster startup and smoother operation.
<em>Note: This block is part of the main article body and intentionally expands on the topic without duplicating the STEP-BY-STEP section. The goal is to give readers context and practical guidance beyond the actionable steps.</em>
Tools & Materials
- Windows PC or macOS computer(Needed to access user profile folders and cache locations; paths vary by OS.)
- Excel installed and closed during cleanup(Close all workbooks to avoid locking caches; consider saving a recovery point.)
- Backup location (external drive or cloud storage)(Optional safeguard for critical files before cache cleanup.)
- File Explorer / Finder access(Navigate to cache folders in your user profile and delete cache files.)
Steps
Estimated time: 15-25 minutes
- 1
Close Excel and save work
Exit all Excel workbooks and ensure you’ve saved critical changes. If you use AutoSave, verify the latest version is saved to your cloud storage. This prevents conflicts or partial deletions of necessary cache entries.
Tip: Open Task Manager (Windows) or Activity Monitor (macOS) to confirm no Excel processes remain. - 2
Clear Windows temporary files
Open Disk Cleanup or run a temp-file purge to remove cached system temporary files. Temporary files may include Excel’s stray temp copies and OS-level caches used during editing sessions.
Tip: For a quick purge, run the command: %temp% and delete nonessential files. - 3
Clear Office/App cache files from your profile
Navigate to your user profile and locate Office-related cache folders. Delete contents of OfficeFileCache (and similar subfolders if present). Do not delete the parent folder unless you’re certain it only contains cache data.
Tip: If uncertain, move the files to a backup folder first, then delete after confirming Excel restarts smoothly. - 4
Clear Excel’s recent-files and document cache
In Excel, go to File > Options > Advanced. Under Display, set Show this number of Recent Documents to 0, close to apply, then reopen and set it back if desired. This reduces stale entries that can mislead the cache system.
Tip: Clearing recent files also helps in diagnosing whether the problem is cache-related or file-specific. - 5
Clear Power Query and Data Model caches
If you use Power Query, clear its cache via Power Query Editor or Data Load settings. This is especially valuable after refreshing large data sources or changing data connections.
Tip: Restart Excel after clearing Power Query caches to rebuild fresh data previews. - 6
Test performance and re-enable defaults
Launch a few workbooks and perform common tasks to gauge improvements. Revert any temporary settings (like Recent Documents) if you changed them. Document outcomes for future reference.
Tip: If performance remains unchanged, consider a broader cleanup (OS-level caches) or investigate add-ins and data connections.
People Also Ask
Does clearing Excel cache delete my data or worksheets?
No. Clearing cache removes temporary data used by Excel. Your worksheets and formulas remain intact, but ensure you have saved any unsaved work beforehand.
No—the cache is separate from your actual worksheets; save first and then clear caches.
Will clearing cache reset my Excel preferences?
No. Cache clearing targets temporary storage. Personal settings, ribbons, and saved preferences stay intact unless you manually reset them.
Your preferences stay unless you choose to reset them.
How often should I clear Excel cache?
Only when you notice slow startup, freezes, or odd behavior. Routine clearing is not required and excessive cleaning may rebuild caches more aggressively.
Only if you’re experiencing issues, not as a daily task.
Is it safe to clear caches on a Mac?
Yes. The steps are similar: close Excel, locate caches in the user Library folders, and delete temporary cache files carefully.
It’s safe on Mac as long as you close Excel first and avoid system folders.
What about Power Query caches?
If you use Power Query frequently, clear its cache after major data source changes to ensure fresh previews and connections.
Clear Power Query caches when data connections change a lot.
Will clearing cache fix corrupted workbooks?
If corruption is caused by stale cache, clearing can help. If issues persist, consider data recovery steps and backups.
Clearing cache may help with cache-related corruption but isn’t a cure-all.
Watch Video
The Essentials
- Close Excel before clearing caches
- Target only temporary and cache folders, not data files
- Back up important work before cleanup
- Test performance after restart to confirm improvement
