Save an excel file as both a .xlsm and .xlsx in Excel VBA? XLSX, What means the last X? The workbook is used by a grounds maintenance company to track work and services done on … ... the newer versions of Excel save and open XLS files for the sake of compatibility with earlier versions of the program. Is there a macro which saves these files automatically without manually opening these files. On the day IT department made the announcement, they reminded users to save file as old formats (e.g.… I was one of the very few who felt excited about the change. The main difference between the two is that XLSX is an XML-based open file format and XLS is a proprietary Microsoft format. I have the same problem - Excel will allow you to view and edit a dbf, but won't let you save it back as .dbf. Dear Friends, I have 350 .lst separate files. Import it into Access and then export it as a .dbf. Let's bring the Excel file from stone age back to modern world. The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Online, and Excel for Mac. Save: When you create or edit a workbook, you'll use the Save command to save your changes. Prior to Excel 2007, the default file extension was XLS. It's not there in Excel 2016. In fact it's a language where all the data are ordered. I have my file run every morning, and it saves as a .xlsm. This is something I would only do temporarily to save a file using a different delimiter. Just want to “fix” or convert a different format ? If you've got Excel, you've probably got Access also. I need to save these files as .xls files after performing the "Delimited" action and formatting the file as per the attachment. Save an Excel workbook for compatibility with earlier versions of Excel. Post a reply. 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. Hit OK. Now the default save format option for Excel documents will be as a xls file. Follow these steps: Click File > Export > Change File Type. Here are the most commonly use Excel File format..xlsx Excel File Format: This is the default Excel File format, when we save the file in Excel 2016 this will save as .xlsx file format. These files are saved in a particular folder. Example 1 you can use in Excel 97-2016 , Example 2 you can use in Excel 2000-2016. Whenever you create a new workbook in Excel, you'll need to know how to save it in order to access and edit it later. Open Excel 2016, click on File and select Options. [Solved] Save a file as Excel. Example 1 you can use in Excel 97-2016 , Example 2 you can use in Excel 2000-2016. I have a macro (posted below) that saves the current workbook with a new filename.