Excel 2010 Errors Regarding Memory and Resources

Hello,

I have a user with an Excel 2010 issue.  The laptop is brand new HP laptop with Windows 7 Professional, i5 Processor and 8GB of memory.  The user has been receiving errors regarding memory and available resources while using Excel.  The errors are random when they occur, user could have one Excel spreadsheet open or mulitiple open.  Not always the same open file either.  

The error is usually

Excel cannot complete this task with available resources. Choose less data or close other applications.'  or

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

Or sometimes one followed by the next.

We have updated Office to the lateset SP, Repaired Office, Removed Temp Files in Excel Files, as well as Setting Some Permissions (which I cannot find the Document again, that Explains what I did but if someone mentions it, it will come back to me, sorry)

Any help would be apprecited, my user is completely frustrated at this issue.
LVL 1
JazzanlexAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
Your client is not the only one with this problem. It has happened to enough people that Microsoft issued a couple of troubleshooting guides:
How to Troubleshooting Available Resources errors in Excel
Excel cannot complete this task with available resources error, Excel 2010

Some people have reported success by uninstalling Windows Live Essentials and Microsoft Outlook Social Connector for Live Messenger.

For others, the trick was the turning off the preview pane in Windows Explorer. The messages in these cases occurred after you attached an Excel sheet in Outlook or opened the file directly from Windows Explorer.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JazzanlexAuthor Commented:
I will have the user try these solutions.  Post back shortly.
0
JazzanlexAuthor Commented:
Thank you
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

JazzanlexAuthor Commented:
I have had the user uninstall Windows live essentials Outlook social connector was not in add remove programs users still having the issue.  Having her test opening excel files with in Excel instead of using windows explorer will post back soon.  Sorry took so long to respond I was on vacation for a week.
0
JazzanlexAuthor Commented:
Hi guys just getting back to you the user has tried opening Excel files within Excel instead of using Explorer and the problem still persists anybody else have any idea what I can do to solve this issue.  Any help is greatly appreciated the user is getting extremely frustrated this is a brand-new laptop.
0
superjohnbarnesCommented:
I am having the same issue.  Only seems to be happening on a share though.  When I copy excel files to the local desktop it works fine.

I changed the permissions on the users to domain admin (sledgehammer to a nut) and the user can now open the excel files.  (I have since altered permissions) user is on a new HP elitebook and server is MS server 2008
0
JazzanlexAuthor Commented:
This user is on a standalone laptop, workgroup no domain.  She is an admin , any other thoughts?
0
superjohnbarnesCommented:
Can you try coping the documents and opening them from a few different locations to rule out the permissions issue.  Maybe setup a temp folder on the root of C and give full permissions to the user?
0
JazzanlexAuthor Commented:
Thanks for the info Superjohnbarnes, but I just spoke with my user and it seems since we turned off the Preview Pane in Excel last week, the user has not experienced any of the error messages since that time.  Considering she was getting them everyday, I am pretty sure this is the fix that solved the issue for us!!  

Thank you for your help in this matter, I will be awarding byundt the points as his solution of the preview pane has seemed to solve the issue.  The link to the followin website and following step number 4 did the trick it seems.  

http://support.microsoft.com/kb/2779852

**Note that the Outlook and Explorer Preview Pane in Step 4 were not enabled for my client but the Excel one was and unchecking it has stopped the errors. **

Thanks again and sorry it took so long for the responses, I was emailing back and forth to my client to try some solutions, as I am not at her laptop everyday!!
0
JazzanlexAuthor Commented:
I awarded no points to myself, but just wanted to give the specific direction to anyone else who my come across this issue
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.