Press the F5 key to run the code, then a worksheet named backup is created with exactly the same content with the specified worksheet. VBA code: Back up worksheet Sub CreateBackup() In the Microsoft Visual Basic Application window, click Insert > Module, and then copy and paste the below VBA code into the Module window. Stay in the worksheet and keep the original data you want to back up, then press Alt + F11 to open the Microsoft Visual Basic Application window.Ģ. With the following VBA code, you can easily back up the worksheet.ġ. Undo all changes to get back the original data with backupĪnother method for quickly getting back the original data after modifying worksheet is to back up this sheet before modifying. So, to undo all changes in a specified worksheet with this method becomes complex. If the other worksheets in current workbook was modified, changes of these worksheets are listed in the Undo list as well. NOTE: To be sure you don’t lose your latest work, click Save (or press CTRL+S) often.2.
In Word, Excel and PowerPoint, make sure the "Keep the last autosaved version if I close without saving" check box is selected. Make sure the "Save AutoRecover information every x minutes" check box is selected. Here is how to enable AutoRecover and AutoSave to protect your files in Microsoft Office: Windows 7/8 and 10 - C:\Users\User_Name\AppData\Local\Microsoft\Office\UnsavedFiles (you have to be able to see your hidden files). You can also browse to one of the following file locations to open the file, depending on your operating system ( NOTE: These file locations cannot be changed): You will see the list of your unsaved files. Click Recover Unsaved Documents if you are in Word, Recover Unsaved Workbooks if you are in Excel or Recover Unsaved Presentations if you are in PowerPoint. 
Open the Office application you were using.
You can also access these files by using these steps:
In the business bar at the top of the file, click Save As to save your file to your computer. Your saved drafts folder will open in a new window. Scroll to the bottom of your "Recent Documents" (Office 2013 only), then click "Recover Unsaved Documents" if you are in Word, "Recover Unsaved Workbooks" if you are in Excel, or "Recover Unsaved Presentations" if you are in PowerPoint. Open the Office application that you were using. Here are the steps to take to recover your unsaved new document in Microsoft Office Excel, Word, or PowerPoint if you inadvertently close it before saving it: NOTE: These instructions work for both Office 2010 and Office 2013.
0 kommentar(er)
