logo
ResourcesOffice Problem Solved--We Found a Problem with Some Content in Excel

Problem Solved--We Found a Problem with Some Content in Excel

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.

solve-we found a problem with some content in excel

Method 1: Use Open and Repair Function of MS Excel

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.

click Open under File tab

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.

select the file and choose Open and Repair option

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.

select Repair or Extract data option

If this could not work, you can try other methods or using the Excel repair tool to restore the spreadsheet data.

Method 2: Change Automatic Calculation Option into Manual

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.

open new blank workbook

Step 2: Then on the new blank workbook, click on File > Options.

click Options under File tab

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.

set workbook calculation option to manual

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.

Method 3: Quickly Repair the Excel File with iSunshare Excel Repair Genius

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.

click open to select excel file

Step 2: Click the Restore button to repair the excel file with content problem.

click the Restore button

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.

click OK and save the file

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.

open the saved file or not

Related Links: