How to Clear Cache in Microsoft Office; Whenever you create a file in Microsoft Word, PowerPoint, Excel, or any of these types of Microsoft Office applications. Along with this, it also generates a copy of the file in the cache folder that can be used to speed up Microsoft Office. This backup file can also be used as a recovery file if your main file is damaged. The cache clearing process can solve many problems that occur in Microsoft Office. So, if you see any unusual behavior in MS Office, first clear your desktop cache.
Microsoft creates a copy of every file that we create in Excel or any other program. All of these backup files reside in the cache folder and you can use it to recover your files. But while cache files are useful, they can get corrupted and cause Microsoft to crash. Therefore, it is better to clear the cache regularly for Microsoft to work properly. In this article, let’s see how we can clear cache in Excel
How to clear cache
- Click windows button.
- Go to Microsoft Office Tools, then click “Office Download Center. A download manager window will open.
3. Click Settings
4.Click the Delete Cache Files button and then click the OK button
How to clear the cache of Office documents
Sometimes this cache needs to be cleared, especially when you get errors on a file, document, or presentation that you’re trying to upload to the server.
Probably the easiest way to improve Excel performance is to set the number of recent documents displayed to zero. In other words, you are effectively disabling the recent documents list. This is how you can turn it off:
Clear pivot table cache
Among the most important Excel-specific clear cache options are those that allow you to clear a PivotTable’s cache. This removes old and unused items. There are two ways to do this.
Symptoms
How to Clear Cache in Microsoft Office; Consider the following scenario:
- A 32-bit version of Microsoft Office is installed on a computer running a 64-bit version of Windows.
- You try to clean temporary Office files from the Office document cache when you run the Windows Disk Cleanup utility to free up disk space.
- In this scenario, the temporary Office files are not deleted.
Cause
The 32-bit version of Office 2010 does not install a 64-bit version of Disk Cleanup Assistant Manager.
More information
The Office Document Cache Disk Cleanup Wizard Manager is available in the Windows Disk Cleanup utility. This driver enables the Windows Disk Cleanup utility to delete Office Document cache files that are not pending download to free up disk space. To enable Disk Cleanup Assistant Manager for Office Document Cache, follow these steps;
- Start the Disk Cleanup Wizard.
- To do this, click Start, All Programs, Accessories, System Tools, and then Disk Cleanup.
- Select the drive you want to clean, then click OK.
- Under Files to delete, select the Temporary Microsoft Office Files check box.
You receive an error message when you try to open an Office document
To” section, you receive one of the following error messages: The file name is not valid. The file cannot be accessed. The path you entered, ‘filename’, is too long. Enter a shorter path. filename not found.
Cause
This issue occurs if the path of the file you are opening or saving meets the following condition;
Microsoft Word, Microsoft PowerPoint, and Microsoft Access: The total length of the path and filename, including the filename extension, exceeds 259 characters.
How to clear the cache in Excel on Windows
- You can find the Excel cache location on your C drive, especially in the AppData folder.
- Disable recent documents list
- One of the first ways to try to clear the cache in Excel is to clear the list of recent documents. Here are the steps to disable it:
1.Open Excel and click File in the top left corner.
2.On the menu page, click Options located on the left panel.
3.Click on the Advanced tab.
4.show-this-number-of-recent-workbooks
Try Windows Disk Cleanup
You can use Windows Disk Cleanup to remove all temporary files and clear the cache of programs such as Excel.
Clear Microsoft Office Cache in Windows
Apart from Excel, you can also clear entire cache files of all other Microsoft Office applications. This will ensure that all other applications work properly. You can find the Office Document Cache feature in the MS Office Download Center. An easy way to clear the Office cache is to choose an automatic setting.
This method works especially for Office versions of 2108 or later. Every time you reopen Office, its cache files automatically disappear.
1.Open any Office program and click File.
2.Click Option.
3.Go to Trust Center > Trust Center Settings > Trust Plugin.
“Microsoft Office Document Cache has encountered a problem” error
As mentioned above, sometimes Office cache files can get corrupted. MS applications will not work properly when this happens and your files may get stuck. At the same time, you will also get a link for repair. But clicking on it can lead to more errors. You can follow the steps above to delete Office cache files completely to fix such error. Other solutions you can try are to perform a clean boot and restart your PC. This is how you can perform a clean boot on your PC:
1.Configuration in the search bar.
2.Check all the boxes and click Hide all Microsoft services.
3.Click Disable All.
4.Select all programs and click Disable
5.You can now close Task Manager.
6.Now go back to the Startup tab of the system configuration program and click OK. Finally, restart your PC.
Office 365 onedrive offline Cache size issues
Although we ignore the fact that the pro version of OneDrive is actually a SharePoint site in disguise, we have major problems uploading a few hundred gigs of content. This also applies to the home version of OneDrive. My setup is pretty common, I’m running Windows on a 512GB SSD and have another 2TB drive to store photos and videos. I installed the app and started uploading photos and videos of around 300GB.
After a few hours, the sync had failed miserably, the computer was barely usable due to a lack of system disk space. It turns out that Office 365 thinks it’s a good idea to create an offline cache in the user’s AppData folder (located on the system drive) for each file
Editor’s recommended: How to Clear the Cache in Microsoft Edge