What clearing cache in Excel actually does

Excel stores temporary data in memory and on your hard drive to make the program run faster. Over time, this cached data can accumulate and cause Excel to slow down, freeze, or display outdated information. Clearing the cache removes these temporary files and forces Excel to rebuild them fresh, which often fixes performance problems and memory issues.

The cache you clear depends on what's slowing you down. Excel maintains several types of temporary storage: the Office cache (which stores recent files and settings), the temporary file folder (which holds backup copies of spreadsheets you're working on), and the AutoRecovery cache (which stores versions of files in case of a crash). You may need to clear one or all of these to see improvement.

Key Takeaways

  • Clearing Excel's cache removes temporary files that can cause slowdowns, freezing, or display errors without affecting your saved spreadsheets.
  • The fastest method is deleting files from your temp folder, which takes about two minutes and requires no Excel restart.
  • Clearing the Office cache through settings is useful when Excel won't open recent files or displays outdated document information.
  • AutoRecovery cache clearing is necessary only if Excel keeps trying to recover old versions of files you no longer need.
  • After clearing cache, restart Excel to ensure the program rebuilds its temporary storage correctly.

Clear the temporary files folder (fastest method)

The temporary files folder holds backup copies and working versions of spreadsheets while you have them open. This folder grows quickly if you work with large files or leave Excel running for days. Clearing it is the fastest way to free up space and often solves freezing problems.

On Windows: Open File Explorer and navigate to C:\Users\[YourUsername]\AppData\Local\Temp. Replace [YourUsername] with your actual Windows username. Look for files with names starting with "~" or containing "Excel" — these are Excel's temporary files. Select them and press Delete. You do not need to restart Excel for this to take effect.

On Mac: Open Finder, press Command+Shift+G to open the "Go to Folder" dialog, and type ~/Library/Caches. Look for folders named "com.microsoft.Excel" or similar Microsoft Office folders. Open each one and delete the contents. You can also search for "Excel" in this folder to find related cache files quickly.

If you cannot find these folders, they may be hidden. On Windows, open File Explorer, click View, and check "Hidden items". On Mac, press Command+Shift+. (period) in Finder to show hidden files.

Clear the Office cache through Excel settings

The Office cache stores information about recent files, document properties, and user settings. Clearing it from within Excel is useful when the program displays outdated file information or won't open recent documents correctly.

On Windows: Open Excel and click File in the top left. Select Options at the bottom of the menu. In the Options window, click Advanced on the left side. Scroll down to the Display section and look for an option related to clearing the cache or recent files — the exact wording varies by Excel version. Some versions have a "Clear" button next to "Recent Documents". Click it, then click OK.

On Mac: Open Excel and click Excel in the top menu bar. Select Preferences. Click General, then look for Recent Files or Cache options. Click the X or Delete button next to "Recent Documents" to clear them. Close the Preferences window.

After clearing the Office cache, restart Excel completely. Close all open spreadsheets and quit the program entirely, then reopen it. This ensures Excel rebuilds the cache correctly.

Clear AutoRecovery cache files

AutoRecovery is Excel's safety feature that saves versions of your spreadsheets automatically while you work. If Excel crashes or closes unexpectedly, it offers to recover those files when you reopen it. The AutoRecovery cache can grow large if you work with many big files, and old recovery files may clutter your startup.

On Windows: Open File Explorer and navigate to C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. Look for files with names like "AutoRecovery save of [filename]". Select the ones you no longer need and delete them. You can safely delete all of them — Excel will create new ones the next time you work on a spreadsheet.

On Mac: Open Finder, press Command+Shift+G, and type ~/Library/Application Support/Microsoft/Office/Office User Settings. Look for AutoRecovery or crash recovery files and delete them. If you cannot find this folder, search Finder for "AutoRecovery" to locate the files directly.

Alternatively, you can disable AutoRecovery entirely if you prefer. In Excel, go to File > Options (Windows) or Excel > Preferences (Mac), find the Save section, and uncheck "AutoRecover". This prevents Excel from storing recovery files, though you lose the safety net if the program crashes.

Restart Excel and check for improvement

After clearing any cache, close Excel completely and wait a few seconds before reopening it. This gives your computer time to finish deleting files and ensures Excel starts fresh with a clean cache.

Open a large spreadsheet or one that was causing problems before. The file should open noticeably faster, and Excel should respond more quickly to your clicks and typing. If you still experience slowdowns, the problem may be the spreadsheet itself — very large files with thousands of rows or complex formulas will always be slower — rather than cache buildup.

If clearing cache does not help, check whether Excel is using too much memory. Open Task Manager (Windows: Ctrl+Shift+Esc, Mac: Command+Space, type Activity Monitor). Look for the Excel process and note how much memory it is using. If it is using more than 2 GB, the spreadsheet itself is too large for your computer to handle comfortably, and you may need to split it into smaller files or add more RAM.

When to clear cache versus when to leave it alone

Clear cache when Excel is slow to open files, freezes while you work, displays outdated information about recent documents, or keeps offering to recover files you have already deleted. These are all signs that temporary files have accumulated or become corrupted.

Do not clear cache if Excel is running normally and you have no performance problems. The cache exists to make Excel faster, and clearing it removes that benefit until the cache rebuilds. Clearing cache is a troubleshooting step, not routine maintenance.

If you clear cache and problems return within a few days, the issue is likely something else — a corrupted spreadsheet, a plugin that is slowing Excel down, or insufficient RAM on your computer. In that case, focus on identifying which spreadsheet causes the slowdown or whether a recently installed add-in is the culprit.

Frequently Asked Questions

Will clearing cache delete my spreadsheets or unsaved work?

No. Cache clearing removes only temporary files that Excel creates behind the scenes. Your saved spreadsheets remain untouched. However, if you have unsaved work open in Excel when you clear the temp folder, you may lose that work if Excel crashes during the process. Save all open files before clearing cache.

How often should I clear Excel cache?

Clear cache only when you notice Excel is slow or freezing. For most users, this is once every few months or once a year. If you work with very large files daily, you may need to clear cache every few weeks. There is no benefit to clearing it more often than that.

Can I clear cache while Excel is open?

Yes, you can delete files from the temp folder while Excel is running. However, if Excel is actively using a temporary file when you delete it, the program may crash or behave unexpectedly. It is safer to close Excel first, clear the cache, then reopen it.

What is the difference between clearing cache and clearing recent files?

Recent files are shortcuts to spreadsheets you have opened — clearing them just removes the list from Excel's File menu. Cache is temporary data Excel stores to run faster. Clearing cache removes actual files from your hard drive, while clearing recent files only removes shortcuts. Clearing cache has a bigger impact on performance.

Does clearing cache improve Excel security?

Clearing cache does not improve security. It removes temporary files that could theoretically be recovered by someone with access to your computer, but this is not a meaningful security risk for most users. If you are concerned about sensitive data in temporary files, encrypt your hard drive instead of relying on cache clearing.