Automatically Save File Before Closing using VBAĪutoSave is a new feature in Excel Office 365, while AutoRecover has been in prior versions as well.ĪutoSave allows you to save your work in real-time when you save your Excel files in OneDrive or SharePoint.Using Third-Party Tools such as DropBox or Google Drive.Adding AutoSave to QAT (for Office 365).Turn On AutoSave in Excel from the Options Dialog box.