We help IT Professionals succeed at work.

Task Manager Memory Private Working Set boosts up when web query is running in excel

NYQuicksale
NYQuicksale used Ask the Experts™
on
Hi,
My excel has URLs and my codes connect each url via web query, the problem is the system gets slow as the time goes on and in the task manager i see the memory is increasing way beyond, i guess its the memory leak. someone has any idea about it? how to control this memory leak during web query?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:

Author

Commented:
but i'm already deleting the connections and named ranges, there's no any single connection in my sheet

Author

Commented:
i mean my code, i've code which deletes every connection right on the time, it is created
Top Expert 2011
Commented:

Author

Commented:
didn't provide the solution