Consulting

Results 1 to 10 of 10

Thread: Sleeper: problem opening Huge XLs file

  1. #1
    VBAX Newbie
    Joined
    Jun 2004
    Posts
    4
    Location

    Sleeper: problem opening Huge XLs file

    Hi all

    About 10,000 row and 30 column Xls file, the Excel can not open it......(full of formulas and macros)

    i do not why........

    could any one pls give some hints?

    yours
    hesham

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Can you post some more info about your PC specs like memory, processor speed, version of windows, version of Excel.

    When you say it won't open what exactly happens, does the computer just freeze?

    Just for starters try opening Excel first and let it fully load then from Excel open the file and see if that helps (as opposed to just opening the file from windows).

    Also if there are any macros running disable them to see if that helps at all.

  3. #3
    VBAX Regular WillR's Avatar
    Joined
    May 2004
    Location
    Rugby - UK
    Posts
    60
    Location
    Will
    Not all chemicals are bad. Without chemicals such as hydrogen and oxygen for example, there would be no way to make water, a vital ingredient in beer.

  4. #4
    VBAX Newbie
    Joined
    Jun 2004
    Posts
    4
    Location

    reply to WillR

    Hi WillR

    my huge xl file is full of formulas and macros
    the computer info:
    memory is 40G

    Ram 256

    Speed 512 pantuim4

    windows xp

    Excel 2003

    other of xls can normally be openned

    Excel software is completely loaded

    any more ideas are wellcomed

    yours
    hesham

  5. #5
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    What size is the file zipped? Can you get an older copy of the file off of some network server or any sort of backup at all?

    Do you know that if you open a new blank Excel workbook, you can often type a link to your bad file? Here's the syntax: =[test.xls]Sheet1!A1

    But if you don't know the names of the worksheets, I'm not sure how we'd do that.
    ~Anne Troy

  6. #6
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    If you set calculations to manual and disable macros can you open the file??

  7. #7
    Try openoffice (http://www.openoffice.org). Openoffice has been able to open files that Excel refused to open, saving my sorry tush on more than one occasion.

  8. #8
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    skulakowski: Thanks for that. I ALWAYS forget that!! I must have it beat into my head, I suppose...

    And welcome!
    ~Anne Troy

  9. #9
    VBAX Regular Kelly's Avatar
    Joined
    Jun 2004
    Location
    Los Angeles, California
    Posts
    84
    I just want to say that in the past I have opened humongous files that were apparently not opening but really they WERE opening -- just opening veeeerrrrry sloowwwly.

    What I mean is, I once had a similar situation, so I did 'File' menu, Open.. and chose the file, then I left my computer alone for about 20-30 minutes, and finally the thing opened.

    Don't know if that would work for you, Helmekki.

  10. #10
    MS Excel MVP VBAX Regular Ken Wright's Avatar
    Joined
    Jun 2004
    Posts
    17
    Location
    What size is the file, both unzipped and zipped?

    Regards
    Ken..................
    It's easier to beg forgiveness than ask permission

Posting Permissions

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