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?

Help

--
Message posted from http://www.ExcelForum.com