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...
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...
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...
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?
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...
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...
I keep getting Run Time Error 7 - Out of Memory in the following code:
' 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" &...
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...
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+...
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...
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...
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...
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...
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...
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...