Excel - Not enough memory ?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

kabe

Thread Starter
Joined
Jun 7, 1999
Messages
25
I'm loading a 60Mb workbook and receiving the Excel message "Not enough memory". I presume this is due to a limit within Excel as I have more than 750Mb of memory.

The workbook does load, but is very slow to update. Is there any way I can tweak Excel, or W2000 so that more memory is available.

A gif of my System Info is attached.

Keith
 

Attachments

Joined
Jun 26, 2000
Messages
7,762
It could be a number of things depending on what is contained within the spreadsheet, but the most common reason for this is that you have your Paging File set too low.

That would not seem to tbe the case with 2 GB allotted on your machine.

Can you provide more info about the workbook? Does it contain pivottables, graphs, array formulas? anything more?
 

kabe

Thread Starter
Joined
Jun 7, 1999
Messages
25
Thank you for the offer of help Randy.

There are no pivot tables, graphs or array formulas.

There are 52 pages, most containing 1000 rows and several of them have columns populated out to "GC".

The pages contain either raw data or calculations - all of which are summarized on the first sheet.

Some of the data is updated in real time from the internet (stock prices), but the problem arises even when auto-recalculation is off.

Hope this proves helpful.

Keith
 
Joined
Jun 26, 2000
Messages
7,762
Well, this article covers copying formulas over large areas, but it also states
Each instance of Excel is limited to 64 megabytes (MB) of memory (internal heap space). Each instance is also limited to 32,760 source cells when you perform a smart fill operation. When you copy or fill large sections of a worksheet, one or both of these limitations may affect the result.
I'm thinking you may just be at the upper limit for a workbook.
 
Joined
Jul 21, 2003
Messages
186
Dear Kabe,
You are not alone in finding memory short on Excel, despite more than generous system components.
I didn't check your operating system but in the help menu you should expect to find the opportunity to review memory usage on screen, while operating within a program.
I take it that you are defragmenting your hard disk often enough and are aware that defragmentation does not resolve the page file. There is a no charge program available on the net "Page Defrag" which resolves this problem. One of the options is to defragment the page file on every boot.
There are other reasons for memory to be shown as short on in Excel so this is not to diminish the advise you are already receiving.
Please disregard if you are already aware of the above. It's just that I have a habit of asking stupid questions and expect that other people do too!!!
Regards Guy.
 

kabe

Thread Starter
Joined
Jun 7, 1999
Messages
25
Thanks guys for all your suggestions, but I still have the problem and assume that this monster spreadsheet is up against the stops.

Someone suggested that Excel 2002 may solve the problem so I'm going down that route.

Keith
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top