These tools simply check if there have been any changes in the file and save the prior version. You can also get the version history options for Excel files with storage options such as Dropbox and Google Drive. Using Third-Party Tools such as DropBox or Google Drive In case your Excel files are not on OneDrive or SharePoint, you will still see the ‘Save As’ option. This is why you now have the ‘ Save a Copy‘ option, which you can use to create a copy and then make the changes. But this isn’t possible with AutoSave enabled where it’s saving your work every few seconds.
When AutoSave is enabled and your work is being saved every few seconds, it won’t be possible to make some changes and save it as a new file.įor example, if you start with an old file, work on it for 20 minutes and save a copy, you will have the old file as well as the new file with 20 minutes of latest work. Instead, you see the ‘Save a Copy’ option ( more on this here) When you enable AutoSave and save the file in OneDrive or SharePoint, you will notice that you no longer see the ‘Save as’ option. In case you don’t see the ‘Automatically Save’ option in the drop-down, click on More Command and use the Excel Options dialog box to add the AutoSave option in the QAT.
#Turn on autosave in word 2018 mac code#
When AutoSave is enabled (with files saved on Onedrive or SharePoint), you won’t see a prompt to save unsaved changes when you close the file (since these changes are being saved every few seconds).Īlso, in case you’re adding a VB Code (macro) to the File, AutoSave would stop and will show you a prompt to save this file as a Macro-enabled fike (.xlsm format)ĪutoSave now enables Excel users to share files and make changes in real-time. In case you’re not the administrator, you may not be able to change this. You can change this location if you want.