ExcelBanter - View Single Post - Bypassing the 128MB formula memory limitation in 2002?

wrote...
I have several users that need to open 5 different spreadsheets, all
linked to each other, but keep encountering the "Excel cannot complete
this task with available resources. Choose less data or close other
apps."

My research has indicated this is due to the built in limitation of
128MB for formula memory in Excel 2002.

Unfortunately, using Excel 2003 is out of the question due to a third
party app conflict (the 3rd part app is necessary and does not function
in Excel 2003). Naturally Excel 2003 testing has shown no issue in
opening all 5 spreadsheets at the same time.

I have tried opening multiple instances of Excel 2002 and this does
bypass the 128MB limitation as that is on a per instance basis, but the
links no longer function.

Either get the maker of the 3rd party app to upgrade to support Excel
2003, or get your users to redesign their system. There's absolutely no
way around limitations like this in Excel.

Redesign would be far & away the better course. If your users are
really pushing the 128MB limit, they're begging for trouble whether or
not they upgrade to Excel 2003. While Excel can (barely) cope with that
many formulas, it's unwise to built models larger than 1/4 this size.