?
Solved

Excel cannot complete this task with available resources when opening 2 spreadsheets

Posted on 2012-04-13
7
Medium Priority
?
291 Views
Last Modified: 2013-07-23
This issue hapens randomly, using different spreadsheets that usually open together, when the user tries to open a 2nd spreadsheet with one already open she gets the following error:

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

Ive checked all issues listed on http://support.microsoft.com/kb/2655178/ and the issue still occurs. The problem is that it isnt repeatable as if we close down Excel and then re-open it the end user is able to open the same combination of 2 spreadsheets which they were unable to before closing and re-starting Excel.

Excel version 2010 running on Windows 7 pro.

Any assitance would be appreciated.
0
Comment
Question by:markkindred
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 37844478
Hi, markkindred.

It would be ideal if you could post the two files here. You will probably have to redact them, but if so please make sure that the error does still (intermittently!) happen.

BTW, have you tried the two files on a different PC?

Thanks,
Brian.
0
 

Author Comment

by:markkindred
ID: 37855492
Hi Brian,
I can ask the client for the 2x files but am not sure if this will help as the client has advised that its not the same 2x files that cause the issue. It happens with different files and at different times.

No other computers are reporting this issue and other users are all accessign the same directory of spreadsheets so i think the issue is more computer than server based.

If uploading the 2x spreadsheets in question will help please let me know and i'll see what i can arrange.

Cheers, Mark.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37856493
markkindred,

Thanks for the update. Of course it's nothing as simple as the same two files! Oh well, we'll just have to work with what we've got. Please see the steps below for the user to carry out the next time the problem occurs...

In the meantime, a few questions please...
(A) Do other users work on these files as well? If so, do they have the same problems?
(B) Any significant recent change to the user's PC and/or S/W?
(C) Very roughly, how often does this happen to the user - hourly, daily, weekly?
(D) Do I understand you correctly that the problem also happens in Safe Mode?

(1) Save a screen shot of the Performance tab of Task Manager while the error is still displayed.
(2) IIRC, by continually clicking "OK" ("Continue"?, "Yes"?) you can eventually get rid of the message. At this point, save another screen shot of the Performance tab of Task Manager.
(3) Load the attached file and click on the "List Open WorkBooks, Add-Ins, etc." button.
(4) Save List_Open_WorkBooks_Add-Ins_etc.xls. (It's OK to overwrite the original version.)
(5) Save the "two files" - renaming them by adding "Work" to the file name.
(6) Post the two screen captures and three files here.

Thanks,
Brian.
0
 

Author Comment

by:markkindred
ID: 37916555
Hi Brian,
Thanks for the update:

(A) Do other users work on these files as well? If so, do they have the same problems?
> Yes and no they dont have the same problems.
(B) Any significant recent change to the user's PC and/or S/W?
> No
(C) Very roughly, how often does this happen to the user - hourly, daily, weekly?
> Monthly(ish) but its the FD's laptop so even annually is a big deal.
(D) Do I understand you correctly that the problem also happens in Safe Mode?
> Not sure as the only way to test this would be for the FD to use safe mode over a couple of months to see if the issue happens again, this isnt an option im afraid.

(1) Save a screen shot of the Performance tab of Task Manager while the error is still displayed.
> Will do, next time it happens.
(2) IIRC, by continually clicking "OK" ("Continue"?, "Yes"?) you can eventually get rid of the message. At this point, save another screen shot of the Performance tab of Task Manager.
> Will do, next time it happens.
(3) Load the attached file and click on the "List Open WorkBooks, Add-Ins, etc." button.
> Sorry, where do i open the attached file from?
(4) Save List_Open_WorkBooks_Add-Ins_etc.xls. (It's OK to overwrite the original version.)
> will do when i can download the file
(5) Save the "two files" - renaming them by adding "Work" to the file name.
> will do when i can download the file
(6) Post the two screen captures and three files here.
> will do when i can download the file

Many thanks for your help.
0
 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 37917349
Mark,

Thanks for the info!

Oh dear - a very intermittent problem that only happens to a very significant user.

If I were in your position I'd make a judgement call based on my knowledge of the FD's personality and do one of the following...
(1) Re-image his/her PC - at the very least uninstall and reinstall Office.
(2) Explain the issues with intermittent problems, talk him through steps 1 to 5 of my previous post and leave him with a copy of the checklist for the next time. (Despite my advanced years, I'm still a hopeless optimist and a believer in common sense. <sigh>)

"Sorry, where do i open the attached file from?"
Apologies, please see attached. This is worth doing at any time on both the FD's and a "successful" user's screen in case there's something funny about the FD's Excel set-up.

Regards,
Brian.List-Open-WorkBooks-Add-Ins-etc.xls
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question