Cant open xls files HELP!!

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

Thread: Cant open xls files HELP!!

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

    Default

     
    Brand New here and need help BAD.

    Ill try to keep it short, I am not an expert EXCEl user.

    had a xls file of 1800 person membership list and lost it!

    had someone re-enter the entire data base and now have it on disk but cant open it.

    when i try it says "file format is not valid"

    this is what happened when i tried to save and reopen the original one that i lost!

    using xp pro and ms office 4.3


    Please help!!

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    As a start this might work.

    Assume your file is called MyFile and is located in C:MyDocs. Assume also that your data is on Sheet1 in the file.

    Open a new workbook and in cell A1 type:

    ='C:MyDocs[MyFile]Sheet1'!A1

    If you're lucky this formula will return the value in cell A1 of the corrupted file.

    Copy the formula down and across to recover as much as you can, then convert the formulas to values and save the new workbook.

    Note this only recovers values, not formulas.

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

    Default

    i have the new files on disk that are not corrupted but i cant open them on my comp.

    they say they are xls files but when trying to open they say invalid format

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you can't open them they are corrupted aren't they?

  5. #5
    Board Regular
    Join Date
    Aug 2002
    Posts
    106
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you send me the file, I'll try opening it with Office XP. It's error recovery is really good. I'd also like to look at it for evidence of viruses.

    The typical reason for file corruption that we see here at the MS XL Support Group is either virus corruption, opening the a: drive door before Excel is finished writing to it, a dropped network connection (same basic reason as the a: drive scenario) and a system crash while editing. Did one of these happen to you?

    BTW, what anti-virus software are you using?
    <font size="-1">Mark Henri</font>

    <font size="-2">Microsoft Tier 1 Excel Support Technician</font>

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

    Default

      
    ok folks, i got it, it appears that the file was created in a newer version than i have. (office 2000) (versus office professional) had the person save as version 4.0 and i got it to come up and work. Thanks all

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