Microsoft Excel, just like other applications use a cache to store temporary data from the files you create. Sometimes cache makes your file slow and it takes storage space from your system. In this situation, you can clear the cache from Excel, or you can also change the days to save the files in the cache memory.
There are two ways to clear the cache, the first is to create and use the Microsoft Upload Center App and the second is to use the Excel option.
Steps to Clear the Cache in Excel
- First, go to the file tab and open the Excel options.
- From there, go to the save option and scroll to the end of the dialog box.
- Now from the Cache Settings, click on the “Delete cached files”.
- After that, you get a dialog box to confirm if you want to clear the cached files.
- In the end, just click on “Delete Cached Files” to clear the Excel’s cache.
At this point, all the cached Excel files have been deleted from your system. Apart from this, there are a few more options in the same setting group that you need to know.
- Days to Keep Files: You can change the settings to decide the days that you want Office to keep your files in the cached memory. By default, it is 14, but you can specify a day as you want.
- Delete Files from Cache when they are closed: This makes files delete from the cached memory once you close it.
Using Office Upload Center to Clear Cache
You can also use the Office Upload Center that comes with the Office software package. Once you open the Upload Center, click on Settings ⇢ Delete cached files ⇢ Delete cached information.
In Office 365, the Office Upload Center has been removed and replaced by Files Needing Attention. You can find this option in File ⇢ Open ⇢ Files Needing Attention.