memory error

  1. S

    out of memory with small array

    All, I've ran into an error with my code where it gives me an out of memory error after i try to paste an array to a range. I've read through a lot of posts and everything seems to be with arrays in very large sizes which mine only has 13,000 rows. The strangest part is i have some string...
  2. P

    Memoisation in DAX measures

    Hello everyone, I do have to face a memory error in my DAX computations. To by-pass it, I have in mind to apply some memoisation. Do you think memoisation is possible in Power BI? Here is the context: - I have to work on some data related to 1000 videos; - measure A computes an average of the...
  3. srizki

    Excel can not complete this task with available resources. Choose less data or close other applications.

    Hi All, I am getting the following message, "Excel can not complete this task with available resources. Choose less data or close other applications." And when I click OK, I get the following message box. Microsoft Excel cannot open or save any more documents because there is not enough...
  4. P

    Macros Running Excel Out Of Memory

    OS X Yosemite 10.10.5 Excel 2011 version 14.7.2 (170228) on MAC Am running the below macros in module 4 as an end of month worksheet cleanup, and have been getting "Out of Memory" messages. How can this be fixed? Sub ClearCheckbookEntries() Range("V5:Y54,AB5:AE54").Select...
  5. T

    Help Understanding and Fixing Out of Memory & Automation error Catastrophic failure Messages

    I have a macro that is the most advanced I have built. However, it often crashes when saving if I have previously edited or ran it in my workbook. I typically get an "Out of Memory" error message and have recently received a "Automation error Catastrophic failure" error message. Bellow is the...
  6. T

    [Error] I'm getting the "Excel cannot open or save any more documents because there is not enough memory or disk space" error

    Hello, so i recently changed my PC's name (because of some program's incompability with accents). Since then i'm getting this error whenever i try to create a new excel sheet. I've tried some solutions but none of them have worked (i also have uninstalled and installed again). If someone could...
  7. K

    Excel VBA - Run Time Error 7 - Out of memory

    Hi, I keep getting Run Time Error 7 - Out of Memory in the following code: Sub PDFandValueVersion() ' This bit of code will select the worksheets to be PDF'd Dim rng As Range For Each rng In Sheets("Config").Range("A1:A" & Sheets("Config").Range("A" &...
  8. M

    VBA Excel memory problem (easy code)

    Hi all I wrote a simple code that gives me surprisingly (probably not surprising for you) a memory problem: "There isn't enough memory to complete this action..". I want to copy/paste rows from a sheet to another sheet based on two conditions. After it is pasted I want to delete those rows...
  9. T

    Run time Error 13

    Hi, Vlookups were taking forever so I wrote the below code to use the scripting dictionary. It works fine on smaller amounts of data but I am getting the Run time error on my "live run". I assume it is due to the size of my data. how can I fix this. My work sheets are between 250k and 350k+...
  10. E

    Out of Memory error in VBA macro

    I know there are several posts about this problem on this forum, but my problem is more confusing because i'm not even dealing with a significant amount of data. All I am trying to do is have a macro dynamically determine the # of rows of data for 1 worksheet and name a range based on that...
  11. D

    Excel 365 Pro-Plus performance issues

    Excel Performance Issues Microsoft Excel regularly crashes when working in large workbooks(although this appears to happen in normal sized workbooks) with the Error Message: 'There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory...
  12. A

    Excel Fuzzy Lookup Add-in - Exception out of memory

    I have been using Fuzzy Lookup for a while to match 2 lists with no problems. Just recently I have started to experience an error that return the following exception - Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib) I am not sure if it's caused bu the volume of the...
  13. G

    VBA Form1.Hide is unloading the form

    I am running a VBA wizard, and part way through I HIDE the form to allow the users to modify some items directly in one of the worksheets. After this is done, I SHOW the form, but all the information has reset. Series of events: 1. Run the form SetupWizard 2. Information is entered in a...
  14. S

    Out of Stack Space Error (Error No-28)

    Hello everyone!!:) Can anyone plz help me with this problem? I am calling a particular procedure in VB Excel repeatedly from a another procedure. After some time the excel hangs up and stops responding. It shows "Out of Stack Space Error" Is there a way to clear the stack space? Is ther any...
  15. S

    Cannot complete this task with available resources

    Hi Everyone, I am getting what seems (from my limited reserach) to be a fairly generic memory limitation with Excel. The error message on opening the file reads: Excel cannot complete this task witht he available resources. Choose less data or close the applications. After I open the file...

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