By Sophia | Last Updated
"When I open the xlsx file from my colleague, only an error message displayed: We found a problem with some content in ‘yyyy.xlsl'. Do you want us to try to recover as much as we can? And when I clicked the Yes button, the problem cannot be solved. Anybody can help me to fix this problem?"
When you get this error message, your excel file is possibly corrupted and cannot be opened. You can try the following 3 methods to fix "We found a problem with some content in excel" error.
You can manually open the Excel file and repair it with MS Excel Open and Repair function.
Step 1: Start Microsoft Excel program and then click the File tab on the left top. After that, select the Open option.
Step 2: Find the excel file that you cannot open and select it. And then click the down arrow behind the Open button and choose Open and Repair from the drop-down menu.
Step 3: Then Microsoft Excel will offer you two options: Repair or Extract Data. You can click Repair to recover as much of your spreadsheet data as possible. Or you can click Extract Data if Excel was previously unable to repair the workbook.
If this could not work, you can try other methods or using the Excel repair tool to restore the spreadsheet data.
If the calculation option of your Excel file is set to automatic, you can change it into manual. It can help to prevent the excel file from recalculating the values so as to make your Excel file accessible.
Step 1: Run MS Excel application and then click on File >New >Blank workbook.
Step 2: Then on the new blank workbook, click on File > Options.
Step 3: From the list of Excel options, click on Formulas and then you can see the Calculation options. Then, change the Workbook Calculation setting to Manual. To apply the change, you need to click the OK button.
Step 4: At last, you can click on File >Open. Then select the corrupt Excel file to check whether it can be opened after the calculation setting changes.
For users who want to repair the corrupted excel file and rescue the excel content, they can use MS Excel repair tool to repair corrupt or damaged Excel file or solve content error in Excel. iSunshare Excel Repair Genius is highly recommended to restore the excel .xlsx file, which can help to preserve the charts, worksheet properties cell comments, and other essential data. What's more importantly, you just need several clicks to get back the original excel file content.
Step 1: Launch iSunshare Excel Repair Genius and click the OK button to select the excel file. And it only supports xlsx file.
Step 2: Click the Restore button to repair the excel file with content problem.
Step 3: The excel file will be restored at once. When the progress ends, a message box would pop out to tell you the file is restored. You can click the OK button to close the box. After that, click the Save button to save the restored file on your computer.
Step 4: In the end, when the file is saved successfully, you will get a prompt to ask whether to open the excel file or not. It all depends on you.
Related Links:
