• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

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

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
markkindred
Asked:
markkindred
  • 3
  • 2
1 Solution
 
redmondbCommented:
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
 
markkindredAuthor Commented:
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
 
redmondbCommented:
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
 
markkindredAuthor Commented:
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
 
redmondbCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now