Thanks for this solution but using Excel 2010, when I try to reopen the file, it becomes blank and I cannot see the content. Until I go and unmarked. Please I need your help. Thanks
I know this is a tad old but for some of us who use Nav2009 and Jet Reports the Ignore Other Apps options is not acceptable BUT since our systems are 64 bit using 64bit Office did help if these fixes in the Video didn't help you like us.
"Unblock" worked for me. Environment: Windows-10, Excel 2019, .xlsx file saved from a web page. When opening file Excel reports that there is not enough memory to open the file. I opened the .xlsx file properties and checked the "Unblock" box related to security as the file was, certainly, from another computer. File opened, issue fixed. How Microsoft can get away with such unfriendly user code is beyond me.
I have done what you show me and restart the computer, when I open the file again, all my file is blank, there is nothing in the excel sheet, so I have to untick and restart my computer again, then my file is appear but I am back to square one!
We had to upgrade to 64 bit Office to get rid of the error once and for all, 30 users had the issue, once they were upgraded no-one has had it since, seems to be an issue on 64bit OS and 32 bit Office in my opinion.
![How to Fix Excel Not Enough Memory? [4 Solutions]](http://i.ytimg.com/vi/nDO_sS6JtmY/mqdefault.jpg)
Wow, the second method worked for me. I encountered the issue so frequently. Now it is running smoothly. Many thanks for your video.
Very useful!!
I was having a headache with an Excel document at work.
Thanks,
Thanks
Superb solution provided by you. I was literally pissed by my persistently not responding excel files.
Best solution ever! Thank you.
this is perfect - but my excel file is missing the FILE tab on the ribbon. I can't figure out how to restore it. any thoughts?
2nd one worked for my wife! thanks!
U saved my job tonight !!!
Thanks for this solution but using Excel 2010, when I try to reopen the file, it becomes blank and I cannot see the content. Until I go and unmarked. Please I need your help. Thanks
this happened me too
Will try that at work on Monday. I get this error a lot with Power Query / Pivot 😞
HI Good morning, Thanks a lot. It has solved my excel file problem. thank you once again
THIS WORKED THANK YOU SO MUCH
I know this is a tad old but for some of us who use Nav2009 and Jet Reports the Ignore Other Apps options is not acceptable BUT since our systems are 64 bit using 64bit Office did help if these fixes in the Video didn't help you like us.
"Unblock" worked for me.
Environment: Windows-10, Excel 2019, .xlsx file saved from a web page. When opening file Excel reports that there is not enough memory to open the file.
I opened the .xlsx file properties and checked the "Unblock" box related to security as the file was, certainly, from another computer. File opened, issue fixed.
How Microsoft can get away with such unfriendly user code is beyond me.
But why would this happen from a file originated from my computer?
Thank you sir.
thank you
Nope.
That made no difference at all.
nice, its work
Thank you!
I have done what you show me and restart the computer, when I open the file again, all my file is blank, there is nothing in the excel sheet, so I have to untick and restart my computer again, then my file is appear but I am back to square one!
same thing to me also
wait.. but the spreadsheets my user's pull data from other sources.. so I can't turn that option off.
We had to upgrade to 64 bit Office to get rid of the error once and for all, 30 users had the issue, once they were upgraded no-one has had it since, seems to be an issue on 64bit OS and 32 bit Office in my opinion.
Oh! You saved me
WHEN I PRESS ENTER, I CAN'T TYPE THEN IT CLOSE EXCEL AND RESET
Thank you. It’s working
My excel not opening problem, it says having not enough memory, ,,,,,help
Doesn't work for me :/
Thanks 👍🏻
my pc no is startup beause this error
Excellent, will test to see if this works.
Didn't work for me :(
Life saver
This has never worked with my Dell laptop!
It did not work for me,
But we copy and paste in new excel sheet, save it, and it works. :)
Good to know that because the problem again popped up
thanks bro.. it worked...
This worked for me.
But my error prompt was 'Out of memory' when I was trying to edit VBA.
not working same issue
How to recover data
i cannot find the "unblock"
It would be under the General Tab in properties, not all files would have the option to unblock.
I cannot open it!!!
Makes no difference in my case
Didn't worekdt for me 😭😭hiw bad
Thanksssss
Not worked :(
This will have liberals in a hissy
auto subscribe
WHAT TO DO IF WE HAVE WINDOWS 7 VERSION
Get Windows 10
not effective
in the region settings in control panel change the region to US-US
You guys should try to speak slower so we can understand you. It seems you don't even bother to pronounce words you are speaking.
My excel not opening problem, it says having not enough memory, ,,,,,help
Hi i knw might sound crazy but if you change you keyboard setting to English US it wrks in some case...
Default app to use English US as well