Thread: Out of Memory
View Single Post
  #1   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default Out of Memory

As a spreadsheet grows, I'm beginning to have occasional "Out of Memory"
problems while doing "Paste" operations. Grumble, grumble....

Digging into the problem a bit, I find the INFO statement tells me that
I have roughly 50MB available to Excel and that most of it is used up.

My question is simply whether there's anything that I can do to increase
that 50MB gross amount before I tinker with how Excel is actually using
it in the spreadsheet?

1) Would it make any difference if I changed from Excel97 to the current
version? Or does the same 50MB limit exist there still?

2) Or is there anything within my XP operating system I can do to make
it provide more space for Excel's use?

3) The hardware has 724MB of RAM and a huge amount of disk space open so
I presume there is nothing with the hardware that can ease the problem?

Thanks...

Bill