ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel cannot complete this task with available resoucres (https://www.excelbanter.com/excel-discussion-misc-queries/105413-excel-cannot-complete-task-available-resoucres.html)

deathguy

Excel cannot complete this task with available resoucres
 

Hi,

Anyone have this issues, I am flighting with this issue for 2 days and
I can't find any solution. I am using Office 10 with SP3 and OS XP.

I tried to opend 7 or 9 linked Excel files (2 Mb each - I have 1 Gb
RAM) and error shows up after fifth files is opened. After that Excel
freeze and it consume all CPU time.

Please help me ?


--
deathguy
------------------------------------------------------------------------
deathguy's Profile: http://www.excelforum.com/member.php...o&userid=37626
View this thread: http://www.excelforum.com/showthread...hreadid=572434


Alan

Excel cannot complete this task with available resoucres
 
I'm not sure if this is the problem you're experiencing, but files will not
link and will give the error message you describe if you have more than
about 16,000 rows linking to another file, (I'm not sure of the exact
number). The size of the file isnt relevant to this as far as I know,
Rgards,
Alan.
"deathguy" wrote in
message ...

Hi,

Anyone have this issues, I am flighting with this issue for 2 days and
I can't find any solution. I am using Office 10 with SP3 and OS XP.

I tried to opend 7 or 9 linked Excel files (2 Mb each - I have 1 Gb
RAM) and error shows up after fifth files is opened. After that Excel
freeze and it consume all CPU time.

Please help me ?


--
deathguy
------------------------------------------------------------------------
deathguy's Profile:
http://www.excelforum.com/member.php...o&userid=37626
View this thread: http://www.excelforum.com/showthread...hreadid=572434





All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com