![microsoft excel revert spreadsheet microsoft excel revert spreadsheet](https://images.idgesg.net/images/article/2019/07/excel-office365-version-history-2019-07-100806766-orig.jpg)
To delete a comment, right-click the cell containing the comment, and then click Delete Comment on the shortcut menu. To view a comment, click the cell and the comment will pop up. Typically, comments contain the name of the person who created them, and they appear as a small red triangle in the upper-right corner of a cell. Microsoft Excel offers the ability to add comments to workbooks. To selectively edit or remove document data, click File > Info > Properties.
![microsoft excel revert spreadsheet microsoft excel revert spreadsheet](https://cdn.extendoffice.com/images/stories/doc-excel/undo-restore-deleted-sheet/doc-undo-restore-deleted-sheet-0.png)
Edit Document Properties, Personal Information and Other Document Data The Excel Document Inspection window shown below opens up.Ĭlick Inspect to identify hidden content, and then click Remove All to remove the item of your choice.Īfter you have completed these steps, save the document, and the spreadsheet will not contain the hidden data that you have removed. To open the Document Inspector, click File > Info > Check for Issues > Inspect Document. Use the Document Inspector to Remove Hidden Data This Excel repair software can easily repair severely corrupted Excel files and recover all the data in just a few steps.Avoid unintentionally distributing hidden information, such as the document's author, names that are associated with comments or tracked changes, or hidden cells or worksheets, by removing hidden data. If the Open and Repair tool does not work, then you can use advanced Excel repair software, such as Stellar Repair for Excel. Click Extract Data to extract values and formulas from the workbook, if Repair is not able to recover your data.To recover as much as data from the workbook, click Repair.Click the arrow next to the Open tab and click the Open and Repair option.In the Open dialog box, choose the corrupted workbook.However, if the File Recovery mode fails to start, then you can use the Open and Repair utility in Excel to recover the corrupted workbook. When Microsoft Excel detects a corrupted worksheet upon opening, it automatically starts File Recovery mode and starts repairing it. An Excel file may get corrupted due to an abrupt system or program shutdown, system or application crash, etc. If the Excel file doesn’t open, it indicates corruption in the file. Click on the required file from the list of earlier versions.Then, click the Recover Previous Version of Excel File option.In the dialog box that opens, click the Previous Versions option.Right-click on File and select the Properties tab.First, choose the desired file on your system.However, to use this feature, you must have enabled it beforehand. You can also restore the previous version of the Excel file by using the Windows File History feature. Method 3: Use the File History Feature in Windows When the file is open, go to the File tab and select the Save As an option to save the file.Choose the desired file and click Open.If your Excel file is closed without saving, this option can help you to open the file and save it. Manage Workbook is an inbuilt feature in Excel that you can use to recover the previous version of the Excel file. Method 2: Use the Manage Workbook Option in Excel The Document Recovery Pane appears, showing the recovered files.Here are the steps to restore the file using the Document Recovery pane: If your Excel program closes unexpectedly before saving the changes, you can use the Document Recovery pane to restore the file. The Document Recovery pane in Microsoft Excel helps to review, open, and save the recovered files. Method 1: Use Document Recovery Pane in Excel Methods to Restore Previous Version of Excel Fileįollow the below-listed methods to restore the previous version of the Excel file using the inbuilt functions of Excel and Windows. In this article, we’ll mention different ways to restore the previous version of the Excel file. If this feature is enabled, it automatically saves the versions of the file. One such feature in the Excel application is the AutoRecover feature. However, there is no need to worry as the Excel program has features that can help you restore such unsaved files. Sometimes, while working on an Excel file, you accidentally close the file or your system shuts down suddenly due to power failure, or the Excel program crashes due to an issue.Īs a result, the file you’re working on will not be saved and you fear losing your data. Methods to Restore Previous Version of Excel File.