Check if this workbook contains elements that are not compatible with earlier versions of Excel

Microsoft Excel’s Compatibility Checker flags when saving a file in an earlier file format might cause functionality issues or loss of fidelity. The Compatibility Checker is a feature of Microsoft Office Excel 2007 and Microsoft Excel 2010.

When you save a workbook in a previous version, Excel 97 through Excel 2003, from Excel 2007 or Excel 2010, the Compatibility Checker scans the workbook to see if it contains features that are not supported by the earlier version. To help you make decisions about how to handle compatibility issues, the Compatibility Checker displays dialog boxes with options. It can also be used to create a report on any issues in the workbook, or disable the feature.

Sometimes, you need to disable the Compatibility Checker for a particular spreadsheet. With Aspose.Cells' APIs you can do this programmatically so that users don’t get frustrated or confused by the Compatibility Checker dialog box popping up when they re-save the file in Microsoft Excel manually.

To disable the Compatibility Checker in Microsoft Excel (for example Microsoft Excel 2007/2010):

• (Excel 2007) On the Office button, click Prepare, then Run Compatibility Checker, and then clear the Check compatibility when you save this workbook option.
• (Excel 2010) On the File tab, click Info, then Check for issues, click Check Compatibility, and, finally, clear the Check compatibility when you save this workbook option.

Using Aspose.Cells APIs

Set the Workbook.Settings.CheckComptiliblity property to False to disable Microsoft Excel’s Compatibility Checker.

Code Examples

The code examples that follow show how to disable the Compatibility Checker with Aspose.Cells for .NET.

In order to continue enjoying our site, we ask that you confirm your identity as a human. Thank you very much for your cooperation.

I have prepared an excel workbook in Excel 2013 (32-bit) Windows.

It is a kind of report template, where others input the data, selects from in-cell dropdowns etc. The workbook does not contain any macros.

What is the best way to test the compatibility with the target audience, who mostly work on Excel 2007.

For example, in-cell dropdowns can have references from a separate sheet in Excel 2013, but these don't work in Excel 2007.

Do I need to install Excel 2007 on my system and test it out?