Excel Programming >> PivotCache memory resource Problem
Hello
I created a automated reporting tool in Excel with 52 pivot Table
linked to a SQL Server. (Olap Cubes)
I also created a Macro that updates all this pivots in sequence. M
problem about this is that every time a pivot is refreshed and i
connects to the data source, the amount of RAM memory used by m
computer increases drastically. (About 20 MB per update). Even afte
the updates are done, the memory still stays unavailable.
Below is a line of the Macro I use:
ActiveSheet.PivotTables("PivotTable19").PivotCache.Refresh
I know that the information is stored in memory (cached), but tha
causes a problem to me as some machines wont have the resources to d
that.
My question to you is: is it possible to clear the pivot cache memor
once each pivot is updated by the macro so the memory is released? An
if so, how do I do that?