Once you’ve found the Disk Cleanup program, open it and select the drive where Microsoft Office resides.You can find Disk Cleanup the same way you found the Office Upload Center. Windows Disk Cleanup helps remove many temporary files, including Office documents. Note: You can also set the Days to keep files in the Office Document Cache option to your liking. Confirm your decision by clicking on the Delete cached information button.Click on the Delete cached files button.In the Upload Center settings, tick the Delete files from the Office Document Cache when they are closed checkbox.Open the Upload Center and click on the Settings button.

In Windows 8 and 8.1, access the Search option by hovering with the mouse over the bottom-right corner of the screen. In Windows versions 7 and 10, you can find this application by typing its name in the Start Menu’s search bar. You can use a program called Microsoft Office Upload Center to manually clear the cache for all Office programs. How to Manually Clear the Office Cache Clear Office Cache Using the Office Upload Center This action will clear the pivot tables’ cache in the active workbook. = xlMissingItemsNoneįor Each xPc In ActiveWorkbook.PivotCaches Copy and paste the following code into the ThisWorkbook code window:įor Each xWs In ActiveWorkbook.Worksheets.Double-click on ThisWorkbook in the Project pane to the left to open the code window.Open the file for which you want to clear the pivot tables cache, then press Alt + F11 to open Microsoft Visual Basic for Applications.

Mac excel 2013 some file slow to open