Excel 2010 pivot table with external data source

Hi,

In my office we are running Office 2010 64 bit. We are facing issue with our Excel pivot table - where the memory keep increasing when use click on refresh all. Do I have option limit this memory usage?

/ Thava