Five spreadsheets, collective size around 150 MB. Knee deep in formulas,
functions and figures. All five workbooks are linked to each other, thus it
is necessary to open them all at one time. Unfortunately, this isnt
possible. Each time the fifth sheet is opened, you receive the following
error:

"Excel cannot complete this task with available resources. Choose less data
or close other apps."

On Fri, 14 Oct 2005 08:40:14 -0700, "Mike Gallof"
wrote:

Five spreadsheets, collective size around 150 MB. Knee deep in formulas,
functions and figures. All five workbooks are linked to each other, thus it
is necessary to open them all at one time. Unfortunately, this isn’t
possible. Each time the fifth sheet is opened, you receive the following
error:

"Excel cannot complete this task with available resources. Choose less data
or close other apps."



Sounds like it's time to get more memory.

But why is it necessary to have them open if formulae are linked -
unless of course you're wanting to change data in all of them?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________