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:
- Open Excel
- Select File > Options > Save > Cache Settings
- Click on the “Delete Cached Files” button
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:
- Select Start menu > Microsoft Office Tools > Office Upload Center
- Click the “Settings” button
- 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.
#2 – Use ‘Settings’
The Microsoft Office Upload Center is useful Click on the Settings button (Gear icon) to open the Settings dialog box.
#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.
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”:
- Click File Tab > Options.
- Select the Advanced Tab.
- Scroll down and locate the Display group.
- Set the “Show this number of recent Workbooks” to 0.
- Click OK.
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.
- Right-click any cell in the Pivot table
- Select Pivot Table Options from the Context menu
- Locate the Data Tab
- Set the “Number of items to retain per field” to none
- Click OK to close the dialog box
- Refresh the Pivot table using the right-click and Refresh command
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