Home

Memory error on excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-127024%22%20slang%3D%22en-US%22%3EMemory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127024%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%3C%2FP%3E%3CP%3ERecently%20i%20started%20have%20problem%20with%20the%20copy%20of%20excel%202016%20installed%20on%20my%20pc.%26nbsp%3B%3C%2FP%3E%3CP%3EEvery%20time%20i%20try%20to%20open%20a%20file%20o%20create%20a%20new%20one%20the%20program%26nbsp%3Bgive%20me%20this%20error%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24010i5B7818C84E6E1F6B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22excelerror%22%20title%3D%22excelerror%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20tried%20to%20un-check%20the%20security%20option%2C%20update%20the%20program%2C%20delete%20the%20temp%20file%2C%20turn%20off%20the%20antivirus%20and%20reinstall%20the%2064%20bit%20version%2C%20but%20nothing%20worked.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUseless%20to%20say%20that%20i%20have%20plenty%20of%20memory%20and%20disk%20space%20available%20for%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-127024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecrash%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ememory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291536%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291536%22%20slang%3D%22en-US%22%3Ealso%2C%20fix%20the%20same%20issue%20in%20Excel%202016%3CBR%20%2F%3Ethanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210892%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210892%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%202013%20-%20File%20-%20Options%20-%20Trust%20Center%20-%20Trust%20Center%20Settings(bottom%20right)%20-%20Protected%20View%20-%20UNcheck%20all%20three%20settings%20-%20Click%20OK%20-%20Restart%20Excel.%20You%20might%20be%20able%20to%20get%20it%20to%20work%20by%20unchecking%20one%20and%20testing%2C%20up%20to%20you.%3C%2FP%3E%3CP%3EThis%20worked%20for%20me%20where%20no%20registry%2C%20or%20any%20other%20function%20worked.%20I%20wish%20Microsoft%20would%20just%20have%20the%20program%20tell%20you%2C%20'this%20document%20blocked%20by%20Protected%20View'%2C%20but%20I%20guess%20that%20would%20just%20be%20too%20simple.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127043%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127043%22%20slang%3D%22en-US%22%3E%3CP%3EI%26nbsp%3Btried%20several%20different%20files%2C%20but%20the%20problem%20persisted.%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20on%20excel%20online%20the%20file%20is%20correctly%20handled.%3C%2FP%3E%3CP%3EPlus%2C%20i%20have%20the%20same%20%22memory%20error%22%20even%20if%20i%20try%20to%20create%20a%20new%20file%20in%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20pretty%20much%20baffled%20about%20this%20error.%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20this%20point%20i%20think%20is%20something%20on%20the%20windows%20registry%20side%2C%20but%20dunno%20what%20to%20do.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127041%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127041%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20may%20be%20corrupted!%3C%2FP%3E%3CP%3ERead%20this%20support%20article%20to%20learn%20how%20to%20repair%20it%2C%20and%20how%20to%20recover%20data%20from%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FRepair-a-corrupted-workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERepair%20a%20corrupted%20workbook%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127039%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127039%22%20slang%3D%22en-US%22%3E%3CP%3Ehi!%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20help%2C%20but%20i%20already%26nbsp%3Btried%20that.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20files%20are%20in%20.CSV%2C%20so%20they%20are%20unblocked%20by%20default.%3C%2FP%3E%3CP%3EI%20tried%20to%20change%20the%20format%20as%20told%20in%20the%20guide%2C%20but%20if%20i%20try%20to%20open%20them%20i%20receive%20the%20error%20or%20just%20an%20empty%20excel%20window%20(not%20even%20the%20blank%20work%20page).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-127035%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-127035%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20google%20it%20for%20you%2C%20and%20I%20found%20this%26nbsp%3Blink%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2013_release-excel%2Fmicrosoft-excel-cannot-open-or-save-any-more%2F961a153e-6c68-4b22-b896-94601a28d7e2%3Fauth%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Excel%20cannot%20open%20or%20save%20any%20more%20documents%20because%20there%20is%20not%20enough%20available%20memory%20or%20disk%20space.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%26nbsp%3Bhope%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-564204%22%20slang%3D%22en-US%22%3ERe%3A%20Memory%20error%20on%20excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564204%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
Highlighted
valerio laghi
New Contributor

Hi all!

Recently i started have problem with the copy of excel 2016 installed on my pc. 

Every time i try to open a file o create a new one the program give me this error:excelerror

I tried to un-check the security option, update the program, delete the temp file, turn off the antivirus and reinstall the 64 bit version, but nothing worked. 

 

Useless to say that i have plenty of memory and disk space available for excel. 

I need help.

 

thanks for the help!

7 Replies

Hi,

 

I google it for you, and I found this link:

Microsoft Excel cannot open or save any more documents because there is not enough available memory ...

 

I hope this helps!

hi!

Thank you for the help, but i already tried that. 

My files are in .CSV, so they are unblocked by default.

I tried to change the format as told in the guide, but if i try to open them i receive the error or just an empty excel window (not even the blank work page).

Hi,

 

The file may be corrupted!

Read this support article to learn how to repair it, and how to recover data from it:

Repair a corrupted workbook

I tried several different files, but the problem persisted. 

Even on excel online the file is correctly handled.

Plus, i have the same "memory error" even if i try to create a new file in excel. 

 

I'm pretty much baffled about this error. 

At this point i think is something on the windows registry side, but dunno what to do. 

Excel 2013 - File - Options - Trust Center - Trust Center Settings(bottom right) - Protected View - UNcheck all three settings - Click OK - Restart Excel. You might be able to get it to work by unchecking one and testing, up to you.

This worked for me where no registry, or any other function worked. I wish Microsoft would just have the program tell you, 'this document blocked by Protected View', but I guess that would just be too simple.

also, fix the same issue in Excel 2016
thanks
Thank you!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies