finansu
finansu copied to clipboard
Memory Leakage
By using live quotes there is a memory leakage in Excel 2010. The memory Excel consumes, grows bigger and bigger until (eventually), Excel begins to behave erratically and does not respond anymore. You can easily follow that by watching the Excel proces in Windows Task Manager. In asking one quote, nothing dramatic happens. When asking multiple quotes (like 25 different ones for instance) you notice a rapid increase of memory usage. This might be caused by non released variables after using them to store information from the websites.
If you let me some email address, I could send you an example Excel file for you to test this.
Sincerely,
Marc