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 can 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 can 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’re able to 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 can use it to manually clear Excel cache files. You can open the Upload center by simply typing its name in the search bar. Then, you can follow these steps:
Try Windows Disk Cleanup
you may use 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 can 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 can 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 can also look for folders with other names via Terminal.
How to Clear Microsoft Office Cache on Windows
Besides Excel, you can also clear the complete cache files of all other apps in Microsoft Office. Doing so will make sure all other apps perform well. You can find the Office Document Cache feature in the MS Office Upload Center. An easy way to clear the Office cache is by choosing an automatic setting.
This method works especially for Office versions of 2108 or newer. Every time you reopen Office, your cache files will automatically disappear.
How to Clear Microsoft Office Cache on Mac
you’re able to use the personality menu of a task pane add-in to remove Office cache files on Mac:
How to Fix the ‘Microsoft Office Document Cache Encountered a Problem’ Error
As mentioned previously, your Office cache files can get corrupted at times. MS apps will not function properly when this happens, and your files can get stuck. You might even see the error ‘Microsoft Office Document Cache encountered a problem.’ Along with it, you’ll also get a link for repairing. But, clicking on it can lead to more errors.
You can follow the steps above to delete Office cache files entirely to fix the said error. Other fixes you can try are performing a clean boot and restarting your PC. Here’s how you can perform a clean boot on your PC:
