Excel 2007 compatibility message

[Pat Wisch]

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:

"Some cells or styles in this workbook contain formatting that is not
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.

 

[Jim Rech]

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
| 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:
|
| "Some cells or styles in this workbook contain formatting that is not
| 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.