Repair an Excel File
If you're having problems with an Excel file, using the built in repair feature might fix the problem. This can help when data validation drop down arrows don't appear, or there are other signs of corruption.
- Close the file
- In Excel, choose File►Open
- Locate and select the file
- Click the arrow at the right of the Open button
- Click on Open and Repair
- When prompted, click the Repair button.
This might save the file, and if not, you can follow the same steps, but click Extract Data instead, to retrieve as much of the data as possible. And remember to make backup copies of your work!