MsgBox 'This workbook is being saved automatically: ' & ActiveWorkbook.AutoSaveOn This example turns off AutoSave and notifies the user that the workbook is not being automatically saved. You can also take steps as a developer to mitigate these problems so that your add-ins and macros work smoothly, even if AutoSave is enabled. You can do this on the user’s behalf by using the AutoSaveOn property in Word, Excel, and PowerPoint if it's available (see the following example). In general, these issues can be avoided if the user chooses to disable AutoSave. Because of this, add-ins and macros that leverage these events may experience problems when AutoSave is on. When AutoSave is enabled, these events fire automatically on a periodic basis without user interaction. Excel also provides an AfterSave event that can execute macro or add-in code after the save completes.

If AutoSave is turned off, save must be triggered manually for the user's changes to be persisted in the cloud and for this user to receive others' changes.Ĭurrently, Excel, Word, and PowerPoint provide a BeforeSave event that allows a developer to execute code after the user triggers a save but before the save occurs. When the file is shared with others, their changes are merged into this user's version of the file. When a file is hosted in the cloud (that is, OneDrive, OneDrive for Business, or SharePoint Online), AutoSave enables the user's edits to be saved automatically and continuously.

Learn about how AutoSave works in Excel, PowerPoint, and Word, and how it can impact add-ins or macros.

How do i turn on autosave in word