Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Workbooks are opened in compatibility mode Excel 2010 or Excel 2007

Workbooks are opened in compatibility mode Excel 2010 or Excel 2007

Symptoms

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



↑ Back to the top

Cause

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

↑ Back to the top

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.



  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.



↑ Back to the top

Keywords: kbstepbystep, kbtshoot, kbvideocontent, kb

↑ Back to the top

Article Info
Article ID : 2629973
Revision : 1
Created on : 1/7/2017
Published on : 5/23/2014
Exists online : False
Views : 123