Save options

Save workbooks

Save files in this format      Sets the default file format that is used when you save workbooks. If your workbooks are used in different versions of Microsoft Office Excel, as Web pages, or in other programs, you can select the file format that you most frequently use. In this list box, click the file format that you want to use.

Save AutoRecover information every      Automatically creates a workbook recovery file at the interval that you enter in the minutes box. The interval must be a positive number from 1 to 120. If your computer stops responding, or if you lose power unexpectedly, the AutoRecover file opens the next time that you start Excel. The AutoRecover file may contain unsaved information that would otherwise be lost from your original workbook. If your original workbook was damaged, you may be able to recover information from the AutoRecover file.

Important: AutoRecover does not replace the Save command. You must still save your workbook when you finish working on it.

AutoRecover file location     Displays the default AutoRecover file location. In the text box, type the path that you want to use as the AutoRecover file location.

Default file location     Displays the default file location. In the text box, type the path that you want to use as the default file location. If you want to type a path to a network server location for the default file location, enter the path by using the UNC syntax: \\servername\foldername. You must restart Excel to apply the new default file location to a network server.

Autorecover exceptions for

AutoRecover exceptions for     Lets you specify the workbook for which you want to disable or enable AutoRecover. In this list box, select the workbook that you want.

Disable AutoRecover for this workbook only     Disables the AutoRecover feature for the workbook that you select in the AutoRecover exceptions for list box.

Offline editing options for document management server files

Save checked-out files to    Specifies the location where you want to save checked-out workbooks.

• The server drafts location on this computer    Uses the server drafts location on this computer to save checked-out files.

• The web server    Uses the Web server to save checked-out files.

Server drafts location     Displays the default server drafts location. In the text box, type the path that you want to use as the server drafts location, or click Browse to locate the server drafts location.

Browse    Lets you browse to the server drafts location.

Preserve visual appearance of the workbook

Choose what colors will be seen in previous versions of Excel    Lets you edit the color palette that is used when the active workbook is opened in an earlier version of Excel. Click Colors to change colors on the Color tab of the Color dialog box.

Note: Some current Excel features (such as gridlines and comment indicators) also use this color palette and may be affected by the changes that you make.