Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Using Your Own File Extensions.
By default, Excel uses an XLS extension for all workbook files. If you don't want to use the default file extension for a workbook you are saving, you can pick something different. (You may want to use a different extension if you are trying to hide the fact that the file is an Excel workbook.)
If you try to use a different file name extension by including it when you save the file, Excel still appends the XLS extension. For instance, if you explicitly save a file as MyFile.mef, Excel will still save it as MyFile.mef.xls.
If you don't want Excel to do this, then simply enclose your file name in quotes when you save under a new name. Thus, you would use the name "MyFile.mef" (with the quotes) and that is the file name which Excel will use.
In addition, if you save a workbook with a different extension (not one of the defaults used by Excel), then Excel won't show the workbook by default when you use the Open command. To see all your varied-extension files, you need to follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2228) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Using Your Own File Extensions.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!