memory leak

  1. H

    insufficient memory

    I need to run (a variant of) this module a few hundred times. After a few times (2 to 5) I get an error "insufficient memory". Anybody any idea how to fix this? Sub testertje() Dim WBmodel As Workbook Dim WSscan As Worksheet Dim pad As String pad =...
  2. H

    Excel Crashes When Inserting Row(s)

    Hello all, I'm having an issue, which I found is quite common (nevertheless, I haven't found an answer for it). Basically, I'm trying to add new rows (5 new rows, to be specific) on top of a table I previously created and formatted. When I try to insert new rows, Excel crashes and gives me...
  3. D

    Pivot Table Refresh Macro Causing Memory Issues

    Good afternoon, I am working with a large spreadsheet that makes use of an equally large number of pivot tables. Currently the sheet has 231 pivot tables, 228 of which are all referencing the same data source. That data source is also, not surprisingly, large. The data source covers 90...
  4. S

    Probable Memory Leak in Macro making excel super slow

    I have created an automated macro which takes vehicle crash data from a csv file and automatically creates pivot table,charts and compares it to the previous year. The code is approximately 1400 lines long and the data of the uploaded csv can be anywhere between 2 to 100 mb csv files with more...
  5. D

    Loop within a loop causing memory leakage

    The following code results in a huge jump in memory (that isn't released once its run) even though there is only 2 Integer variables and 1 String variable. Its a simplified version of some 'real code' which makes VBA run out of memory and crash. Any ideas what's going on and how to resolve? Sub...
  6. D

    Small File, Low Performance

    Hello, I have an Excel file that is larger in size than it 'should' be. The file is a simple template that is placed on a network drive and updated by between 2-3 dozen people on a daily basis. It's 14 sheets, but should only have about 20 rows and 10 columns of data per sheet. When the...
  7. O

    Memory leak on save

    Hi All. I have a workbook with lots of macros. When I save the workbook either via code or manually I get a memory leak of between 10mb and 100mb (i.e. the memory usage increases by 10mb to 100mb each time). Has anyone else encountered this? I'm assuming it's not normal because, at that rate...
  8. B

    Excel high CPU usage and increasing memory leads to crash

    I have a workbook with a lot of userforms, modules, OLE objects. 6.4 Mb file size. I have successfully used the same template over and over. Now i have one template that shows calculate in the status bar every time a cell is selected. Nothing is even changed. When i update a cell value, cpu...
  9. D

    Memory Leak Automation error

    Good Day, Something weird is happening… I’ve a rather large program that I’ve broken up into little mod’s. During an early phase of breaking things up I needed to reduce memory. In an effort to reduce memory, I put things like Set ws=nothing Set msformz=nothing Set msbuttonz=nothing ---I did...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top