Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Setting a Default File Format.
Normally, Excel saves your worksheets in the workbook format that is appropriate for the version of the software you are using. This means that your worksheets are stored in a peculiar way that is understood by your version of Excel, but may not be understood by other programs—including earlier versions of Excel.
If you do a lot of work with people who use other versions of Excel or who use a different spreadsheet program, you may want to specify a different default file format for your files. Excel makes this easy; just follow these steps:
Figure 1. The Save option of the Excel Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10480) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Setting a Default File Format.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Press the slash key and Excel may display a series of keyboard commands near the ribbon. If this behavior drives you ...
Discover MoreWhat happens when you press Enter in a cell depends on how you have Excel configured. Here's the way you can control the ...
Discover MoreWhen you right-click a cell, does it seem that the Context menu is missing an item or two? Here's how to get those items ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-12-05 13:14:52
Joseph Bays
I bought a new laptop with Windows 10 OS. When I tried to save Excel 2003, I could not find a way to save it.
2015-06-06 05:35:18
Hello.
Lately I have been generating my pivot tables and when I extract the results onto a new sheet, the first column is set as a date format. I expected tit to be "General"
Can anyone shed any light on why this happens and how do I fix this.
Thank you
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments