![]() Revert the workbook to the last saved version If a workbook becomes corrupted while you work but before you save your changes, you can revert your workbook to the last saved version:ĭouble-click the name of the workbook that you have open in Excel. Recover data when the workbook is open in Excel Important: If a disk error or network error prevents you from opening a workbook, move the workbook to a different hard disk drive or a local disk before trying any of the following recovery options. You can also try third-party software solutions to try to recover workbook. If it’s not successful, try another method. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time.Īutomatically save a backup copy of a workbookĪutomatically create a recovery file at set intervalsĬhoose one of the following methods to help recover your data. If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook. To recover as much of the workbook data as possible, pick Repair. In the Open dialog box, select the corrupted workbook.Ĭlick the arrow next to the Open button, and then click Open and Repair. If File Recovery mode doesn’t start, try using this manual process to recover your workbook:Ĭlick the location and folder that contains the corrupted workbook. ![]() When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |