saving as different formats, 2007, MAC

[rob read]

Hi,

I am working with excel 2007, but need to have my spreadsheet available in different formats for different people.

How do I save for a Excel MAC.

When I pull up the SaveAs, to save for 97-2003, there are a few things that come up in the dropbox to "fix". Once I do this how can I test to see what this looks like and if it works, if I only have 2007.

cheers

[martindwilson]

there are formulas and features new to later versions of excel 2003
any of these listed wont work if created in excel 2007
see attached
also you are limited to 3 conditional formats pre 2007
the colour palate may be different and several other features like tables

[rob read]

thanks for your help.

This has been very useful, just unfortunate I hadn't learnt this at the beginning. lol

cheers Rob