![]() A popup may appear when you go to reopen the backup, but you can simply select “Yes” and the file will open. Click OK and save it in the folder of your choice, and you’ll have auto-backups set for that workbook! You’ll see a dialog box that offers the option to Always create backup. Then select Save where you’ll see the AutoRecover option under Saved Workbooks. Then, select Tools in the lower right corner and click General Options.Īlternatively, you can select File and then Options from the menu. Unlike AutoSave and AutoRecover, you can allow auto-backups for specific workbooks of your choosing.Ĭlick File on the Ribbon and then select Save As. If it’s turned off, click it to turn it back on, and AutoSave will be enabled: Create Backups for Peace of MindĪuto-backup is a feature that makes a copy of the file each time you save it, and it’s one of the best ways to keep your data safe.īy allowing auto-backups, you’ll have a saved version of your last workbook even if your system crashes. Note that on some versions of Excel (like Excel for Mac), you’ll see a button that says AutoSave in the top left-hand corner of the Excel window. Feel free to change the length of time between AutoSaves if you want to!īy enabling the feature below as well, you can restore versions of your workbook that weren’t saved before Excel was closed. You’ll notice that “Save AutoRecover information” has an option to change the number of minutes. Make sure the “Save AutoRecover information” box and “Keep the last AutoRecovered version if I close without saving” box are both checked.When the Options dialog box opens, select Save in the left pane.After opening Excel, select File and Options.Both features are enabled by default, but just in case they’ve been disabled for you, this is how to get them working again: That’s because Excel uses AutoSave and AutoRecover to automatically protect your work. How to Prevent Lost Files in Excel by Enabling AutoSave & AutoUpdateĪs you’ve seen by now, Excel does most of the work when it comes to recovering lost files – you just have to know how to find them. You’ll have the choice to save the file under a new name, which is recommended – that way you don’t have to worry about accidentally overwriting it again in the future. To restore the one you want, simply pick it from the list!Īfter clicking your previously saved version, Excel will prompt you to open it with the Restore option. That’s where you’ll find your previous versions of the workbook. Here’s how to do it!įirst, navigate over to the File tab. So, what you want is to get the previous file back. Nearly everyone has accidentally overwritten a spreadsheet with updates only to realize later that they actually need the original file. Sometimes, unresponsive pages and premature application closing aren’t to blame for the loss of important files. Restore an Excel File to a Previous Version Keep in mind that just like the last method, this one only works when AutoSave is enabled. All you’ll need to do is select the file you want to restore! All unsaved Excel files should be shown in a Document Recovery pane that pops up when Excel was shut down incorrectly. Once everything is working properly again, open up Excel. If you were making changes to an Excel file and didn’t have the chance to save them before having to shut down the program, you’ll need another way to recover an Excel file that was not saved. Recover an Excel File with Unsaved Changes Excel’s built-in AutoSave and AutoRecover functionality make this method pretty easy, so be sure those are enabled. That is all it takes to recover a new Excel file that was not saved. You’ll then be able to select any unsaved file in the Open window. At the bottom of the page, after selecting Recent, click Recover Unsaved Workbooks. ![]() Then, click Open on the File tab on the Ribbon. To restore your new file without any saved updates, open Microsoft Excel first. ![]() Recover a New Excel File That Was Not Saved Most of the time, the files can be retrieved either way, but the best method for recovering unsaved Excel files will differ based on your goal. There are two very common scenarios in which files get lost: either you’re working on a new file that was never saved before, or you’re unable to save updates made to an existing file. But, the good news is that not all is lost! There are a few ways to recover an Excel file that was not saved, and you can usually do so in just a few steps. Have you ever worked on an Excel project for hours, only for all of that effort to be lost because of one power outage that shut down your system? Everyone knows the panic that sets in when they’ve accidentally deleted important work. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |