Creating and Opening Workbooks

Get Microsoft Office help creating blank and template MS Excel 2013 spreadsheets, opening existing ones, and converting files.

Compatibility mode

Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these types of workbooks, they will appear in Compatibility mode.

Compatibility mode disables certain features, so you'll only be able to access commands found in the program that was used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.

In the image below, you can see that the workbook is in Compatibility mode. This will disable some Excel 2013 features, such as sparklines and slicers.

Screenshot of Excel 2013Disabled commands in Compatibility mode

In order to exit Compatibility mode, you'll need to convert the workbook to the current version type. However, if you're collaborating with others who only have access to an earlier version of Excel, it's best to leave the workbook in Compatibility mode so the format will not change.

To convert a workbook:

If you want access to all of the Excel 2013 features, you can convert the workbook to the 2013 file format.

Note that converting a file may cause some changes to the original layout of the workbook.

  1. Click the File tab to access Backstage view.
    Screenshot of ExcelClicking the File tab
  2. Locate and select Convert command.
    Screenshot of Excel 2013Converting the workbook to the newest file type
  3. The Save As dialog box will appear. Select the location where you want to save the workbook, enter a file name for the presentation, and click Save.


    Screenshot of Excel 2013Saving a new version of the workbook
  4. The workbook will be converted to the newest file type.