How to repair a corrupted workbook in Microsoft Excel 2013 or 2016?
Posted: Nov 28, 2017
Microsoft Excel is an application of MS Office, used to create spreadsheets. You can access the application on your Windows, Mac, iOS and Android operating system. The application features pivot tables, calculation & graphic tools and much more. VBA, Macros, Lookup Formulas, Conditional Formatting are some of the other exciting features of Excel.
If MS Excel detects a corrupted file, it will automatically initiate file recovery mode and tries to recover your workbook. However, if it fails to begin it automatically, you can follow these steps to repair the workbook manually:
- Click File and then Open
- Open the folder containing that corrupted workbook
- Select the corrupted workbook, click the arrow button available just next to Open button
- Now, click Open and Repair
- To recover the data, click Repair
- If it doesn’t works in your favor, click Extract Data to extract values as well as formulas from the workbook
You can also recover the data when you are unable to open the workbook in Excel. Follow the below mentioned steps to do so:
- Set the calculation option in Excel to manual
- Now, open the New from File menu
- Click Blank workbook
- Open Options from File
- Under the Formulas category, pick Manual under Calculation options
- Click OK
- Click File and then Open
- Now, double-click the corrupted workbook to open it
The aforementioned steps will definitely work in your favor. To avoid this situation occur in future, always go for automatic saving of your workbook. If your workbook has a back up, you don’t need to worry when it gets corrupted or deleted accidently. To do so, follow the below mentioned steps:
- Open MS Excel
- Click File and then Save As
- Now, click Computer followed by Browse
- You will see a Save As dialogue box
- Now, click the arrow available next to Tools, and click General Options
- Check Always Create backup box
- It’s done!
Apart from this, you can also choose "Automatically Create a Recovery File at Set Intervals" by following these steps:
- Click File and then Options
- In the Save category, check the SaveRecover Information Every box, which is available under Save Workbooks section
- Now, enter the time duration after which it automatically creates a recovery file
- Once it’s done, go to the AutoRecover File Location, enter the location where you want to save the file
- Ensure that the Disable AutoRecover for this workbook only box is unchecked
If the aforementioned procedure for repairing a corrupted workbook doesn’t work for you, contact Office.com/Setup customer support team and get an instant technical help by a technician. Hope the information was useful!
Lena Smith is the author of this article, she has written various articles on Technical issues.