Excel cannot complete this task with availible resources


S

SACoull

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.
 
Ad

Advertisements

S

steven du

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.


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

| From: =?Utf-8?B?U0FDb3VsbA==?= <[email protected]>
| Subject: Excel cannot complete this task with availible resources
| Date: Mon, 26 Oct 2009 08:15:01 -0700

|
| 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.
|
 
S

steven du

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


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

| From: (e-mail address removed) ("steven du")
| Organization: Microsoft
| Date: Tue, 27 Oct 2009 06:12:38 GMT
| Subject: RE: Excel cannot complete this task with availible resources

|
|
| 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.
|
|
| --------------------
|
| | From: =?Utf-8?B?U0FDb3VsbA==?= <[email protected]>
| | Subject: Excel cannot complete this task with availible resources
| | Date: Mon, 26 Oct 2009 08:15:01 -0700
|
| |
| | 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.
| |
|
|
 
S

SACoull

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.
 
Ad

Advertisements

S

steven du

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


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

| From: =?Utf-8?B?U0FDb3VsbA==?= <[email protected]>
| Subject: RE: Excel cannot complete this task with availible resources
| Date: Wed, 4 Nov 2009 03:06:01 -0800

|
| 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:
|
| >
| > 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
| >
| >
| > --------------------
| >
| > | From: (e-mail address removed) ("steven du")
| > | Organization: Microsoft
| > | Date: Tue, 27 Oct 2009 06:12:38 GMT
| > | Subject: RE: Excel cannot complete this task with availible resources
| >
| > |
| > |
| > | 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.
| > |
| > |
| > | --------------------
| > |
| > | | From: =?Utf-8?B?U0FDb3VsbA==?= <[email protected]>
| > | | Subject: Excel cannot complete this task with availible resources
| > | | Date: Mon, 26 Oct 2009 08:15:01 -0700
| > |
| > | |
| > | | 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.
| > | |
| > |
| > |
| >
| > .
| >
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top