New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

xlxs from Windows Office 2007 to Mac Office 2008


Post Reply New Thread Subscribe

 
Thread Tools
MilenkoD

 
MilenkoD's Avatar
 
Member Since: Aug 16, 2007
Location: Dublin, CA
Posts: 133
MilenkoD is on a distinguished road
Mac Specs: 2.53Ghz Macbook Pro

MilenkoD is offline
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?
QUOTE Thanks
harryb2448

 
harryb2448's Avatar
 
Member Since: Nov 28, 2007
Location: Nambucca Heads Australia
Posts: 16,901
harryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond repute
Mac Specs: iMac i5 2.7GHz OS X.9.4

harryb2448 is offline
If you try saving in .xls in Preferences may make a difference.
QUOTE Thanks
MilenkoD

 
MilenkoD's Avatar
 
Member Since: Aug 16, 2007
Location: Dublin, CA
Posts: 133
MilenkoD is on a distinguished road
Mac Specs: 2.53Ghz Macbook Pro

MilenkoD is offline
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.
QUOTE Thanks
brokeenthusiast

 
Member Since: Jun 28, 2007
Posts: 99
brokeenthusiast is on a distinguished road

brokeenthusiast is offline
Did you try opening it with Open Office?
QUOTE Thanks
MilenkoD

 
MilenkoD's Avatar
 
Member Since: Aug 16, 2007
Location: Dublin, CA
Posts: 133
MilenkoD is on a distinguished road
Mac Specs: 2.53Ghz Macbook Pro

MilenkoD is offline
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.
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 38,480
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
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.
QUOTE Thanks
MilenkoD

 
MilenkoD's Avatar
 
Member Since: Aug 16, 2007
Location: Dublin, CA
Posts: 133
MilenkoD is on a distinguished road
Mac Specs: 2.53Ghz Macbook Pro

MilenkoD is offline
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...
QUOTE Thanks
THeBadMonkey

 
THeBadMonkey's Avatar
 
Member Since: Sep 22, 2008
Location: Leeds
Posts: 108
THeBadMonkey is on a distinguished road
Mac Specs: Black Macbook: 2.4 ghz dual core 4gb Ram 250gb Hdd

THeBadMonkey is offline
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"?
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 38,480
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
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.
QUOTE Thanks
technologist

 
Member Since: Mar 30, 2004
Location: USA
Posts: 4,744
technologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond repute
Mac Specs: 12" Apple PowerBook G4 (1.5GHz)

technologist is offline
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.)
QUOTE Thanks
MilenkoD

 
MilenkoD's Avatar
 
Member Since: Aug 16, 2007
Location: Dublin, CA
Posts: 133
MilenkoD is on a distinguished road
Mac Specs: 2.53Ghz Macbook Pro

MilenkoD is offline
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)??
QUOTE Thanks
dpitts

 
Member Since: Jun 10, 2009
Posts: 1
dpitts is on a distinguished road

dpitts is offline
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
QUOTE Thanks
Lucion

 
Member Since: Jun 01, 2008
Posts: 66
Lucion will become famous soon enough

Lucion is offline
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!
QUOTE Thanks

Post Reply New Thread Subscribe


« Debt Quencher - worth the money? | Safari and Firefox »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Office for Mac 2008 & Entourage David Fulton OS X - Apps and Games 5 10-07-2008 03:02 PM
MS Office Word (2008) for mac question... Desidarius OS X - Apps and Games 1 08-08-2008 10:28 PM
Switcher Article in Today's Times studio34 Switcher Hangout 9 08-11-2006 03:10 PM
Mac Users Get More ISP Choices schweb Apple Rumors and Reports 1 03-06-2003 10:57 AM

All times are GMT -4. The time now is 04:41 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?