Workbooks are opened in compatibility mode Excel 2010 or Excel 2007

Article translations Article translations
Article ID: 2629973
Expand all | Collapse all

Symptoms

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

Collapse this imageExpand this image
2691751


Cause

This problem occurs because Excel 97-2003 workbook is selected as the default file format in Excel.

Resolution

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.

    Collapse this imageExpand this image
    2691752


  3. In the Excel Options window, click Save.

    Collapse this imageExpand this image
    2691753


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

    Collapse this imageExpand this image
    2691754

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

    Collapse this imageExpand this image
    2691755


Properties

Article ID: 2629973 - Last Review: May 23, 2014 - Revision: 8.2
Keywords: 
kbstepbystep kbtshoot kbvideocontent KB2629973

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com