Page 139 - Excel 2013 All-in-One For Dummies

The very generic Documents folder may not be the place on your hard drive where you want all the new workbooks you create automatically saved. To change the default file location to another folder on your computer, follow these steps:
1. Choose File➪Options➪Save or press Alt+FTS to open the Save tab of the Excel Options dialog box.
The Default File Location text box displays the directory path to the cur- rent default folder.
2. Click the Default File Location text box to select the current directory path.
When you click the Default File Location text box, Excel selects the entire directory path so that if you begin typing, the characters you type replace the entire path. To edit part of the path (such as the Documents folder name after your user name), click the mouse or Touch pointer at that place in the path to set the Insertion point.
3. Edit the existing path or replace it with the path to another existing folder in which you want all future workbooks to automatically be saved.
4. Click OK to close the Excel Options dialog box.
Saving a new workbook in the old file format
Excel 2013 automatically saves each new workbook file in a Microsoft ver- sion of the XML-based file format, which carries the filename extension .xlsx. The problem with this XML file format is that it’s not one that versions of Excel prior to Excel 2007 can open. This means that if every- body who needs to work with the workbook you’ve just created hasn’t yet upgraded to Excel 2007 or 2010, you need to save the new workbook in the earlier file format used in versions 97 through 2003 with the old .xls file- name extension.
To save a new workbook in the old binary Excel file format for back compat- ibility, be sure to click the Save as Type drop-down button and then select Excel 97-2003 Workbook from the drop-down list.
Excel automatically displays the Excel Compatibility Checker dialog box whenever you try to save a workbook file containing Excel 2013 features that aren’t supported in earlier versions of the program from Excel 97 through 2003. This dialog box lists each incompatible feature in the workbook and gives you details on what will happen to the feature if you go ahead and save the workbook file in the older file format. To ignore these warnings and go ahead and save your workbook in the 97-2003 binary format, click the Continue button in the Excel Compatibility Checker dialog box.
Saving the Data 121
Book II Chapter 1
Building Worksheets