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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |