how to check for corrupted files or bugs and fix them

If you have enabled the automatic backup feature of an Excel file, you can easily restore the workbook from the backup if the file is mistakenly deleted or corrupted. Recover the Excel File from the Backup Copy Let CHKDSK check the hard drive to fix possible errors and mark possible bad sectors. Next, type chkdsk /f /r command, for instance, chkdsk i: /f /r, and press Enter.

Press Windows + R, type cmd, and press Ctrl + Shift + Enter to open elevated Command Prompt.

Or you can run the Windows CHKDSK utility to check and fix disk errors. If it is due to a disk error that prevents you from opening an Excel spreadsheet, you can try to move the file to another hard drive and try to open it again. Remove any possible malware or virus on your computer and try to open the Excel file again. You can run a malware/virus scan for the problematic Excel file and your computer by using your antivirus software. The Excel file cannot open issue may be caused by malware/virus. Run a Virus Scan for the Excel File and Your Computer If it doesn’t fix the file by using Repair, you can select Extract Data to extract values and formulas from the Excel workbook.

Click Repair to repair the spreadsheet.

Click the drop-down icon next to the Open button and choose the Open and Repair option.

In the pop-up window, you can go to the location or directory that contains the corrupted Excel file.

Click File tab and click Open -> Browse in Excel.

Open the Microsoft Excel app or create a new Excel file and open it.

If you can’t open an Excel workbook or the Microsoft Excel app detects corruption when opening an Excel file, you can try to use Excel’s Open and Repair feature to manually repair the corrupted Excel file. Repair Corrupted Excel Files with Open and Repair Some free online Excel file repair tools are also included.

If an Excel file is corrupted and can’t open, you can restart your computer and try to open the file again or try the 8 ways in this post to repair the corrupted/damaged Excel file for free. Possible Causes for Excel File Corruption.How to Recover Deleted/Lost Excel Files for Free Repair Corrupted Excel File with Recovery Toolbox for Excel Create a Recovery File for Excel Workbook at Set Intervals

How to check for corrupted files or bugs and fix them