Excel Error Message

[Guest]

By default, this looks like the best excel place for this question.

I get the error message:
"Excel cannot complete this task with available resources. Choose less data
or close other applications.",

and the follow-up message of

"Unable to save external link values"

The error message relates to two workbooks:
The 1st workbook stores data.
The 2nd workbook references the data via vlookup or match-index functions.

When I trim down the data in the 1st workbook to a half its size. The error
messages go away, but of course needed data is lost.

Also if I make one workbook out of two (combining the data and referencing
workbooks), the message goes away, but the design is less desirable.

Is the problem with my machine capcity, or limits within Excel? Any light
will be much appreciated.

Thank you,
Mark

 

[Guest]

hi,
i would suspect maching capcity before i would suspect
excel. how much memory do you have.
at the dos prompt type mem.
how much memeory is excell using
in blanks cell on some sheet type
=info("totmem")
=info("memused")
=info("memavail")
this will vary as you use excel. what them as you work.

 

[Guest]

Mr. Anonymous:

Here you go:

"mem" produced the following:
655360 bytes total conventional memory
655360 bytes available to MS-DOS
598048 largest executable program size

1048576 bytes total contiguous extended memory
0 bytes available contiguous extended memory
941056 bytes available XMS memory
ms-dos resident in high memory area

And
=info("totmem") produced 23,186,936
=info("memused") produced 22,138,360
=info("memavail") produced 1,048,576

 

[Guest]

Hi Mark

Did you ever get your question answered about the 'cannot complete with
available resources'? I have the same problem and cannot locate an answer
anywhere.