Pivot tables that pull from SQL Database and Memory Leaks?
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By keithgoldner in forum Excel - New Users/Basics
Last Post: 12-08-2011, 08:52 AM
By gareth.campbell in forum Excel General
Last Post: 11-24-2010, 12:23 PM
By kosciosco in forum Excel General
Last Post: 02-25-2008, 10:30 AM
By Philip in forum Excel Programming / VBA / Macros
Last Post: 10-05-2005, 01:05 PM
By Cheer in forum Excel Programming / VBA / Macros
Last Post: 02-15-2005, 06:45 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1