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.