How to Clear Cache in Excel

Learn how to clear cache in Excel regularly and clean up recent file lists to improve the performance of your Microsoft Office.

You need to clear the cache when your Excel frequently freezes during a copy, paste, or other normal actions. This tutorial will cover how to speed up your Excel and avoid unwanted crashes.

How to clear cache in Excel (Microsoft 365)

Steps to delete the Office document cache immediately:

  1. Open Excel
  2. Select File > Options > Save > Cache Settings
  3. Click on the “Delete Cached Files” button
how to clear cache in excel

Here are some additional options regarding cached documents:

If you want to keep the cache empty, ensure the “Delete files from the Office Document Cache when they are closed” checkbox is active. In this case, you don’t need to clean up regularly the cache folder.

Note: Delete files in the cache that have been saved for faster viewing. This option will not delete items pending uploading to the server or items with upload errors.

Workaround: Office Upload Center is missing

In the last few weeks, we received some support emails with the following subject:

Office Upload center missing in my Microsoft 365

The Upload Center is available in Microsoft Office 2019, 2016, 2013, and 2010 and supports Microsoft 365. Microsoft is replacing the “Upload Center” and now provides a new feature: “Files Needing Attention”. This feature is currently available for Microsoft 365 users.

Clear Cache in Excel using the Office Upload Center

Following these steps to clear the cache if you have Office 2010, 2013, 2016, or 2019 versions:

  1. Select Start menu > Microsoft Office Tools > Office Upload Center
  2. Click the “Settings” button
  3. Click the “Delete Cached Files” button

#1 – Start Office Upload Center

Select the Start menu (or press the Windows key) and locate the Microsoft Office Tools menu. Click on it, then start the Office Upload Center.

start office upload center

#2 – Use ‘Settings’

The Microsoft Office Upload Center is useful Click on the Settings button (Gear icon) to open the Settings dialog box.

upload center settings

#3 – Delete Cached Excel Documents

After clicking the Settings button, the Microsoft Office Upload Center Settings will appear. Under the “Cache Settings”, you can find the same options as the Microsoft 365 version.

Click the “Delete Cached Files” button to clear the document cache.

delete cached files

Disable the Recent Documents List

Microsoft Office store the last opened documents list by default. When your Excel performance decreases, it is worth reducing the number of recently opened Documents to 0, disabling the list completely.

Here are the steps to remove the “Recent Documents List”:

  1. Click File Tab > Options.
  2. Select the Advanced Tab.
  3. Scroll down and locate the Display group.
  4. Set the “Show this number of recent Workbooks” to 0.
  5. Click OK.
Disable the Recent Documents List

Clear Pivot Table Cache

The Pivot Table cache contains some outdated table elements. It is worth clearing the cache if you use large tables with complex layouts, filters, and totals.

  1. Right-click any cell in the Pivot table
  2. Select Pivot Table Options from the Context menu
  3. Locate the Data Tab
  4. Set the “Number of items to retain per field” to none
  5. Click OK to close the dialog box
  6. Refresh the Pivot table using the right-click and Refresh command

clear cache excel pivot table

To clear the cache, you can use a “shortcut” by assigning the following macro to the Quick Access Toolbar. Then, press Alt + F11 to open the VBA Editor window.

Copy the code below to the ThisWorkbook:

Private Sub Workbook_Open()
Dim oPt As PivotTable
Dim oWs As Worksheet
Dim oPc As PivotCache

For Each oWs In ActiveWorkbook.Worksheets
For Each oPt In oWs.PivotTables
oPt.PivotCache.MissingItemsLimit = xlMissingItemsNone
Next oPt
Next oWs
For Each oPc In ActiveWorkbook.PivotCaches
On Error Resume Next
oPc.Refresh
Next oPc
End Sub

Additional resources:

Istvan Vozar

Istvan is the co-founder of Visual Analytics Ltd. He writes blog posts and helps people to reach the top in Excel.