Hi, i met a problem with the excel. Sometimes when i need to save the excel documents, excel will prompt an error saying there is not enough memory. I am having trouble when I want to open Excel because of this: “Not enough memory to run Microsoft office Excel please close other application and try again.
Thanks for letting me join. I was working on a Word doc (Word 2003, Win XP, older computer with 12 GB free on its 80 GD HDD, 2 GB of RAM). I was pasting a number of images into the document, when it stopped responding to my keyboard. I could use the mouse to place the cursor, but could not add text, delete, backspace, etc. I closed everything down and rebooted.
Now when I try to open the doc, I get a message in the lower left corner of the screen that 'Word is converting my filename,' and when the progress bar gets to the end, I get an error message that 'There is not enough memory or disk space to complete the operation.' The file is about 500kb so I don't think that is literally the reason; I think the file got corrupted somehow. I have tried opening it in OpenOffice, Wordpad, Notepad, and a few other editors to no avail, and I have tried 'Open and Repair' with the same result. I suspect I am doomed and will have to create the doc again from scratch, but I hoped someone might have a brilliant suggestion. Thank you in advance.
It may not necessarily be our document, but something else. I would run a CHKDSK on your hard drive (Open a command window: Start RUN CMD (press Enter), type CHKDSK C: /F and press Enter. If you are running on an NTFS files system it will tell you it will run at next reboot. Then reboot.) Once that's completed, make sure your system is cleaned of temp files. Use a utility like CCleaner - available for free from www.piriform.com and run it. Once those steps are done, try again to see if you can recover your document. Yes, it may be the file truly is just corrupt.
However, the conclusion that the hard disk needs to be replaced is premature. There are many things that might cause a bit, byte or even a sector to be written incorrectly. Throwing out the baby with the bathwater is an inefficient waste of time and money. And, the use of utilities that remove temporary files from one's system have shown time and again to not only free up disk space, but to clear up many problems that users might encounter while operating application in a Windows environment. And that's usually good advice, Stefan.
However, CHKDSK does more than check a disk for damaged sectors. It also checks file indexes among other things, and problems such as a bad write to the disk that fail a CRC check (or whatever method of verification the system uses). Indexes get messed up all the time, especially in a Windows environment, and running CHKDSK will allow the system to verify those indexes and rebuild them as necessary. As much as we'd like our computers to be infallible, they simply are not. A sudden power off or hiccup or an ill-timed whack on the side of the system case can cause problems. According to Microsoft: ' CHKDSK examines disk space and disk use for the file allocation table (FAT) and NTFS file systems. CHKDSK provides information specific to each file system in a status report.
The status report shows errors found in the file system. If you run CHKDSK without the /f command-line option on an active partition, it might report spurious errors because it cannot lock the drive.
You should use CHKDSK occasionally on each disk to check for errors.' (Emphasis is mine.) I've had the good fortune of working with MS-DOS since version 2.0 and Windows since version 1.0 and CHKDSK has saved me from many a problem, especially on systems that have had the operating system installed for more than a year. The longer the span of time an operating system is run without being reloaded from scratch, the greater your chances of problems occurring. I appreciate your comments.
Problem: User gets 'Microsoft excel cannot open or save any more documents because there is not enough available memory or disk space' Disk space is fine, RAM is at 3GB used (8GB total on machine) What I've tried: 1. Running dcomcnfg and setting identity table as 'interactive user' 2. “C: Windows SysWOW64 config systemprofile desktop” folder must also exist and you need Full Control permissions to the “systemprofile” and “desktop” 3. GIving IIS apppool ASP.NET permissions for dcomcnfg stuff (No appool doesn't apply on this machine) 4. Properties General Unblock on file in file explorer - Right Click - Properties of Excel File - Client on Unblock 5. HKEYCURRENTUSER Software Microsoft Windows CurrentVersion Explorer User Shell Folders Cache Changed key Cache to something like C: Windows Temp 6.
Cleaned out C: users appdata local temp files and windows temp. Disabled COM Add-ins in excel 8. Disabled Microsoft protected view in excel AFTER ALL OF THAT. the user is still experiencing the issue except with a slight different error message that suggests the same error. Message: 'Excel cannot complete this task with available resources. Choose less data or close other applications' SpiceWorks Any ideas!!? Really stumped here need some halp.
Here is my advise - Taken from the KB you posted. Method 1: Contents of the spreadsheet Can you create and save a blank excel workbook? (If so maybe there is something wrong with data in that excel spreadsheet. Method 2: Verify/install the latest updates: Are you running the latest version of Office 2013?
(If not, try running the updates and see if you problem is resolved) - Method 3: Add-ins interfering: Is your user running any add-ins? (If so, disable them and see if you problem is resolved.) - Method 4: Test disabling Preview/Details Pane in Windows 7: According to the article disabling preview/details panes could resolve your issue. (Check the article for what to disable and how.) - Method 5: Test a different Default Printer: According to the article changing your default printer could resolve your issue. (Try changing it to one of the document writers - E.g Cute PDF or Microsoft XPS Document Writer) - Method 6: Test without Antivirus: I would advise caution with this method. (Make sure you machine is not plugged into your network when you disable AV protection - Try opening a local copy of the file and see if the problem persists.) - Method 7: Test with 64 bit version of Excel: As the method says try with a 64bit excel if you are not already using it. Method 8: Other applications are consuming the computer's memory and not enough is being allocated to Excel: Open up your task manager and kill of any programs that should not be running. (Highly doubt this is the cause judging by the specs you listed.) - Best of luck to you.
Hope you come right. (If you solve issue, please post your fix.). We have the same problem with a remote user. It occurs only when they're trying to open an Excel spreadsheet from either an Outlook attachment, or from a network share. We've been told it's due to him not having the correct permissions for where his temporary files are saved (when we checked this was on the server, we've altered this to his local drive and touch wood it appears to have cured the problem).
We're not sure this is the solution though as he only works from home on average once a week and I don't think he's been working from home since. Tradewalker wrote: We have the same problem with a remote user. It occurs only when they're trying to open an Excel spreadsheet from either an Outlook attachment, or from a network share. We've been told it's due to him not having the correct permissions for where his temporary files are saved (when we checked this was on the server, we've altered this to his local drive and touch wood it appears to have cured the problem). We're not sure this is the solution though as he only works from home on average once a week and I don't think he's been working from home since.That would make perfect sense if they got that error opening an excel doc on a network drive which they only have read access to. Sigkill wrote:.
Is the user trying to open/save from the local machine, external drive, or a network drive?. Can you replicate the issue with another user on the same computer? If not, their account problem doesn't have correct permissions. In this case, fix their permissions or backup their profile, delete it, and create a new one.
If the issue only occurs on that machine, update office. If that doesn't work, try doing a repair on office The Excel files are being opened from various sources. Local machine, Fileshare over network, and from outlook attachments (which are downloaded to local machine) Not an external drive. I can't replicate the issue at all.
![Excel not enough resources error Excel not enough resources error](/uploads/1/2/5/5/125529148/857835637.png)
When the user is working in excel it happens time from time. Restarting excel/computer fixes it temporary. Tradewalker wrote: We have the same problem with a remote user. It occurs only when they're trying to open an Excel spreadsheet from either an Outlook attachment, or from a network share. We've been told it's due to him not having the correct permissions for where his temporary files are saved (when we checked this was on the server, we've altered this to his local drive and touch wood it appears to have cured the problem). We're not sure this is the solution though as he only works from home on average once a week and I don't think he's been working from home since. Interesting, on the file share temporary excel files were stored on the server?
And the user did not have permissions? I've gone to all the user's temporary folders and granted permission.
Patrickmalone wrote: 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. Thanks Patrick This did the trick for me. I had been sent files via skype and went to open them and the error popped up. After changing trust settings it was fixed.
This fixed it for me as well. Downloaded a google docs excel spreadsheet and had the memory message.
Had to go to the trusts and uncheck as described above. Patrickmalone wrote: 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.%uFEFF. Patrickmalone wrote: 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. This worked for me - it was one of the most frustrating things to try and troubleshoot!! Patrickmalone wrote: 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.
Thank you, Patrick Malone! I have been struggling with this issue for days! I tried multiple things, but this fixed it in seconds.