• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. File > Microsoft Excel Files

3.1. Microsoft Excel Files

With each version of Excel, there have been modifications made to the format that workbooks are saved in. Each version of Excel has been backwards compatible, meaning that it could always open and save in the format of a previous version. Because of this, Excel 2000 can open files from all previous versions of Excel, but, with the exception of Excel 97, earlier versions of Excel will not be able to open Excel 2000 formatted workbooks. Excel 2000 uses the same file format as Excel 97, which is why the two versions are compatible. Excel can also open and save to several other formats, as described later in this section. Unless otherwise stated, Excel has the ability to both open and save in the following specified formats using the File Save As or the File Open options:


Microsoft Excel Files

Saves in a format that can be used by users of both Excel 2000 and Excel 97.


Microsoft Excel 5.0/95 Workbook

Saves the selected workbook in the appropriate format for Excel 5.0/95. Any features that are specific to Excel 97 or Excel 2000 are removed from the workbook when it is saved.


Microsoft Excel 97-2000 & 5.0/95 Workbook

Saves the workbook in a file that can be used by Excel 97-2000 and Excel 5.0/95 users, although, Excel 97-2000 features that exist in the workbook are not available for the Excel 5.0/95 user.


Microsoft Excel 4.0/3.0/2.1 Worksheet

Saves only the first worksheet of the workbook in a format that can be opened by Microsoft Excel 4.0/3.0/2.1 and removes all Excel 97-2000-specific features from the worksheet.


Microsoft Excel 4.0 Workbook

Saves only the worksheets, chart sheets, and macro sheets in the workbook in a format that can be opened by Microsoft Excel 4.0 and removes any Excel 97-2000 specific features.


Microsoft Excel 4.0 Macros

Opens an Excel 4.0 macro sheet.


Microsoft Excel 4.0 Charts

Opens an Excel 4.0 chart sheet.


Templates

Saves the selected workbook in a template format that can be used to create a future workbook.


Microsoft Excel Add-in

Saves the selected workbook so that it can be attached to another workbook as an add-in. When a workbook is saved as an add-in, only the macros in the workbook are accessible.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint