Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

memory leaks using sql.request function

Status
Not open for further replies.
CraigMan

CraigMan

Programmer
Apr 27, 2004
33
US
I have a worksheet containing numerous dynamic sql.request formulas. Each time I update and recalc, I lose memory which is never given back to the system. Ultimately my laptop grinds to a halt and I get the low resources warning dialog from excel. Is there a way, using code or otherwise, to recover this memory after each recalc?

Craig Meyers, BSNucE, PE
 
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel - getpivotdata function 2
Replies
3
Views
116
arvarr
arvarr
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel - getpivotdata function 1
Replies
16
Views
210
arvarr
arvarr
ladyck3
  • Locked
  • Question
Excel 365 – (Formula/Function for Hyperlinks) and (Totals Yearly & Quartly) 2
2
Replies
24
Views
372
ladyck3
ladyck3
wmbb
  • Locked
  • Question
Why does VLOOKUP work and MATCH function gives #NA 1
Replies
6
Views
189
wmbb
wmbb

Part and Inventory Search

Sponsor

Back
Top