How do I optimize system settings to support Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ktpinegar - 22 Jun 2007 16:41 GMT

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.

Reply to this Message

Nick Hodge - 23 Jun 2007 13:08 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

>I have a large spreadsheet with links to other large spreadsheets and I
>keep
[quoted text clipped - 7 lines]
> the
> same spreadsheet.

Reply to this Message