Results 1 to 13 of 13
  1. #1

    MilenkoD's Avatar
    Member Since
    Aug 16, 2007
    Location
    Dublin, CA
    Posts
    133
    Specs:
    2.53Ghz Macbook Pro
    xlxs from Windows Office 2007 to Mac Office 2008
    Having problems opening an xlxs file generated in Windows Office 2007 with Mac Office 2008. Mac Office keeps telling me that the file is corrupt. I can open the file just fine on my Windows machine in Office 2007....no dice on the Mac.

    However, if I Save As a regular .xls file, it works OK. I have many files that I need to use on my Mac that were generated in Windows Office 2007. Aside from opening all those files and re-saving them, is there anything else (easier) that can be done? Can't they natively open in Mac Office 2008?

  2. #2

    harryb2448's Avatar
    Member Since
    Nov 28, 2007
    Location
    Nambucca Heads Australia
    Posts
    22,109
    Specs:
    Imac 27" Retina 5K, 512GB flash memory, 3.3GHz, 16GB memory, macOS Sierra beta.
    If you try saving in .xls in Preferences may make a difference.

  3. #3

    MilenkoD's Avatar
    Member Since
    Aug 16, 2007
    Location
    Dublin, CA
    Posts
    133
    Specs:
    2.53Ghz Macbook Pro
    Quote Originally Posted by harryb2448 View Post
    If you try saving in .xls in Preferences may make a difference.
    Ok...can't even open the files in Mac Office. I get a "File may be corrupt" error message.

  4. #4


    Member Since
    Jun 28, 2007
    Posts
    99
    Did you try opening it with Open Office?

  5. #5

    MilenkoD's Avatar
    Member Since
    Aug 16, 2007
    Location
    Dublin, CA
    Posts
    133
    Specs:
    2.53Ghz Macbook Pro
    Quote Originally Posted by brokeenthusiast View Post
    Did you try opening it with Open Office?
    no, and that's not a solution either. Not interested in another office suite.

  6. #6

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    48,835
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    Try saving the Excel files using the Office 2003 document format rather than the newer Office 2007. In other words, use compatibility mode when saving Office files on your Win machine. They should then open and save OK in Mac Office 2008 if no macros are contained within the documents.

    (Windows Office 2007 document files containing macros will not display correctly and\or sometimes refuse to open in Mac Office 2008.) Mac Office 2008 sadly does not support macros.

    Regards.

  7. #7

    MilenkoD's Avatar
    Member Since
    Aug 16, 2007
    Location
    Dublin, CA
    Posts
    133
    Specs:
    2.53Ghz Macbook Pro
    Quote Originally Posted by chscag View Post
    Try saving the Excel files using the Office 2003 document format rather than the newer Office 2007. In other words, use compatibility mode when saving Office files on your Win machine. They should then open and save OK in Mac Office 2008 if no macros are contained within the documents.

    (Windows Office 2007 document files containing macros will not display correctly and\or sometimes refuse to open in Mac Office 2008.) Mac Office 2008 sadly does not support macros.

    Regards.
    I've re-saved a few in the regular xls format and it seems to be fine. I do suspect that it might have something to do with macros or VB scripts. But whay would those run fine in xls and not xlsx? The other delima is I have hundreds of files, I can't be going though all of them and re-saving them. That's way too much effort...

  8. #8

    THeBadMonkey's Avatar
    Member Since
    Sep 22, 2008
    Location
    Leeds
    Posts
    108
    Specs:
    Black Macbook: 2.4 ghz dual core 4gb Ram 250gb Hdd
    Office 2008 doesnt support VBS which a lot of the new files have in the background - its typical M$ not making things compatable. Whats in the Ss if you dont mind me asking? is there anything"funky"?

  9. #9

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    48,835
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    Quote Originally Posted by MilenkoD View Post
    I've re-saved a few in the regular xls format and it seems to be fine. I do suspect that it might have something to do with macros or VB scripts. But whay would those run fine in xls and not xlsx? The other delima is I have hundreds of files, I can't be going though all of them and re-saving them. That's way too much effort...
    Microsoft has promised the inclusion of VBS in the next major update to Mac Office but for folks like yourself that's not an answer. The only other thing I can suggest is to install Windows on your Mac. You can do it via Boot Camp or by using virtual software (Parallels, Fusion). I have both Mac Office 2008 and Win Office 2007 and that's what I have done.

    As for Excel files which contain scripts (formulas, etc.) and run OK in compatibility mode, I suspect Mac Office 2008 ignores the VBS and presses on. However, when the xml document format is chosen, it can not ignore the scripts because it also has to do the conversion.

    If you need assistance setting up Windows on your machine, you'll find lots of help by searching the forum or asking.

    Regards.

  10. #10


    Member Since
    Mar 30, 2004
    Location
    USA
    Posts
    4,744
    Specs:
    12" Apple PowerBook G4 (1.5GHz)
    Do you have the latest updates to Office '08?
    Quote Originally Posted by MilenkoD View Post
    Quote Originally Posted by brokeenthusiast View Post
    Did you try opening it with Open Office?
    no, and that's not a solution either. Not interested in another office suite.
    Well, the operative word was "try." It might prove useful for diagnosing the issue.
    (And if it did work, you might well be better off developing an interest in the functional suite.)

  11. #11

    MilenkoD's Avatar
    Member Since
    Aug 16, 2007
    Location
    Dublin, CA
    Posts
    133
    Specs:
    2.53Ghz Macbook Pro
    Well...I have some further updates if anyone is willing to hear them...

    I tried to copy the files to a USB stick and open them again (thinking that there's a network sharing issue at play)...no luck, same error.
    So then I logged onto the Windows machine from my other Mac that has Apple Numbers. It was able to open the older revision of the file from several months back and the same file, with the updated data, that is in question. Numbers was able to open it. Both files generates an error report but two error items were different. On the file in question, the following error appeared:
    "Hyperlinks within the notebooks and hyperlinks to other files aren't supported and were removed"
    There was also a font missing, which I didn't think would cause file not to open.

    Could this be the source of my problems with the xlsx files? If so, what to do from here (other than open all in Numbers)??

  12. #12


    Member Since
    Jun 10, 2009
    Posts
    1
    xlsx document
    I am also having the same problem. It is a file I downloaded from a class that I am taking, but when I open it, it adds the letters cpgz after the .xlsx and when I open in in Excel...its all jibberish.

    Please help as I need this for the class. I have sent a support ticket to tech support responsible for the class, but to no avail. Its been 2 weeks now!
    I am using 10.4.11 and Microsoft 2004 for Mac

  13. #13


    Member Since
    Jun 01, 2008
    Posts
    66
    dpitts, the cpgz extension might indicate a compressed file. You can try expanding it by running a file on your computer located in the System/Library/CoreServices/ directory called BOMArchiveHelper.app

    Hope that works!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mac not allowing installation of windows office professional 2007
    By DaNi3l in forum Running Windows (or anything else) on your Mac
    Replies: 1
    Last Post: 02-18-2013, 06:26 PM
  2. Office 2008 Key for Office 2007
    By vansmith in forum Running Windows (or anything else) on your Mac
    Replies: 6
    Last Post: 07-13-2009, 10:58 PM
  3. Office 2007 (w/ Fusion) or Office 2008?
    By davidng150 in forum Switcher Hangout
    Replies: 5
    Last Post: 09-24-2008, 01:31 PM
  4. MS Office 2008 vs. 2007
    By bvann89 in forum OS X - Apps and Games
    Replies: 10
    Last Post: 09-10-2008, 08:42 PM
  5. Replies: 3
    Last Post: 05-13-2008, 05:32 PM

Posting Permissions

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