This question has been posted in other, more oblique manners scattered
over this forum through the years but none of the answers satisfied
me.

I am using QueryTables with Excel 2003 to pull external data from SQL
Server. Every Refresh call (I have several QueryTables) chews up a
few more MB of memory, until Excel hits the limit of memory allocation
and goes toes up.

Is there a way to reclaim this memory?
If not, is there a way to prevent the memory leak?

This is the offender:

Range("XXX").QueryTable.Refresh BackgroundQuery:=False

Please post any solutions you may have come across.

Thanks,
Shawn