QueryTable Memory Leak

  • Thread starter Thread starter Shawn A
  • Start date Start date
S

Shawn A

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
 
(e-mail address removed) (Shawn A) wrote ...
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.

Can't reproduce. More details, please.

Jamie.

--
 
I have fixed my problem. It was through fault of my own (and a known
bug in Excel) which was causing this issue.

It turns out I was pulling data from my own file, which causes
extraordinary memory leaks and which MS admits to being an outstanding
Excel bug. Dumping into an external file and querying this cured my
woes.

Cheers,
Shawn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top