Microsoft Excel 97 2003

In Microsoft Excel 97 for Windows, Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003, text files that contain more than 65,536 rows cannot be opened in their entirety. You cannot open these files because these versions of Microsoft Excel are limited to 65,536 rows. If you save your Excel files in 97-2003 format (.xls instead of the new.xlsx format), users who do not have Excel 2007 or later installed on their computer, can still open your Excel files.

Most of the time, you’ll probably want to save your workbooks in the current file format (.xlsx). But sometimes, you might need to save a workbook in another file format, like the file format of an earlier version of Excel, a text file, or a PDF or XPS file.

Just keep in mind that whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved. • Open the workbook you want to save. • Click File >Save As. • Under Places, pick the place where you want to save the workbook. For example, pick OneDrive to save it to your Web location or Computer to save it in a local folder like your Documents. • In the Save As dialog box, navigate to the location you want. • In the Save as type list, click the file format you want.

Click the arrows to scroll to file formats that aren’t visible in the list. NOTE: The file formats you’ll see vary, depending on what type of sheet is active in your workbook (a worksheet, chart sheet, or other type of sheet). • In the File name box, accept the suggested name or type a new name for the workbook. Convert an Excel 97-2003 workbook to the current file format If you opened an Excel 97-2003 workbook but don’t need to keep it in that file format, simply convert it to the current file format (.xlsx). • Click File >Info.

• Click Convert. File formats that are supported in Excel Excel file formats Format Extension Description Excel Workbook.xlsx The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).

Strict Open XML Spreadsheet.xlsx An ISO strict version of the Excel Workbook file format (.xlsx). Excel Workbook (code).xlsm The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm). Excel Binary Workbook.xlsb The binary file format (BIFF12) for Excel 2007-2013. Template.xltx The default file format for an Excel template for Excel 2007-2013. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).

Template (code).xltm The macro-enabled file format for an Excel template in Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm). Excel 97- Excel 2003 Workbook.xls The Excel 97 - Excel 2003 Binary file format (BIFF8). Excel 97- Excel 2003 Template.xlt The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template. Microsoft Excel 5.0/95 Workbook.xls The Excel 5.0/95 Binary file format (BIFF5). XML Spreadsheet 2003.xml XML Spreadsheet 2003 file format (XMLSS).

XML Data.xml XML Data format. Excel Add-In.xlam The XML-based and macro-enabled Add-In format for Excel 2007-2013. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (. Abc Software Kids. xlm).

Excel 97-2003 Add-In.xla The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects. Excel 4.0 Workbook.xlw An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Excel 2013, but you cannot save an Excel file to this file format.