Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is formatting lost when saving from .xlsx to .xls?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is formatting lost when saving from .xlsx to .xls?
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. "txlogic" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is formatting lost when saving from .xlsx to .xls?
Perhaps have them install the compatibility package.
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats http://www.microsoft.com/downloads/d...displaylang=en txlogic wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving in XLSX Format | Excel Discussion (Misc queries) | |||
problem saving xlsx file | Excel Discussion (Misc queries) | |||
Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
Saving as .xlsx from VBA MACRO | Excel Discussion (Misc queries) | |||
saving xlsx file as xls changes currency symbols | Setting up and Configuration of Excel |