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

122 Document Recovery to the Rescue
If you still want to have access to all the features in the Excel 2013 workbook but you still need to create a backwardly compatible version of the work- book file (even if it has less fidelity), first save the workbook in the XML file format with the .xlsx file extension. Then, save a copy in old 97-2003 binary file format with the .xls file extension by opening the Save As dialog box (File➪Save As or Alt+FA) and then selecting Excel 97-2003 from the Save as Type drop-down list before clicking the Save button.
Keep in mind that filename extensions such as .xlsx and .xls do not appear as part of the filename (even though they are appended) in the File Name text box in the Save As dialog box unless you’ve removed the check mark from the Hide Extensions for Known File Types check box found on the View tab of the Folder Options dialog box (Tools➪Options) in the Windows Explorer window.
Document Recovery to the Rescue
Excel 2013 offers a document recovery feature that can help you in the event of a computer crash because of a power failure or some sort of operating system freeze or shutdown. The AutoRecover feature saves your work- books at regular intervals. In the event of a computer crash, Excel displays a Document Recovery Task pane the next time you start Excel after rebooting the computer.
When you first start using Excel 2013, the AutoRecover feature is set to auto- matically save changes to your workbook (provided that the file has already been saved) every ten minutes. You can shorten or lengthen this interval as you see fit. Choose File➪Options➪Save or press Alt+FTS to open the Excel Options dialog box with the Save tab selected. Use the spinner buttons or enter a new automatic save interval into the Save AutoRecover Information Every 10 Minutes text box before clicking OK.
The Document Recovery Task pane shows the available versions of the workbook files that were open at the time of the computer crash. It identi- fies the original version of the workbook file and when it was saved, along with the recovered version of the file and when it was saved. To open the recovered version of a workbook (to see how much of the work it contains that was unsaved at the time of the crash), position the mouse pointer over the AutoRecover version. Then click its drop-down menu button and click Open on its pop-up menu. After you open the recovered version, you can (if you choose) then save its changes by clicking the Save button on the Quick Access toolbar or by choosing File➪Save.