If you do not use online services this lets you remove these options.

By default when you select Save As you are shown additional options for Microsoft 365 and OneDrive. Show additional places for saving, even if sign-in may be required - (Added in 2013). This lets you go straight to the Open or Save dialog boxes instead. By default when you press (Ctrl + O) or (Ctrl + S) the backstage view is displayed. Unfortunately there is no folder browse button so you have to copy and paste the folder path.ĭon't show the Backstage when opening or saving files with keyboard shortcuts - (Added in 2013). In the text box, type the path that you want to use as the AutoRecover file location. Keep the last AutoRecovered version if I close without saving -ĪutoRecover file location - Displays the default AutoRecover file location. If your original workbook was damaged, you may be able to recover information from the AutoRecover file.

The AutoRecover file may contain unsaved information that would otherwise be lost from your original workbook. If your computer stops responding, or if you lose power unexpectedly, the AutoRecover file opens the next time that you start Excel.

The interval must be a positive number from 1 to 120. Save AutoRecover information every - Automatically creates a workbook recovery file at the interval that you enter in the minutes box. In this list box, click the file format that you want to use. 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. Save files in this format - Sets the default file format that is used when you save workbooks. There is also an AutoSave Feature for regular files. This option is application specific and is not a general settings across Word and PowerPoint. This toggles AutoSave for All files and requires restarting the application.

AutoSave OneDrive and SharePoint Online by default on Excel - (Added in 365).

Excel 2016 save as options