Menu

Bypassing the 128MB formula memory limitation in 2002?

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Harlan Grove

Posts: n/a

Default

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.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF formula?	meris	Excel Worksheet Functions	1	September 6th 05 07:14 AM
writing a formula for a colored value	aaronwexler	New Users to Excel	11	September 1st 05 03:11 PM
revert formula insertion to old method	Don't be a pain in the ass	Setting up and Configuration of Excel	0	January 24th 05 01:49 PM
Formula Result Correct but value in the cell is wrong	jac	Excel Worksheet Functions	2	December 17th 04 08:05 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe.	o0o0o0o	Excel Worksheet Functions	6	November 19th 04 03:13 PM

All times are GMT +1. The time now is 12:53 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement