By Allen Wyatt for Excel.Tips.Net
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:
1. Display the Excel Options dialog box. (If you are using Excel 2007 click the Office button and then click Excel Options. If you are using Excel 2010 display the File tab of the ribbon and then click Options.)
This post is excerpted with permission from Excel.Tips.Net