P
Portuga
Hello
I have a bit of a problem that I hope you can help me with.
I created a reporting tool in Excel with 52 pivot Tables linked to
SQL Server. (Olap Cubes)
I created a Macro that updates all this pivots in sequence. My proble
about this is that every time a pivot is refreshed and it connects t
the data source, the amount of memory used by my computer increase
drastically. (About 20 MB per update).
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?
Help
I have a bit of a problem that I hope you can help me with.
I created a reporting tool in Excel with 52 pivot Tables linked to
SQL Server. (Olap Cubes)
I created a Macro that updates all this pivots in sequence. My proble
about this is that every time a pivot is refreshed and it connects t
the data source, the amount of memory used by my computer increase
drastically. (About 20 MB per update).
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?
Help