Excel - Excel 2007 compatibility message

Asked By Pat Wisch

18-Jun-08 06:12 PM

Where I work, some people are using Excel 2003, some use Excel 2007, and
some use Excel 2004 on a Mac.  The people using Excel 2007 save their files
in Excel 97-2003 format.

I have noticed that when an Excel 2007 user opens a spreadsheet created in
Excel 2004, sometimes when the Excel 2007 user saves it in Excel 97-2003
format, the compatibility checker gives the following message:

supported by the selected file format. These formats will be converted to
the closest format "

There are over 40 instances listed, but there are no buttons available to
find these cells.  Is there a way to find these cells?  Or can the
compatibility message be safely ignored?

Thanks for your help.

19-Jun-08 06:36 AM

I don't think one can say that compatibly messages can always be ignored.
It's a case by case thing.  If you save the file and it looks okay and
prints okay then I'd think the format changes were quite minor.  The proof
of the pudding is in the eating, a wise man once said.

--
Jim
files