[mso] Re: Possilby OT: Virtual memory & Excel
- From: Wilson Baptista Junior <wilson@xxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 01 May 2004 13:27:19 -0300
Hi Robert,
with 2 GB of RAM, you shouldn't have any problems with swap files, as long
as you have sufficient free space on your hard drive, clear out your temp
files regularly and defragment regularly.
AFAIK Excel doesn't recommend swap file sizing by itself; Microsoft used to
recommend one and a half times to two times your RAM size, but this was
back in the times when 128MB was a lot of memory.
With 2 GB of RAM, you could set your swap file size (look in Control
Panel--> System-->Advanced-->Performance-->Virtual Memory) to 1 or 2 GB
(both maximum and minimum size) and that should be more than enough.
If you have more than one hard drive (physical hard drives, not
partitions), put the swap file on the fastest one; if both are the same
speed, put it on the one which doesn't have Windows installed.
Wilson
At 11:44 1/5/2004, Robert Carneal wrote:
>Lately, while working with names in genealogy and using Excel to try to
>bring some sort of organization to them, I am getting the message:
>
>Not Responding.
>
>I have a Pent IV, and -almost- 2gig of memory. So I decided that I had
>enough memory, it my memory was not the cause. Still it happened only in
>Excel, but not Lotus when I used the same data. The data was 32,780 rows
>deep, and occupied columns A thru K, with date formulas in in columns AA
>thru AF. So I was trying to sort the range A1 to AF32780. Surely that is
>not beyond Excel's capabilities normally?
>
>After looking on the Internet for information on swap files and Excel, I
>found one that mentioned getting Excel to recommend minimum and maximum
>size swap files for you so you can set it. I have poured over Excel looking
>for this, but if it is there, I cannot find it. Can you get Excel to
>suggest min/max allocations for swap files, and if you can, please how??
>
>Thank you.
>
>Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
