Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Format Invalid (Excel 2000)

    Working with an excel file---then I can't open it. Get a message "name of the file--file format invalid" Any ideas why all of a sudden this file went belly up? Thanks for your help---Carol

  2. #2
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Format Invalid (Excel 2000)

    Yikes!!! That's not pretty and there's no real solution that I've ever found. Sometimes Excel just <img src=/S/barf.gif border=0 alt=barf width=64 height=23> all over itself with no warning whatsoever. You might try opening it in another version of Excel (or Sun Office) or if you just want the data itself you could open a new workbook and have a formula point to the dead workbook and suck the data out.

    In cell A1 of your new empty workbook add "=[deadworkbook.xls]sheet3!A1" (without the quotes)

    then copy this down from your new workbook.

    Hopefully you have another working copy. This has happened to me several times and I get to the point that I flinch every time I open a workbook wondering if THIS is the time it'll die on me. <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15>

    Deb

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: File Format Invalid (Excel 2000)

    This has several ways to get info from a corrupt file.

    Steve

Posting Permissions

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