Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Excel won't open

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a user who can open a 96mb file no problem but when they try to open 3,500mb file it either won't open or opens then hangs excel. This happens both over the network and when saved to the C-drive. When I tried to open the file on my PC it wouldn't open either. When I look in TaskManager Excel.exe is using all the memory. Any ideas?

  2. #2
    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

    Hi Paul,

    are you sure about those file sizes ?

    96 meg is massive, the other one is galactic

    my biggest is 16 meg and *still* makes me nervous about performance !

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

    Default

    Hi ==


    a 96mb file no problem but when they try to open 3,500mb file it either won't open or opens then hangs excel. This happens both over the network and when saved to the C-drive. When I tried to open the file on my PC it wouldn't open either.

    I think you mean kb not mb else im gonna retire from excel right now, i know no PC that can support such file sizes not even USA FBI can cope with that one for sure - theres no need or point the data could be split into chnks..

    When I look in TaskManager Excel.exe is using all the memory. Any ideas?

    Yur on a network that 10/100 max so that file ssize wont run very well and take light years to get across and the network will trash im sure of that. i wipe my forehead.

    If you Win 95 or 98 on wstation thats the problem and not excel, the network will be NT4 or novel or poss Win2000 and traffic will be high not transfer rates slow and add Anti virus... nar this post does not add up. No IT dept will allow networks to hold such data for one user 3.5 gigs ????

    Ecxel would never load it .. to save would take 6 months

    No i have thought hard.. please varify thouse files sizes ...

    Windows on a network is dreadful under 95 or 98 my call is close application IE network ones, be careful if you network is (im going to get shot again for this one) set up correctly Excel will be corperate image on the network drive so that will need network connection to allow excel to run, thus slower..

    try and get the file on a floppy and run on non network PC , remenber to virus check first as always even thou you think its safe it might not... poss virus... no i dounbt it but never chance it.

    --- Hi chris sorry not stepping in just helping..

    Speak soon mate...

    HTH
    Rdgs
    ==========
    Jack PS get some sleep Chris...



  4. #4
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    954
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Paul, does this happen even when excel is the only application running? Also have a look at how much disk space you have on c: Perhaps a cleanup is in order.

    Regards
    George
    George J

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jack

    Apologies - more haste less speed. You are correct. The file sizes were 96kb and 3500kb. I don't think it is the file itself because there are other files of a similar size that he is having problems with.

    Paul (in the UK)

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    George

    This happens when nothing else is happening and he has about 7gb spare on his C-drive

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

    Default

    Hi Paul

    I have been thinking about this one. 4mb is just fine.. all is ok.

    try this reboot and open the 3.5MB file see if ok or try open in word... sound silly but we need to bust open the file to see if curupt pr not

    To do this open word and the click open and select he excel file if ity open it will be all messed up but open it will be ..
    Let me know

    Rdgs
    ==========
    Jack

  8. #8
    New Member
    Join Date
    Feb 2002
    Location
    Washington State
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Paul I don't know if it will help, but could it possibly be that Excel is looking for an alternate startup location? That will cause it to hang on opening occasionally. Something to try is to open Excel then as Excel trys to start hold down the shift key. This will stop Excel from opening any files from the alternate location. Once it loads then release the shift key. If that works then look in optionsgeneral and uncheck the box Alternate startup location, close Excel and see if that fixes it.

    Probably a long shot, but I have had that problem on our network here.

    Rick

Some videos you may like

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
  •