In section ( 3) you can browse for the corrupt or damages Excel worksheet. Also, you can jump into a specific step if you need to change something. In section ( 2) you can track the stage of operation. In section ( 1) is the top menu bar where you can find options like selecting single or multiple files to repair and recover. Note: Tool’s main screen is marked to get a better understanding of easy to use software. Download and launch the latest version of The Software.Here click Values (under Paste Values).īy pasting values, you remove the links to the corrupted workbook leaving only the data only.Įasily Recover Excel Worksheet Data using this Softwareįollow the steps below to recover data from corrupt or damaged Excel Worksheets: Click on Home, and then on the arrow below Paste.Click on Home, and select Copy again (on the same selection of cells).Now select (start from the cell A1) an area equal to that of the data in the original workbook.Again, select the cell A1, click on Home and select Copy.Select the relevant sheet in the Select Sheet dialog (if it appears) sheet.Select the corrupted workbook, in the Update Values dialog (if it appears).Under New, select Blank workbook.In the first cell (A1), type =!A1 and press Enter.Now, right-click on the file name of the corrupted workbook and click on Copy. Navigate to the folder that contains the corrupted workbook.Another way is to recover only the data (leaving formulas/calculated values) from the workbook using external references (to link Excel workbook) as:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |