Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / August 2003

Tip: Looking for answers? Try searching our database.

Large Excel Files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Randy S - 17 Aug 2003 15:47 GMT
I recently upgraded my physical memory to 1GB from 500MB
because I have a few large Excel files I deal with where I
get "Not Enough Memory" errors and "Out of System
Resource" errors. I really haven't noticed a decrease in
these errors ... is there some other setup I need to
perform to "tell" Excel I have more memory than it's
using? I notice in Task Manager that Excel is using 290Mb
of memory when these errors occur - with 500Mb available.
Why isn't it using all the memory available?
David McRitchie - 17 Aug 2003 19:38 GMT
Hi Randy,
Operating systems is important as well as your version of Excel.

It is unlikely that you are out of memory because you don't have enough
physical memory,  as   you should be using virtual memory.

Though do check the space on your harddrive.    Best to set the
virtual memory up high as you would need while running
to start with.  Microsoft is not very good at handling conflicts.

But the memory may be graphical memory
that Excel has limits in.   I expect that you are not running on an
WinNT (2000, 2002)  system..

Take a look at my web page
  Slow Response and Memory Problems
   http://www.mvps.org/dmcritchie/excel/slowresp.htm

There are a lot of things to look for.
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> I recently upgraded my physical memory to 1GB from 500MB
> because I have a few large Excel files I deal with where I
[quoted text clipped - 5 lines]
> of memory when these errors occur - with 500Mb available.
> Why isn't it using all the memory available?
BrianB - 18 Aug 2003 09:17 GMT
I was under the impression that Windows had problems using memory
above 512 megabytes, and those with more had to limit the usage to
that amount.

Regards
BrianB
=============================================

> I recently upgraded my physical memory to 1GB from 500MB
> because I have a few large Excel files I deal with where I
[quoted text clipped - 5 lines]
> of memory when these errors occur - with 500Mb available.
> Why isn't it using all the memory available?
dre - 21 Aug 2003 15:56 GMT
>-----Original Message-----
>I recently upgraded my physical memory to 1GB from 500MB
[quoted text clipped - 7 lines]
>Why isn't it using all the memory available?
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.