Hi folks,

One of my users built a spreadsheet that generates pivot tables based off queries run on our SQL server. Recently they started complaining about memory errors, and looking at Excel I noticed the following odd behavior.

I open excel and check the memory usage in task manger -- it looks normal. I hit "refresh all" in the spreadsheet and the memory usage jumps up -- also fine. However, if I refresh the data again, the memory usage goes up again. And again, and again. By hitting "refresh all" several times I was able to get Excel to use almost 2GB of memory.

It seems to me that Excel is holding old versions of the query results in memory -- is this by design? Can I turn this off somehow?

Thanks for your help.