Compatibility Issues between Mac and PC

[chrystal25]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)

I just purchased a Mac for my home business. I was formerly using a PC w/windows vista. My problem lies in that I need to send other co-workers excel documents. I have no problem opening their documents, but they keep having issues with mine. I know none of them have 2008. I am unsure of their exact versions, but I do know that they all have pc's w/windows. The issues that they are having range from them not being able to save after making changes to the document - to - not just being able to open it at all from their email!! I have tried to save the file types as -

Excel workbook
Excel 97 - 2004 & 5.5/95 workbook.

And lastly there are macros from amazon.com on the all of files.

PLEASE HELP!! I don't want to go back to my PC!!!

 

[chrystal25]

Also I forgot to add that I was not protecting the documents, and when my co-workers would actually be able to open them - not only would it not let them save, it would also tell them it was protected and that they needed to enter in the password. And like I said I never protected the files in the first place.

Basically I just need to know what File format will work.

Thanks for any help - I truly appreciate it!!

~Chrystal

 

[Phillip Jones]

Unless your using some of the new exotic features designed into 2008
just go to Preferences >Compatibility and set 97-2004 setting.
Or when you choose to save the document do *Save As...* and scroll down
list until you see 97-2004 (or some variation on this. It means from
Office 97 PC to Office 2004 Mac)

Then save your document. It means you colleagues, are using version that
are not either Office2008 Mac or Office 2007 PC. Both those version save
by default in the new oop-XML format. (docx, xlsx, pptx).
Now if you have added something to the database/spreadsheet that uses
one or more of the new 2008 features they will be lost in the
translation. So my advise would be save copy in the old format after you
have finished and see if everything you put in stay in. If so send to
your colleagues, they should have no problem

Also I forgot to add that I was not protecting the documents, and when my co-workers would actually be able to open them - not only would it not let them save, it would also tell them it was protected and that they needed to enter in the password. And like I said I never protected the files in the first place.

Basically I just need to know what File format will work.

Thanks for any help - I truly appreciate it!!

~Chrystal

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[chrystal25]

I'm using 2004 - Not 2008!

 

[chrystal25]

I'm sorry I forgot to clarify that - But I did mention that I use Macros... Which 2008 does not support (already made the mistake of purchasing it- *SIGH*!!)

 

[Phillip Jones]

Okay you should have any problems in that case *unless* you have used
something that used the VBA or Macros based on VBA.

IF that's not the problem I don't know What could be the problem.

One thing to suggest if there are PC's in the House (not just Macs)
then when you go to save make sure the check box next to show extensions
is checked on and that you see xls at the end of you file.

To mac's it doesn't make a difference if created on another mac whether
you see this extension. But on PC even though its said it now doesn't
make a difference depending upon how servers are set up most still
depend on those extension to identify that file type.

If this still doesn't help wait for someone else here to weigh in.

I'm sorry I forgot to clarify that - But I did mention that I use Macros... Which 2008 does not support (already made the mistake of purchasing it- *SIGH*!!)

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Jim Gordon MVP]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)

I just purchased a Mac for my home business. I was formerly using a PC w/windows vista. My problem lies in that I need to send other co-workers excel documents. I have no problem opening their documents, but they keep having issues with mine. I know none of them have 2008. I am unsure of their exact versions, but I do know that they all have pc's w/windows. The issues that they are having range from them not being able to save after making changes to the document - to - not just being able to open it at all from their email!! I have tried to save the file types as -

Excel workbook
Excel 97 - 2004 & 5.5/95 workbook.

And lastly there are macros from amazon.com on the all of files.

PLEASE HELP!! I don't want to go back to my PC!!!

Hi,

It doesn't sound like you're doing anything in Excel that would cause a
compatibility problem.

What method(s) are you using to bring the files from your computer to
the Windows computers? Email? Flash drive?

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9

 

[chrystal25]

I am using Email to send the Documents. Today I switched back to my PC because, it wasn't very professional to send documents that were not usable.

I would LOVE to go back to my Mac if I could figure it out!!

I always disabled the macros when I would open the files - so I don't understand how I would alter them??

Also - Office kept closing down without warning.

 

[Phillip Jones]

Go back to you Mac and try the following:

save file quit Excel.

now from finder locate and highlight that file the go to File menu (from
Finder desktop) and choose create archive.

this will change the extension to .zip

Now send file. Now go to a Pc and download that zip file and use winzip
to open. now see if excel PC can open.

see What happens and report back.

I am using Email to send the Documents. Today I switched back to my PC because, it wasn't very professional to send documents that were not usable.

I would LOVE to go back to my Mac if I could figure it out!!

I always disabled the macros when I would open the files - so I don't understand how I would alter them??

Also - Office kept closing down without warning.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Michael]

Are there similar Add-Ins for Macs e.g. Analysis ToolPak etc? I've just migrated from Windows to Mac and some of the formulae not recognised on Mac.

Thanks.

 

[JE McGimpsey]

Are there similar Add-Ins for Macs e.g. Analysis ToolPak etc? I've just
migrated from Windows to Mac and some of the formulae not recognised on Mac.

The Analysis Toolpak is available for MacXL versions prior to XL08, and
come on the Install Disk. Check Tools/Add-ins to see if the ATP was
installed. If not, copy the Analysis Tools folder from your Install Disk
to the

HD:Applications:Microsoft Office 2004:Office:Add-Ins:

folder.

The ATP is not necessary for function compatibility XL08 since the ATP
functions were made part of XL.