Why is formatting lost when saving from .xlsx to .xls?

[txlogic]

I have EXCEL 2007 but most of the people I work with still have 2003 EXCEL.
When I create a file and save it as an .xls (2003) file, it loses all the
formating (i.e. currency, percentages, color fill, etc..). If I keep the
file in 2007 (.xlsx) formt it is okay, but the users I work with can not view
it. How do I get the file to retain the formatting when saved as 2003
version of EXCEL?

 

[trip_to_tokyo]

Probably because Microsoft did not test for this before they released the
software.

Best thing to do in the long term is to upgrade all your users to 2007 so
that you do not run into problems like this in future.

Please hit yes if my comments have helped.

Thanks.

 

[Bob I]

Perhaps have them install the compatibility package.
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007
File Formats
http://www.microsoft.com/downloads/...70-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en