Cache files are very important for the device to make the OS understand and remember the most used values and entries. But sometimes the cache data creates glitches in the smooth functioning of the device. It creates issues on older versions of computers. If you are also experiencing a performance drop on your machine, then you need to clear Microsoft Office cache data.
Here is how to remove cache data directly from Excel files:
Deactivating the Recent Documents List
The quickest way to enhance the performance of MS Excel is to set up the number of latest documents shown to zero. To do so, you have to deactivate the recent document listing. Follow these guidelines to disable the same:
- In the beginning, hit the Office tab situated at the uppermost left-hand side edge. There might not be the Microsoft Office tab if your device is of the older version. If that is the case, hit the File button located in the primary menu.
- Now, the Office menu will launch on your screen. Hit the Options tab situated at the lowermost section of the menu button.
- When you have successfully entered into the Options menu, then move towards the “Advanced” section.
- Next, scroll down the page to the Display tab.
- Then, set the value of the first-most option that is “Show this number of Recent Workbooks,” to Zero.
- After that, hit the Enter key to save all the modifications you have made. You will be able to view the empty “Recent Document” list whenever you tap the File or Office tab next time.
Removing Pivot Table Cache Data
Pivot table cache is among the most necessary cache clearing options, especially in MS Excel. By removing this cache, you will be able to clear the unnecessary, older and unused contents. In order to clear Pivot table cache data, follow these straightforward steps:
Using Pivot Table Options
- First of all, perform a right-click on any cell in the Pivot Table. After a while, you will see the context menu.
- Choose the Pivot Table “Options.”
- Now, move to the section tab Data” and then set the value to “None” related to the option “Number of Items to Retain per Field.”
- Hit the Enter key to save the changes you have made.
- In order to make the changes to take effect, you need to apply right click on the pivot table cell once more and then select the option “Refresh.”
Using VBA Code
Visual Basic for Applications is the Microsoft program that covers all the entire pivot tables. Pursue these guidelines to use VBA for clearing Pivot table cache easily:
- In the beginning, you have to open the file on which you desire to remove the pivot table cache. Then, hit these keys simultaneously: Alt + F11 to launch the Microsoft VBA.
- Then, perform a double click on the section “ThisWorkbook” located in the panel of “Project” towards the left-hand side section of the window.
- Now, apply the cache clearing code of Pivot Table into the code window “ThisWorkbook.”
- In order to execute the code, hit the F5 tab. It will clear all the cache of pivot tables from your workbook.
Clearing MS Office Cache Manually
Using Microsoft Office Upload Center
- First of all, launch the Upload Center and then press the Settings tab.
- Once you are in the Upload Center Settings page, hit the checkbox “Delete Files from the MS Office Document Cache when they are closed.”
- Now, press the tab “Delete Cached Files.”
- Verify your decision by tapping the option “Delete Cached Info.”
Note: You may also set up the option “Days to keep files in the MS Office Doc Cache” as per your desire.
Clearing Cache Data Using Disk Cleanup
Disk Cleanup application helps the user to clear temporary files in the form of cache data from the device, including cache memory of Microsoft Office documents. Follow the complete instructions to delete cache data through Disk Cleanup program:
- At the start, launch the Disk Cleanup program on your device. Then open it and then choose the drive where Microsoft Office is currently installed.
- After that, hit the OK tab there.
- Once the program is completely finished with analyzing files, press the section “Files to Delete.”
- Then, choose the checkbox of temporary files and then tap the OK button.
- After some time, you get MS Office free from cache data.
- Finally, reboot the device and make sure that the cache files are completely cleared from the software of MS Office.
Conclusion
Microsoft Excel is the part of the Office suite package and is one of the primary applications. It also helps in managing and customizing various spreadsheet programs. Sometimes Excel files create issues. If that is the case, you need to remove these cache files from your device for smooth performance.
SOURCE:- How to Clear Cache in Microsoft Excel?
