Microsoft Excel applies a cache to access your frequently needed information faster than any other program. However, over time, it can drastically slow down the application if you are not tidying up your storage space. If your Excel workbook occupies ample disk space, it probably means removing the cache from your Windows 10 desktop is high time. Don’t know how? Let’s find out!
Now, you can solve your problem of making your workbook load faster and provide your users with the best experience, especially when dealing with large data sets or complex formulas. Read on to find out how you can eject out unnecessary cache.
Via Excel
Excel Spreadsheet users can directly delete the cache files from the application. Follow the steps mentioned below to do the same:
1. Power on your computer, open Excel and click on the file option in the upper left corner of the workbook.
2. Click on Options.
3. Finally, from the pop-up window, select Save at the left menu bar.
4. Skip down and click the button labeled Delete cached files.
5. They will be clicked again on Delete Cached Files to confirm the action.
Via Trust Center
You can also find the Trust Center within the Excel’s menu to remove any cache that can be downloaded from the internet or to include websites in your workbook. Check out how:
1. Open Excel and click on File.
2. On the Info page, click Options on the top toolbar and select Trust Center from the drop-down list on the left side of the page.
3. Finally, click on Trust Center Settings.
4. Trustworthy Add-in Catalogs.
5. The first time you type a tick on “Next time Office starts,” all previously started web add-ins’ caches are cleared.
6. Click on OK.
Via File Explorer
The other method to clear the Excel cache is to go to Windows Explorer in Windows 10 and retrieve the cache contents of Excel.
Option 1: From Microsoft Folder
You can delete cache files in the Microsoft folder location path. Follow the steps shown below:
1. Open File Explorer and click on the C: folder from the left menu.
2. Next, click on the Users folder and choose your username; once more, click on User.
3. Then go to the top of the page and click View, and from the drop-down menu, select Show.
4. Select Show hidden items from the window to unhide the items on the screen.
5. Appdata,_USERS_, click Local, now.
6. Next to the last step, click on Microsoft, and move down in the list to choose the Office folder.
7. Click on 16.0. Go down, choose option Wef, and then erase the folder.
8. Kindly note that if Wef has a folder OfficeFileCache on your computer, they can only select the option to delete that folder.
Option 2: From Packages Folder
You might also find Excel cache files in Microsoft’s packages. Check out the steps to identify and remove it from your PC:
1. Go to Option 1, then complete the steps from 1 to 5.
2. Click on Packages.
3. If you scroll down to here, you should select Microsoft.Win32WebViewHost_cw5n1h2txyewy.
4. Click on AC and select #!123.
5. Choose INetCache to delete the file.
How do I Change Days to Keep Cache Files in Excel on Windows 10?
Actually, you can change the schedule for how long Excel is required to hold the unnecessary cache files in its system. Here’s how:
1. Open Excel > File > Save > Save as.
2. Scroll downward until you come to the box that says Days to keep files in the Office Document Cache, and then type in your day.
3. Check Delete files from the Office Document Cache when the files are closed.
4. Now, select OK.
