The Excel Compatibility Checker dialog box in Excel 2007 (which warns of
features in a workbook which aren't supported by earlier versions of Excel
which may be lost if the file is saved in an earlier format, e.g. Excel 2003)
currently doesn't say which workbook it is referring to.
This is a problem when using a .net or VBA program from Excel to manipulate
other Excel files. In our case we have a custom toolbar that reads in data
from another Excel file of the user's choice, and writes to this file, the
Excel Compatibility Checker dialog box pops up to warn "minor loss of
fidelity" because "some cells or styles in this workbook contain formatting"
that is not supported by earlier versions, but the poor user doesn't know
which of several workbooks s/he may have open the dialog box refers to!
|
Similar Threads
