#MICROSOFT EXCEL VERSIONS HOW TO#
#MICROSOFT EXCEL VERSIONS PC#

Just click Yes and you can restore a previous version of your spreadsheet.Ĭreate time-stamped backup versions in Excel 2010 - 2016 When you open it, Excel will ask you to verify that you really want to open this workbook. A backed up copy is saved with different. Excel will create a backup copy of the document in the same folder. Now you can rename your file and choose the desired location to save it. Check the Always create backup box in the General Options dialog and click OK.Select General Options… from the drop-down list.When the Save As dialog window pops up, click on the small arrow next to the Tools button at the bottom of the window.Select Computer and click on the Browse button.Though this feature is very helpful, it is hard enough to find in Excel 2010 - 2016. As a result, you will have the current saved information in the original workbook and all previously saved information in the backup copy. Saving a backup copy can protect your work if you accidentally save changes that you do not want to keep or delete the original file.

#MICROSOFT EXCEL VERSIONS HOW TO#

How to save a backup copy of your workbookĮxcel's Auto Backup is a very useful feature that can help you retrieve a previously saved version of your workbook. If you want to look at the previous version again, it is better to create a backup copy of your data. Excel deletes all previously autosaved versions when you close the document. Just click on the Restore button in the yellow bar to revert to the newer unsaved version of the workbook. When you open this file in Excel, you'll get the message above your worksheet. If the program closed incorrectly, the last autosaved file is labeled with the words (when I closed without saving). When you click any of them, it will open along with the most current version of your workbook so that you can compare them and see all the changes. The name of each version has a date, time and the ' (autosave)' note. Next to the Manage Versions button you'll see all autosaved versions of your document.Įxcel automatically saves versions of the workbook at specified intervals, but only if you've made changes to your spreadsheet between these intervals. See below how to retrieve an overwritten Excel file:Ĭlick on the FILE tab and choose Info on the left-hand pane. It is especially helpful when you make a mistake that you can't undo, or when you want to see how the document looked like a few minutes earlier. Click on the Save As button in the yellow bar above your worksheet and save the file to the desired location.Įxcel 20 make it possible not only to restore the unsaved workbooks, but also to recover previous versions of your document. The document will open in Excel and the program will prompt you to save it. When the Open dialog box pops up, just select the necessary file and click Open.You can also go to FILE - > Info, open the Manage Workbooks drop-down and select Recover Unsaved Workbooks from the menu. It allows you to restore to the last saved version which displays in the Document Recovery pane when you start Excel next time. It helps you not to lose important data in case of a computer crash or power failure.Įxcel AutoRecover helps you retrieve unsaved files after an accidental closure or crash. But these two features are often misunderstood, so at first let's define what they mean.Įxcel AutoSave is a tool that automatically saves a new document that you've just created, but haven't saved yet.

If they are enabled, it won't be a problem for you to recover unsaved files and restore previous versions in Excel 2016 - 2010.

Create time-stamped backup versions in Excel 2010 - 2016Įxcel provides us with such good features as AutoSave and AutoRecover.

How to save a backup copy of your workbook.

If you want to know how to retrieve an overwritten Excel file, go ahead and read this article. What is the worst that could be? While working on a workbook you found out that you made a mistake about an hour ago, you already made a lot of changes since that time and undo is not an option. That is frustrating, but don't be so cut up about it - you can easily recover your unsaved document. Just imagine that you have been working on a very important document in Excel for some hours, creating a very complicated graph, and then… oops! Excel crashed, the power went out or you accidentally closed a file without saving.

#MICROSOFT EXCEL VERSIONS PC#

You'll also learn different ways of file backup on your PC or in the cloud. Do you want to protect your workbooks from unexpected computer crashes or power failures? This article explains how to recover unsaved files and restore previous versions of your workbook in Excel 2016, 2013, and 2010.

Microsoft excel versions