Link to home
Start Free TrialLog in
Avatar of NYQuicksale
NYQuicksaleFlag for United States of America

asked on

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

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?
Avatar of prashanthd
prashanthd
Flag of India image

Avatar of NYQuicksale

ASKER

but i'm already deleting the connections and named ranges, there's no any single connection in my sheet
i mean my code, i've code which deletes every connection right on the time, it is created
ASKER CERTIFIED SOLUTION
Avatar of prashanthd
prashanthd
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
didn't provide the solution