Click the Version History button to display the Version History panel next to your current worksheet.Click the File tab in Excel and select Info.If you need to revert to an earlier version of your Excel file: Version History periodically takes a snapshot of your Excel spreadsheet. Recover Unsaved Workbooks button Version History In the Save category, enter an interval in the Save AutoRecover information every xx minutes box ( where xx is the duration you specify).Įxcel Options dialog box Recover Unsaved WorkbooksĪssuming AutoRecover information has been saved, any time you launch Excel and select Open on the left side of your screen, you should see the Recover Unsaved Workbooks button at the bottom of the Recent Files list.Ĭlick Recover Unsaved Workbooks and select the file you’d like to recover.You can configure an interval between 1 and 120 minutes. Saving your files to OneDrive – and using AutoSave – is the simplest and most convenient method to safeguard your data but there is another tool available to help you recover from an unplanned shutdown: AutoRecover.īy default, Excel will save a copy of your current spreadsheet every 10 minutes to a location specified in the Excel Options dialog box. In the Save category, uncheck AutoSave OneDrive and SharePoint Online files by default on Excel.Click the File tab in Excel and select Options to display the Excel Options dialog box.You can turn AutoSave off altogether, if you want to. Sometimes you need to decide whether to save changes to a spreadsheet or not – and you don’t want Excel to save all changes by default. There may be times when it’s not convenient to have Excel automatically save every change you make. AutoSave will remain off for that specific file until you turn it on again.
Next time you open it, AutoSave will still be off. If you decide to turn AutoSave off, Excel will remember your preference for that specific file. Disable AutoSave for an Individual Fileīut what if you want to open an Excel file, make a few changes, then close it without saving? You can turn AutoSave off by clicking the little “switch” on the Quick Access Toolbar. The beauty of AutoSave is, as long as your file is stored on OneDrive, you can open a file, make as many changes as you like, then close Excel – and all of your changes will be saved automatically. AutoSave is not available if you save a file to your desktop, your C: drive, or a shared folder on your company’s network. Autosave is enabled automatically, any time you save a file to OneDrive.
This article includes everything you need to know about AutoSave, AutoRecover, and Version History.īookmark this blog post or forward it to your friends and colleagues – but only if you want to be recognized as an Excel superhero! AutoSaveĪutoSave is a feature in Excel for Office 365 that saves your file every few seconds as your work. Microsoft Excel has several features designed to help you safeguard and recover your data.
0 kommentar(er)
