Bill Martin -- (Remove NOSPAM from address)
Guest
Out of Memory:Would it make any difference if I changed from Excel97 to the current v
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
Bookmarks