How do I optimize system settings to support Excel?

[ktpinegar]

I have a large spreadsheet with links to other large spreadsheets and I keep
getting the notice that Excel cannot complete a save with available
resources. It is suggested that I choose less data or close other
applications. Then I get the notice that external links were not saved.
This happens all the time. I have a dual-core PC with 2 Gig of RAM. How can
I optimize my system settings to prevent this? I am even getting a
"selection too large" notice when I try to paste 20 copies of VLOOKUPs in the
same spreadsheet.

 

[Nick Hodge]

Most versions of Excel have a limit on how much of the available memory pool
they can use. You can read about this here

http://www.decisionmodels.com/memlimitsc.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/