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
Highlighted

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!

Highlighted

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).

Highlighted

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

Highlighted

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. 

Highlighted

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.

Highlighted
also, fix the same issue in Excel 2016
thanks
Thank you!
Related Conversations
Excel on iPad
Mattlewis in Excel on
2 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
9 Replies
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
2 Replies