Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-04-13
7
Medium Priority
?
293 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
  • 3
  • 2
5 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

783 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