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

T

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?
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xlsx file converted to xls file 1
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Saving as .xlsx from VBA MACRO 4
xlsx file to xls 1
change file from xlsx to xls 2
Extracting xlsx data from structured Storage 0
change default to xlsx 1
XLSX File Conversion 2

Top