Lost Formatting

[Theresa]

We have several Excel files that were created with either Excel 2000 or 2003.
We are now working on these files in 2007. We continue to have problems with
the files losing formatting. We will change font color, font size, cell
formats, etc. We save the file but when we re-open the file all of the
revisions that we saved are gone. What can we do to these files to get them
to keep their formatting?

 

[Bob I]

Are you saving them in Excel 2007(XLSX) format?

 

[Theresa]

No, currently we're working on these files in compatibility mode. Should we
convert them?

 

[Bob I]

Unless there is some 3rd party software need for the old format, I would
suggest moving to the xlsx format.

 

[cindypsych]

No, currently we're working on these files in compatibility mode. Should we
convert them?






- Show quoted text -

The problem is that when you choose formatting that is 2007 only
formatting, then save it in the Excel 200-2003 format, it loses the
formatting. In order to take advantage of all the nice formatting in
2007 you should be saving it in the .xlsx format, not .xls.

 

[brianatee]

I am having the same issue. Unfortunately some of our office is still
using 2003 and the file in question is a bit of a beast which makes me
wonder if it will survive being converted to open as an xlsx in 2003.
Is there anyway to make sure that formatting changes are 2003-
compatible while working in 2007? I know that the colors are
different, but simple things like number of decimal places seem like
they should carry through. Also, any ideas why this happens sometimes
and not others? (Some sheets I work with are fine with 2003 and 2007
edits to them, colors often change but in general formatting is
preserved.

 

[sulbaran]

I have same problem in my organization, many offices have not 2007 Excel
version and if I save on my Office 2007 as xls files for them, all formats
will be loss . Minnebarista would you please send more clear instruction
about how you was able to fix the problem ?