Summary: The blog outlines some quick tips to fix ‘We found a problem with some content’ error in Microsoft Excel 2013/2016. It explains manual procedure to resolve the error and also suggests an automated tool to perform the repair process to retrieve all possible data from a corrupt workbook. Show Contents Sometimes, when opening an MS Excel file, you may receive an error message that reads: “We found a problem with some content in ‘filename.xlsx’. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.“ Figure 1 – Excel ‘found a problem with some content’ Error MessageWhat Causes ‘We Found a Problem with Some Content’ Error?There is no clear answer as to what results in the Excel error – ‘We found a problem with some content in <filename.xlsx>’. However, based on some user experiences, it appears that the error occurs due to corruption in an Excel workbook. It may turn corrupt when:
How to Resolve ‘We Found a Problem with Some Content’ Error?Follow these tips to fix the Excel error: IMPORTANT! Before you follow the tips to resolve the Excel error, keep these points in mind: Make sure you have closed all of the opened Excel workbooks. Try restoring Excel file data from the most recent backup copy. If you don’t have a backup copy, make a copy of the corrupt Excel file and perform repair and recovery procedures on that backup copy. Tip1: Repair Corrupt Excel FileFile Recovery mode is a native Excel recovery utility that automatically opens whenever any inconsistencies are found in the worksheet. If Microsoft doesn’t detect any issue or fails to open the File Recovery mode, you can start it manually to recover the corrupt Excel file. To do so, follow the steps below:
If repairing the corrupt Excel file doesn’t work, you can try an Excel file repair tool to fix corruption errors. You can also try to recover data from the corrupt file manually by following the next tips. Read this: What to do when Open and Repair doesn’t work? Tip2: Set Calculation Option to ManualTo make the file accessible, try setting the calculation option in Excel from automatic to manual. As a result, the workbook will not be recalculated and may open in Excel. For this, perform the following:
When the workbook opens, check if it contains all the data. If not, proceed to the next tip. Tip3: Copy Excel Workbook Contents to a New WorkbookSeveral users have reported that they were able to fix ‘We found a problem with some content in <filename>’ error message by copying contents from the corrupt workbook to a separate workbook. Detailed steps are as follows:
Tip4: Use External References to Link to the Damaged WorkbookUse external references to link to the corrupted workbook. By implementing this fix, data contents can be retrieved. However, it is not feasible to recover formulas or calculated values using this solution. Follow the steps below:
This will remove the link to the corrupt workbook and will retrieve data. But, keep in mind, the recovered data will no longer contain formulas or calculated values. Alternative Solution – Stellar Repair for ExcelIf the above manual methods fail to fix the ‘We found a problem with some content in Excel error’, try using the Stellar Repair for Excel software to resolve this error. The software helps repair and recover corrupt Excel files in just a few clicks. It can be used on a Windows 10/8/7/Vista/XP/NT machine to repair a corrupted workbook and recover every single bit of data from all the versions of the Excel workbook. Read this: How to repair corrupt Excel file using Stellar Repair for Excel? ConclusionIn this blog, we discussed some possible reasons behind Microsoft Excel 2013/2016 ‘We found a problem with some content’ error. The error may occur when an Excel file becomes corrupt. You may try repairing the corrupted Excel file manually by using the built-in ‘Open and Repair’ feature. Or, try the manual workarounds to extract data from the corrupt file discussed in this post. If the manual solutions don’t work for you, using Stellar Repair for Excel can come in handy in repairing the corrupt Excel (.xls/.xlsx) file and recovering the complete file data. About The AuthorCharanjeet Kaur Charanjeet is a Technical Content Writer at Stellar®who specializes in writing about databases, e-mail recovery, and e-mail migration solutions. She loves researching and developing content that helps database administrators, organizations and novices to fix multiple problems related to MS SQL and MySQL databases and Microsoft Exchange. |