Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Invalid File Format? (97 SR2b)

    I have users who store files on shared drives on our network. Occasionally, the Excel files become corrupted. When they try to open them, they get "filename.xls is an invalid file format" and Excel won't open the file. Isn't there a way to recover a corrupted file? I am looking thru my notes but cannot find it. Thanks!

    Lisa Bakalars

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Invalid File Format? (97 SR2b)

    Restore a backup copy? You *do* backup your network drives, don't you?

  3. #3
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Invalid File Format? (97 SR2b)

    Yes, we are currently restoring the file from tape, but I would still like to know how to recover a corrupt file. I know I've done it before, just can't recall how.

    Lisa Bakalars

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Invalid File Format? (97 SR2b)

    You will find several ideas in the replies to <post#=144365>post 144365</post#>.

  5. #5
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Invalid File Format? (97 SR2b)

    Formula

    ='C:My Documents[filename.xls]Sheet1'!A1

    This is what I was looking for! Thank you!!

    Lisa

    Lisa

Posting Permissions

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