You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

Workbooks are opened in compatibility mode Excel 2010 or Excel 2007

When you open a new workbook in Excel 2007 or Excel 2010, it opens in [Compatibility Mode].

This problem occurs because Excel 97-2003 workbook is selected as the default file format in Excel.
To resolve this problem, follow these steps:
  1. Start Excel 2007 or Excel 2010. (In this article, we use Excel 2010 for example).

  2. Click File, and then click Options.

  3. In the Excel Options window, click Save.

  4. Under the Save files in this format drop-down menu, select Excel Workbook (*.xlsx), and then click OK.

  5. Open an Excel file to confirm the issue is fixed.


Article ID: 2629973 - Last Review: 05/23/2014 09:05:00 - Revision: 8.2

  • kbstepbystep kbtshoot kbvideocontent KB2629973