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
not going 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 are not using Excel 2007)
I need to keep the file in .xls.

How would I know if Im using the enhanced formatting in 2007? I guess I
am, but not on purpose. Is there a work around that would fix this problem?
--
I bet Bill Gates uses an Apple!


"PJFry" wrote:

Make sure you are saving the file as an .xlsx (or some 2007 variant) file.
If you are using the enchanced formatting in 2007 and save the file as .xls,
you will loose that formatting.

If that does not solve it, post back with the kind of formatting problems
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
changes and 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 Im dealing with, but I thought I would start with this complex
question first). This is causing hours of wasted time and effort. I cant
be the only one with this problem.
--
I bet Bill Gates uses an Apple!