I have this same piece of code which consumes 3x more memory in one file vs another file. The initial memory usage for both files is just under 500MB. But when I hit this spot in the code the memory usage spikes up to 3000MB in one file and 9800MB in the other. The later causing out of memory issues for some of my coworkers.

On the "GetAccess" sheet there is a table where data is dumped from a database table. The memory spikes when I hit .Refresh. 

Please Login or Register  to view this content.