AutoSave vs. AutoRecover
AutoSave automatically saves your files to your OneDrive and SharePoint account.
This also allows you to “co-edit” documents with others.
AutoRecover temporarily keeps changes in a directory on your gear.
Available since Office 2007, it does not automatically back up your files.
It saves this information on a set interval, usually 10 minutes, but it’s only temporary.
Neither of these is a replacement for the Save command.
Get in the habit of saving your work consistently, especially when you’re about to close.
It’s essential to configure both AutoSave and AutoRecover if you have both options.
If you’re using Excel 2010 or later, you’ll find this menu in the same place.
Open Excel and selectFile>Options.
In the menu that opens, selectSaveon the left.
If you have a OneDrive or SharePoint account, selectAutoSave OneDrive and SharePoint Online files by default on Excel.
Only enable this for password-protected files.
Never share sensitive information such as Social Security numbers or financial data via a OneDrive or SharePoint file.
SelectSave AutoRecover informationand choose the interval at which you’d like to save it.
Make a note of where Excel will save these files.
If you prefer a more accessible location, you might write it out here.
You also may be unable to change the file path if you’re not an administrator.
What If My Version of Excel Doesn’t Have AutoSave?
Before using these services, think carefully about potential security and space.
If you’re backing up confidential information, there’s an inherent risk of a breach.
Look at your needs carefully before signing on to any backup service.
