Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Warning Message - Excel is Currently in Compatibility Mode


Warning Message - Excel is Currently in Compatibility Mode

This article applies to Jet Essentials and Jet Reports 2009 and higher

Running Excel in "Compatibility Mode" may cause strange behaviors in Jet reports.  Errors are usually inconsistent and hard to reproduce.  Examples of issues caused by Compatibility Mode include:

  • Excel hangs when running or opening reports
  • Reports cannot be run from Report mode
  • Reports run slowly
  • Sheets don't replicate correctly
  • More than 65000 rows cannot be replicated
  • etc...

Because of these problems, we have updated Jet with the following warning message that appears when running a report with Excel in Compatibility Mode.

To prevent this warning message from appearing each time you run a report, please make sure that Excel is no longer running in Compatibility Mode.  To exit Compatibility mode do all of the following:

  • Ensure that the workbook is saved in the Excel 2007-2016 format (.xlsx)
  • Ensure that the default save format is configured for Excel 2007-2016 (.xlsx) by going to:
    • Office 2007: Office Button > Excel Options > Save, and change the "Save files in this format:" to "Excel Workbook (*.xlsx)"
    • Office 2010-2016: File > Options > Save, and change the "Save files in this format" to "Excel Workbook (*.xlsx)"
  • Ensure that there is not a network policy applied to Excel setting the default save format to .xls.  You may need to ask your IT professional about this.
  • Restart Excel

If you need to share reports with users of Excel 2003, these users can download the Microsoft Office Compatibility Pack for Excel 2007 File Formats which will allow them to open .xlsx files.  The compatilbility pack can be downloaded from Microsoft here .

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments