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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Do you want page breaks displayed on the screen? Excel allows you to specify whether it should show those page breaks or not.
Discover MoreSome formulas require the use of circular references in order to determine a result. If you want to make sure that ...
Discover MoreDoes the pale coloring scheme used to mark selected cells by Excel 2007 drive you nuts? You aren't alone. Here's an idea ...
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