Microsoft creates a copy of every file we create either on Excel or any other program. All these backup files reside in the cache folder, and you may use them to recover your files. But, although cache files are helpful, they can get corrupted and cause Microsoft to crash.
So, it’s best if we can clear cache regularly to keep Microsoft running smoothly. In this article, let’s dive into how we can clear cache in Excel.
How to Clear Cache in Excel on Windows
you may find the Excel cache location in your C drive, specifically the AppData folder. This is the default folder where MS Excel saves backup copies of your files. Nevertheless, there are a few easy ways you can clear cache in Excel.
Disable the Recent Documents List
One of the first ways you may attempt to clear cache in Excel is by clearing the recent documents list. Here are the steps you need to take to turn it off:
Using the Microsoft Upload Center
You automatically get the Microsoft Upload Center when you get Office programs. So, you may use it to manually clear Excel cache files. You can access the Upload center by simply typing its name in the search bar. Then, you can follow these steps:
Try Windows Disk Cleanup
you may utilize the Windows Disk Cleanup to eliminate any temporary files andclear the cacheof programs, like Excel. Here’s how you can use it:
Clear Pivot Table Cache
you may also clear the Excel cache by clearing pivot table cache. Here’s the way you can perform this action using the PivotTable Options.
How to Clear Cache in Excel on Mac
Since most of the processes are similar to Windows, you may refer to all the solutions above to perform on Mac. However, there is one exclusive method you can try on Mac to eliminate Excel cache:
If you have trouble finding the exact folder, you may also look for folders with other names via Terminal.
