Solved

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

Posted on 2012-04-13
7
283 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now