recover error in excel sheet

To recover from errors in an Excel sheet and edit the information, you can follow these general steps:

1. Identify the Error: Determine what type of error you are encountering. Common errors include formula errors, data entry errors, or issues with the workbook itself.
2. Check for Corruption: If the file is corrupted, try opening it in Excel's safe mode or using the "Open and Repair" feature. You can access this by going to File > Open, selecting the file, clicking the arrow next to the Open button, and then choosing Open and Repair.
3. Use Previous Versions: If you have enabled AutoRecover, you may be able to restore a previous version of the workbook. Check the File > Info section for any available versions.
4. Edit the Information: Once the error is resolved, you can edit the information in the sheet. Ensure that you are not exceeding Excel's limits, such as the number of rows or columns.
5. Save Your Changes: After making your edits, save the workbook in the desired format (e.g., .xlsx) to ensure that your changes are retained.

If you continue to experience issues, consider looking into specific error messages you receive, as they can provide more context on how to resolve the problem.

References:

• Excel cannot complete this task with available resources
• How to troubleshoot "available resources" errors in Excel

Thanks for sharing the details, Fatima. But just to verify, did you do some changes to your Excel file but an error occurred prior to saving the changes and it went back to the original state before you added changes?

Best regards,

Kimberly