When you open a workbook of 97-2003, Excel 2013 enters the compatibility mode-indicated on the title bar-where it decontaminates the new configurations which cannot be indeed shown or converted by preliminary versions. When you save a workbook, Excel 2013 saves Excel 97-2003 files in their older format using compatibility mode. The workbook stays in compatibility mode until you convert it to the Excel 2007-2013 file format. Excel 2007, Excel 2010, and Excel 2013 use the same file format, so you don’t need to convert files between them. Show Convert an Excel 97-2003 to Excel 20131. Open the Excel 97-2003 workbook you want to convert to the Excel 2007-2013 file format. The Excel 97-2003 workbook opens in compatibility mode. 2. Click the File tab, and then click Info. 3. Click Convert. 4. Click OK to convert the file to the Excel 2007-2013 format. Excel exits compatibility mode, which is only turned on when a previous version is in use. Did You Know? You can display extensions in the Save and Open dialog boxes and Recent Documents list. Changing the Windows option also changes Excel. In the Folder Options dialog box on the View tab, clear the Hide Extensions For Known File Types check box. To convert an old xls Excel file to a new xlsx file, you can apply the Save As feature in Excel, but, if there are multiple xls files needed to be converted, how could deal with this task quickly and easily?
Convert multiple xls formats to xlsx formats with Save As function one by oneThe Save As function in Excel can help you convert the old workbook’s xls format to new xlsx format one by one. 1. Open your workbook that you want to convert its format. 2. Click File > Save As, and a Save As dialog will display, specify a folder to place the new format of the file, and then click Save as type drop down list to choose Excel Workbook, see screenshot: 3. Then click Save button to close the dialog, and this Excel format has been converted from xls to xlsx. Tips: With this Save As function, you just only convert one Excel file at a time, if you have hundreds of Excel files need to be converted, this method is not a good choice. Convert multiple xls formats to xlsx formats at once with VBA codeIf you want to convert multiple xls files to xlsx files at once without saving one by one, here, I will talk about a VBA code for you, please do with the following steps: 1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window. 2. Click Insert > Module, and paste the following code in the Module Window. VBA code: Convert multiple xls formats to xlsx formats at once
3. Then, press F5 key to run this code, and a window will be displayed, please select a folder which contains the xls files that you want to convert, see screenshot: 4. Then,click OK, another window is popped out, please select a folder path where you want to output the new converted files, see screenshot: 5. And then, clik OK, after finishing the conversion, you can go to the specified folder to preview the converted result, see screenshots: Convert multiple xls formats to xlsx formats at once with a powerful featureWith this Kutools for Excel’s Format Converter utility, you can convert multiple xls formats to xlsx formats or vise versa, it also can help you convert multiple workbooks to PDF files at one. Note:To apply this Format Converter, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily. After installing Kutools for Excel, please do as this: 1. Click Kutools Plus > Workbook > Format Converter, see screenshot: 2. And a promt box will pop out to remind you must close the workbook that you want to convert. See screenshot: 3. Click OK, then, in the File Format Converter dialog, specify the following options:
4. After inserting the xls files, still in the File Format Converter dialog box, please click Notes: In the above dialog box:
5. Then click OK to start converting, after finishing the conversion, you can go to the specific folder to preview the converted result. See screenshots: How to convert an Excel 97If 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.
How do I convert Excel 97If the file is already in 97-2003 format, it will open it 'compatibility mode' when you open the file in Excel 2010. You can edit this file in Excel 2010, save it, and work on the same file in Excel 97. Working in compatibility mode will ensure that the format of the file (97-2003) is retained.
How to convert Excel 97Open the Excel 97-2003 workbook. The Excel 97-2003 workbook opens in compatibility mode. Click the Office button, and then click Convert. Click OK to convert the file to new Excel 2007 format.
How do I convert multiple old Excel files to a new version?Click File > Save As, and a Save As dialog will display, specify a folder to place the new format of the file, and then click Save as type drop down list to choose Excel Workbook, see screenshot: 3. Then click Save button to close the dialog, and this Excel format has been converted from xls to xlsx.
|