ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compatibility Checker (https://www.excelbanter.com/excel-discussion-misc-queries/257431-compatibility-checker.html)

JGreg7

Compatibility Checker
 
When I save a Excel 2007 worksheet with settings for an Excel 2003 file, the
compatibility checker comes up and says the following:

"Some cells or styles in this worksheet contain formatting that is not
supported by the selected file format. These formats will be converted to
the closest format available."

(not very helpful or informative)

Ok, so now I know what the problem is, but just how do I find out which
cells are the offending formats? The file has multiple tabs, but is generaly
formatted with common fonts - nothing fancy. I have a few shaded cells, but
I am using standard colors that are available in Excell 2003.

Is there a feature to show me what the compatibilty checkier is seeing?

--
Thank you,
John Gregory


All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com