Out of memory
Out of memory
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Out of memory

  1. #1
    Board Regular Stubby's Avatar
    Join Date
    Mar 2002
    Location
    Lat 51 23.3 mins North Long 0 24.7 Mins West
    Posts
    186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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??

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    LMAO at the MS word comment...well said

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

DMCA.com