Same problem and same frustration here. Please post if you find the
solution.

On May 11, 9:17*am, 2007headache
wrote:
I checked and there are no compatibilty issues. *I haveExcelset to do an
auto check for compatibilty probelms. *This is a software problem withExcel
and for the life of me I can't understand why all these format issues are
happening unless this is Microsoft's way of forcing the upgrade to2007. *

This should be easy. *If I can save the file as an .xls without clsing the
file and still keep my formats, then I should be able to close the file and
open it without losing the format. *There must be some auto setting that is
causing this to happen, does anyone know how to shut this off?
--
I bet Bill Gates uses an Apple!



"PJFry" wrote:
Under the office button (that little office logo on the upper left) go to
Prepare, then Run Compatibilty Checker. *It will show you which elements are
notgoing to work properly in an .xls format. *

See if that flags any problems for you and post back.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.

"2007headache" wrote:

Thanks for your help PJFry, but because the file is shared throughout various
divisions and because of compatibility issues (most arenotusingExcel2007)
I need to keep the file in .xls. *

How would I know if I’m using the enhancedformattingin2007? *I guess I
am, butnoton purpose. *Is there a work around that would fix this problem?
--
I bet Bill Gates uses an Apple!

"PJFry" wrote:

Make sure you aresavingthe file as an .xlsx (or some2007variant) file. *
If you are using the enchancedformattingin2007and save the file as ..xls,
you will loose thatformatting. *

If that doesnotsolve it, post back with the kind offormattingproblems
you are having. *Cell fills, currency, conditional, etc.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.

"2007headache" wrote:

When working with Excel2007, why do I lose my cell format after I close a
file then reopen it? *For example: I format a column as a date, save the
changesand close the file, but when I reopen the file the column converts
back to General and I lose the date format (this is just one of the number of
pains I’m dealing with, but I thought I would start with this complex
question first). *This is causing hours of wasted time and effort. *I can’t
be the only one with this problem.
--
I bet Bill Gates uses an Apple!