Disable Compatibility Checker in Excel

Disable Compatibility Checker in Excel Worksheets in C#

Using Microsoft Excel

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.