Microsoft Excel is an extremely useful app that has been helping users to easily organize their data (in text or numbers) for years. It allows you to easily create spreadsheets, perform critical calculations, insert charts and graphs, share your workbook, and more using built-in templates, saving you tons of time.
However, when the Excel file gets corrupted, it can get really frustrating. You may not be able to properly access your important data when you want to. Such problems can lead to data loss and hence it can be a big headache. How can you fix this problem and recover the lost data? Let's see how.
Method 1: How to repair corrupt Excel file in Windows 10 and recover lost data using repair option
Step 1: Click the Windows icon on your desktop and type Excel in the search box. Click on the result to open a blank Excel spreadsheet .
Step 2: Once Excel is open, click on the File option at the top left corner of the spreadsheet to open the context menu.
Step 3: Now click Op de > double click This PC on the right .
Step 4: Double-clicking will open the This PC window . Select the location where you saved the data file and select the saved file. We saved it to Desktop , so we clicked Desktop and selected the file. Now under the File name option at the bottom of the window click on the drop down arrow where you see Open .
Step 5 : From the drop-down menu, choose Open and Repair .
Step 6 : A Command Prompt will open with three options- Repair , Extract Data and Cancel . Choose Repair .
Step 7: It will take a moment for the file to be repaired. Then the file will open with a message that the repair has been completed. Click Close and your saved Excel file will now be repaired and opened with the data.
Method 2: How to fix corrupt Excel file in Windows 10 and recover lost data using data extractions
Step 1: Open a new Excel spreadsheet and follow the same instructions from Step 2 to Step 5 in Method 1 . Once the prompt appears, click Extract Data .
Step 2: Another Command Prompt will open with two options- Convert to Value and Restore Formulas . Here we have selected Convert to value .
Step 3: Another prompt will appear to confirm that the data extraction has been completed. Click Close to access your saved Excel data now .
You are done with repairing and recovering your lost data. You can now easily access your saved Excel data.
แสดงความคิดเห็น