change default save location for excel for mac

#CHANGE DEFAULT SAVE LOCATION FOR EXCEL FOR MAC HOW TO#
#CHANGE DEFAULT SAVE LOCATION FOR EXCEL FOR MAC UPDATE#

Then click the “Options” command at the left side of the backstage view to open the “Excel Options” window. To stop Excel from automatically enabling AutoSave in Excel for Office 365 for all online files by default, click the “File” tab in the Ribbon.

#CHANGE DEFAULT SAVE LOCATION FOR EXCEL FOR MAC HOW TO#

AutoSave in Excel for Office 365: How to Disable AutoSave in Excel for Office 365

Alternatively, you can simply close the copy of the previous version to exit it without making any changes. You can then either copy content from the saved copy window into the current version’s window, save the previous version as a copy, or click the “Restore” button in the message box to restore the old copy of the file and overwrite the new copy. A message box then appears at the top of the copy of the file, above the Formula Bar, stating that this is a previous version. Doing this then loads the saved version in a separate window. Scroll through the list and then click the version of the file to which to revert the current file. The various file save states appear, sorted by date.

Then click the “View and restore previous versions” link under the “Version History” section to the right.ĪutoSave in Excel for Office 365 – Instructions: A picture of the “Version History” panel you can use to revert changes made to a file with AutoSave enabled in Excel for Office 365.Įither way, the “Version History” panel then appears at the right side of the workbook window. Then click the “Info” command at the left side of the workbook, if necessary. Alternatively, click the “File” tab in the Ribbon. Then select the “Version History” command from the drop-down menu. One way to do this is to click the drop-down at the right end of the file’s title within the Title Bar. However, in addition, you can also revert an online file with AutoSave enabled back to a previous save state. To reverse changes you make to a file with AutoSave enabled, click the “Undo” button in the Quick Access toolbar. AutoSave in Excel for Office 365: How to Undo Changes and Revert to a Previous Save State in AutoSave in Excel for Office 365

However, this is useful for making changes to a copy of the file you don’t necessarily want other users to see when working on the original, shared online file. Therefore, changes you make to the copy do not appear in the original file. However, note that the saved copy is completely separate from the original file. This works the same way as initially saving the file. Doing this then shows the save locations in the area to the right. Then click the “Save a Copy” command at the left side of the backstage view. To make a copy of a file after enabling AutoSave in Excel for Office 365, click the “File” tab in the Ribbon. AutoSave in Excel for Office 365: How to Save a Copy in AutoSave in Excel for Office 365 However, note that you cannot click the “Save” command in the backstage view when AutoSave is enabled.

#CHANGE DEFAULT SAVE LOCATION FOR EXCEL FOR MAC UPDATE#

When you enable AutoSave in Excel for Office 365, you can choose to manually save changes and also update the file with any changes made by other users of the shared file by clicking the “Save” button in the Quick Access Toolbar. AutoSave in Excel for Office 365: How to Manually Save Changes in AutoSave in Excel for Office 365 To toggle AutoSave in Excel for Office 365 on or off for the current workbook, click the “AutoSave” toggle button in the upper-left corner of the workbook window in the Quick Access Toolbar. AutoSave in Excel for Office 365 saves the file to the online location every few seconds as you work. AutoSave in Excel for Office 365 is automatically enabled when you save a workbook using the newest file formats to an online destination, like OneDrive or SharePoint. This tutorial shows you how to use AutoSave in Excel for Office 365. AutoSave in Excel for Office 365: Overview AutoSave in Excel for Office 365: How to Enable AutoSave in Excel for Office 365

Change default save location for excel for mac