No matter what app or device you’re using, all programs rely on cached memory to store frequently used files, functions, and values, in order to reduce load times and speed up the user experience. However, if you don’t regularly clear cached data, you may notice a drop in your computer’s performance. If you’re a regular Excel user, it’s important to know how to clear your cache from Excel.

VBA code:

Private Sub Workbook_Open()
Dim xPt As PivotTable
Dim xWs As Worksheet
Dim xPc As PivotCache
Application.ScreenUpdating = False
For Each xWs In ActiveWorkbook.Worksheets
For Each xPt In xWs.PivotTables
xPt.PivotCache.MissingItemsLimit = xlMissingItemsNone
Next xPt
Next xWs
For Each xPc In ActiveWorkbook.PivotCaches
On Error Resume Next
xPc.Refresh
Next xPc
Application.ScreenUpdating = True
End Sub

Check out the full guide on TechJunkie.com!
[ Ссылка ]

Music:
LiQWYD - Forest
[ Ссылка ]

свернуть