Excel spreadsheet unable to be opened?

Discussion in 'Mac Apps and Mac App Store' started by Coach, Feb 27, 2004.

  1. Coach macrumors newbie

    Joined:
    Feb 18, 2004
    #1
    I have an Excel spreadsheet that I saved on a Mac and is now unable to be opened? I get an "unable to read file" error and I'm trying to now open it on an IBM PC and it says it does not recognize the file. Anyone seen this and been able to get the file open?
     
  2. jxyama macrumors 68040

    jxyama

    Joined:
    Apr 3, 2003
    #2
    first question: are you sure it's an Excel file?

    second question: how did you move the file from Mac to the PC?
     
  3. Coach thread starter macrumors newbie

    Joined:
    Feb 18, 2004
    #3
    Yes, it is an Excel file and I FTP'd it in binary format to my server and then back down to an IBM PC.
     
  4. Gee macrumors 65816

    Joined:
    Feb 27, 2004
    Location:
    London, UK
    #4
    Does the file end ".xls"? You can save it on your Mac without the .xls, but the PC won't recognise it...

    To open on the PC, rename the file with the .xls extension first.
     
  5. cubist macrumors 68020

    Joined:
    Jul 4, 2002
    Location:
    Muncie, Indiana
    #5
    There are eleventeen different versions of Excel, all with differences in file format. (Microsoft's legacy to computing :mad: )

    But if you can't open the file in the version that created it, likely the file is corrupt. Since the file is binary gibberish rather than something editable like XML or DIF, you are probably hosed.

    In the future, (a) make backups, and (b) export data to CSV from time to time.
     
  6. Coach thread starter macrumors newbie

    Joined:
    Feb 18, 2004
    #6
    It does end in .xls now.
     
  7. Gee macrumors 65816

    Joined:
    Feb 27, 2004
    Location:
    London, UK
    #7
    Does it not open on the Mac or on the PC?

    If this is the case, as Coach said, it's probably corrupt....
     
  8. Coach thread starter macrumors newbie

    Joined:
    Feb 18, 2004
  9. Crikey macrumors 6502

    Joined:
    Jan 14, 2004
    Location:
    Spencer's Butte, Oregon
    #9
    I've had some luck in circumstances like this with opening the file in OpenOffice.org's spreadsheet module, making some trivial change, and saving it again as an Excel format file. If your file is truly corrupted, this might not work, but if the damage is minor or stems from Microsoft's inter-version compatibility issues, Oo_O seems to be more robust than Excel about handling errors.

    I've found Oo_O to be good at repairing Word files, as well.

    You could try other nominally-Office-sompatible programs for this as well; I think AppleWorks can open or import Excel files, and I know tha ThinkFree Office can.

    Good luck.


    Crikey
     
  10. Gee macrumors 65816

    Joined:
    Feb 27, 2004
    Location:
    London, UK
    #10
    Or you could try importing into a database such as filemaker....
     
  11. Coach thread starter macrumors newbie

    Joined:
    Feb 18, 2004
    #11
    I have the file on an IBM PC now, what do you think is best? I do not have filemaker here.
     
  12. Gee macrumors 65816

    Joined:
    Feb 27, 2004
    Location:
    London, UK
    #12
    How about Access? See if you can import the file into Access, and then re-export it as an Excel file again...
     
  13. Coach thread starter macrumors newbie

    Joined:
    Feb 18, 2004
    #13
    I get:

    "Please check that the file exists and is in the proper format"
     
  14. Gee macrumors 65816

    Joined:
    Feb 27, 2004
    Location:
    London, UK
    #14
    Hmmm. Not sure I can think of anything else. You're the guy who's just sent back a G5, right? Is/was this problem a contributing factor? When did your file become corrupt?
     
  15. Dave Hall macrumors newbie

    Joined:
    Dec 2, 2004

Share This Page