Insufficient memory Caused by Pivots.
 

I have a workbook that runs 3 pivot graphs off a pivot table. I have
linked selections so that they all change together unfortunatly if you
watch my memory resources as each selection is made it builds up untill
excell crashes.

Is there a command I can use to clear excell memory between selections ?
I can code in VBA but cant find anything about dumping or clearing temp
memory to free up resources. Any advice would be appriciated.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!