Solved

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

Posted on 2012-04-13
7
285 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
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 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
.Range Set 25 75
Excel cell formatting 5 27
Excel Need to return the text of a filter column 11 20
Excel calculate based on 'x' in column 2 22
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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