Workbooks are opened in compatibility mode Excel 2010 or Excel 2007

Article ID: 2629973
Expand all | Collapse all
Collapse this imageExpand this image
sbs_small
This is a step-by-step
(http://support.microsoft.com/)
article.
Back to the top | Give Feedback

SYMPTOMS

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

Collapse this imageExpand this image


Back to the top | Give Feedback

CAUSE

This problem occurs because Excel 97-2003 workbook is selected as the default file format in Excel.
Back to the top | Give Feedback

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


  3. In the Excel Options window, click Save.

    Collapse this imageExpand this image


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

    Collapse this imageExpand this image

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

    Collapse this imageExpand this image


Back to the top | Give Feedback

Properties

Article ID: 2629973 - Last Review: March 23, 2012 - Revision: 8.0
Keywords: 
kbstepbystep kbtshoot kbvideocontent KB2629973
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top