Out of memory

Stubby · Apr 2nd, 2002, 05:37 AM

I currently have two workbooks linked together, one of which is about 20mb in size. When I try to update the second workbook I receive an "Out of Memory" message. Can any explain why??

Anne Troy · Apr 2nd, 2002, 06:19 AM

Why would you have/want a 20MB file? Perhaps it is corrupt.

Check this: http://www.thewordexpert.com/excel.h...monExcelIssues
Do the steps under "Cannot shift..." error to clean up empty cells. If that doesn't help, try copying your worksheet(s) to another, new book.

Chris Davison · Apr 2nd, 2002, 12:53 PM

Out of memory, basically, means you're running out of memory.

Your machine has a limited capacity for RAM with which to carry out its functions you are doing.... when it reaches it's capacity, it can switch some of these RAM to your hard drive and keep them in virtual memory until you come to access them again.

You could try upgrading your RAM capacity, or also try freeing up some physical c: drive space (I get nervous if I have less than around 200 megs free) and notice serious performance degredation if it dips below 30 megs

Your filesize may be 20megs (that's pretty big, but by no means a total behemoth) but the functions and calculations it is carrying out may need 100 megs in any given millisecond of processing, so you may be trying to access your hardrive (do you hear lots of "whirring" ?) to compensate.

As Dreamboat suggested, try to slim your file sizes down to relieve your immediate RAM, but also try to free up some C: space.

Deleting MS Word is always a good start

wi_guy · Apr 2nd, 2002, 01:01 PM

LMAO at the MS word comment...well said

Jack in the UK · Apr 2nd, 2002, 01:05 PM

Hi

Easy Chris.. OK i TOTALLY Agree,
Deleting MS Word is always a good start

>> Word ,, i chaeck them in spel checker.. no word on any pc I USE.. I DELETE IT OR refuse TO TOUCH THE pc...... YUUUUCCK!

BOXES FOR ME...

why bother with WORD.. bar one or 2 secrets Excel and do all Word can and a billion times more!

ill have a play buit i want to add and back up on Chris comments.

20MB file.. erm,mmmm

In XP which i now have HORRIBBBBBBBLE it is an all. i can not undrestand .. some 20 months gus have posted with BIG file sizes.. why??? OK you need A B C ////// z in one sheet... I disagree split them in some order Days/ months/ years / projectw what ever.. i have never know anyone i can get my hands that swares in a stack of excel manuals cant split the data....

thisis GOOD GOOD sound advise

Limit 5 - 7 MG MAX... then archive split..

I really do mean thsi Excel is such a good looking girl.. make her life easy and keep her bueatuful else she will gae to quick.... ill look into you post again...

Apr 2nd, 2002, 06:19 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Why would you have/want a 20MB file? Perhaps it is corrupt. Check this: http://www.thewordexpert.com/excel.h...monExcelIssues Do the steps under "Cannot shift..." error to clean up empty cells. If that doesn't help, try copying your worksheet(s) to another, new book. __________________ ~Anne Troy

Apr 2nd, 2002, 01:05 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Easy Chris.. OK i TOTALLY Agree, Deleting MS Word is always a good start >> Word ,, i chaeck them in spel checker.. no word on any pc I USE.. I DELETE IT OR refuse TO TOUCH THE pc...... YUUUUCCK! BOXES FOR ME... why bother with WORD.. bar one or 2 secrets Excel and do all Word can and a billion times more! ill have a play buit i want to add and back up on Chris comments. 20MB file.. erm,mmmm In XP which i now have HORRIBBBBBBBLE it is an all. i can not undrestand .. some 20 months gus have posted with BIG file sizes.. why??? OK you need A B C ////// z in one sheet... I disagree split them in some order Days/ months/ years / projectw what ever.. i have never know anyone i can get my hands that swares in a stack of excel manuals cant split the data.... thisis GOOD GOOD sound advise Limit 5 - 7 MG MAX... then archive split.. I really do mean thsi Excel is such a good looking girl.. make her life easy and keep her bueatuful else she will gae to quick.... ill look into you post again... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 05:37 AM	#1
Stubby Board Regular Join Date: Mar 2002 Location: Lat 51° 23.3 mins North Long 0° 24.7 Mins West Posts: 174	I currently have two workbooks linked together, one of which is about 20mb in size. When I try to update the second workbook I receive an "Out of Memory" message. Can any explain why??

Apr 2nd, 2002, 12:53 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Out of memory, basically, means you're running out of memory. Your machine has a limited capacity for RAM with which to carry out its functions you are doing.... when it reaches it's capacity, it can switch some of these RAM to your hard drive and keep them in virtual memory until you come to access them again. You could try upgrading your RAM capacity, or also try freeing up some physical c: drive space (I get nervous if I have less than around 200 megs free) and notice serious performance degredation if it dips below 30 megs Your filesize may be 20megs (that's pretty big, but by no means a total behemoth) but the functions and calculations it is carrying out may need 100 megs in any given millisecond of processing, so you may be trying to access your hardrive (do you hear lots of "whirring" ?) to compensate. As Dreamboat suggested, try to slim your file sizes down to relieve your immediate RAM, but also try to free up some C: space. Deleting MS Word is always a good start

Apr 2nd, 2002, 01:01 PM	#4
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	LMAO at the MS word comment...well said