On the File menu, select Save As. In the Save as Type list, select a file format other than the current file format . If you are using Microsoft Excel 2007 or a later version, save the file as .xlsx or .xlsm instead of as .xls. Try to save the workbook to another location.
Our chosen answer was when you save an Excel workbook for the first time or use the “Save As” function, you are asked for a folder, file name as well as the file type. By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros). The window looks similar to the screenshot on the right side. So which file type are you going to use?
The most common answer is: you can save an Excel 2007 or later workbook in the file format of an earlier version of Excel, in a text file format, and in other file formats, such as PDF or XPS. By default, files are saved in the. Xlsx file format, but you can change the default file format for saving. Where can I download free Excel templates?
How do I save my work as a spreadsheet?
The default is to save your work on your own computer (This PC), in the My Documents folder: If you’re happy to save your work in the My Documents folder, then type a name in the text box that says “Enter file name here”. Click the Save button to the right and your file will saved as a XLSX spreadsheet.
You could be asking “How do I save a workbook in Excel 2013?”
The most common answer is, for a list of file formats (also called file types) you can (and can’t) open or save in Excel 2013, see File formats that are supported in Excel at the end of this article. Open the workbook you want to save. Under Places, pick the place where you want to save the workbook.
What file formats can I save in Excel 2007?
You can save any file format that you can open in Excel 2007 and later in the current Excel Workbook file format (.xlsx). By doing this, you can use new features that are not supported by other file formats.
How do I save an Excel workbook in a different file format?
To save your workbook in a different file format (like .xls or .txt), in the Save as type list (under the File name box), pick the format you want. When you’re done saving your workbook, you can “pin” the location you saved to.
While I was researching we ran into the inquiry “How do I change the save file format in Excel?”.
In all other Excel versions: click File > Options. In the Save category, under Save Workbooks, in the Save files in this format list, click the file format that you want to use. Tip: For more information, see File formats that are supported in Excel.
What file format should I use for my Excel macros?
The default Excel format if macros are used in your model. An Excel macro-enabled workbook. The file information is stored in binary format rather than as XML documents. This file format is approximately twice as fast as .xlsx at opening and saving Excel workbooks. This is particularly useful for very large files (greater than 10MB).
This begs the query “What is an Excel file format?”
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 2010, but you cannot save an Excel file to this file format. Spreadsheet saved in Microsoft Works 6.0-9.0. Note: This format is supported in Excel Starter only. Lotus space-delimited format.