Excel cannot complete this task with availible resources

SACoull

unread,

Oct 26, 2009, 11:15:01 AM10/26/09

to

Hello,

I have a client with Office 2007 SP2 who is having a problem with Excel
2007. Whenever you try to do a copy and paste or block copy it pops up the
following error message:

"Excel cannot complete this task with availible resources. Choose less data
or close other applications" with an "OK" button the only choice.

The computer is dual core machine with 2Gb of memory (1.2Gb free) when the
error message is displayed and plenty of disk space.

The spredsheets are not big - 30 rows and 5 columns and there are no macros
- something I have seen when re-searching the problem.

The only other thing so far I have identified is that it only seems to occur
when the file is opened up and edited directly on the network share drive,
when the file is copied to a local drive/desktop and opened and edited there
the problem does not seem to occur - but this could be coincidence.

Any help would be appreciated.

Stephen.

steven du

unread,

Oct 27, 2009, 2:12:38 AM10/27/09

to

Dear Stephen,

Please check whether the following articles are helpful or not:

Error message when you try to ungroup a group in a PivotTable in Excel
2007: "Excel cannot complete this task with available resources"
http://support.microsoft.com/kb/928982

Error message when you open a workbook that contains cells that you filled
with a reference to a relative name in Excel 2007: "Excel cannot complete
this task with available resources"
http://support.microsoft.com/kb/928976

If the issue cannot be reproduced on the local hard drive, please change to
another network shared folder and check whether the issue can be reproduced
or not.

In addition, please check whether Windows Desktop Search is installed on
both server and client sides.

Have a nice day.

Regards,

Steven Du

Microsoft Online Support
Microsoft Global Technical Support Center

====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

steven du

unread,

Oct 30, 2009, 6:16:37 AM10/30/09

to

Hello Stephen,

How are you?

We have not heard from you regarding this issue. Please post back here at
your convenience so that we can assist further.

Sincerely,

Steven Du
Microsoft Online Partner Support

--------------------

SACoull

unread,

Nov 4, 2009, 6:06:01 AM11/4/09

to

Hi Steven,

Thank you for the reply, I have looked at both of the knowledge base
articles but neither apply there is no pivot tables and no relative names in
the worksheet.

We have been monitoring the problem and it hasn't happened again I suspect
that that it had something to do with the file server network connection

Thanks for your help though.

Stephen.

""steven du"" wrote:

> .
>

steven du

unread,

Nov 4, 2009, 11:43:17 PM11/4/09

to

Hello Stephen,

I understand that the issue does not occur again.

If you encounter any new break/fix issue, please feel free to post your
questions in the newsgroups.

We are glad to be of assistance.

Best regards,

Steven Du
Microsoft Online Support