As you already know, a file with .xlsx extension is an open XML Format Spreadsheet file. It’s generally used to retailer monetary knowledge and to create mathematical fashions. Typically, it throws an uncommon error. While you attempt to open it, it reveals We found a problem with some content in filename.xlsx message. By following a few steps, you may override this problem. See how!
We found a problem with some content in filename xlsx
The content error is confronted when the Excel file will get corrupted. So, to repair it, you’ll must –
- Configure Calculation choice to Guide
- Copy XLS to Take away Unreadable Content Error
- Switching to File Restoration mode
1] Configure the Calculation choice to Guide
If the calculation possibility has been set to computerized, change it to guide. Doing so can even forestall the workbook from recalculating the values and this may make file accessible. For this,
Click on on ‘File’ menu of Excel ribbon bar and select ‘New’ possibility from the left-sidebar menu.
Choose ‘Blank’ workbook. When the brand new Excel Workbook opens, once more select the ‘File’ menu, and this time, choose ‘Options’.
Right here, underneath ‘Formulas’ class, choose ‘Manual’ in Calculation choices and click on on OK.
Shut the ‘Options’ display screen, return to the Excel file, click on on File menu once more and select ‘Open’.
Thereafter, navigate to the corrupt workbook after which double-click to open.
2] Copy XLS to Take away Unreadable Content Error
While you get “We found a problem with some content in ” error message, you additionally see one other immediate looking for your permission to try to recuperate as a lot as potential. Should you belief the supply of the workbook, you may proceed additional by clicking ‘Yes’ button.
Then, whereas attempting to open an Excel workbook, attempt to make it ‘read only’ to recuperate its total content.
Comply with the steps-
- Open the Excel workbook in ‘read-only’ mode > strive copying its total contents.
- As soon as performed, create a new workbook and paste your entire contents from the corrupted file you simply copied to the brand new file.
Generally, this trick works!
If the above strategies fail to yield the specified outcomes, you may change to File Restoration Mode as your final resort.
3] Switching to File Restoration Mode
Click on File menu > Open.
Browse to the situation the place the corrupted or broken file is saved. Click on it.
When the dialog field seems, hit the drop-down arrow adjoining to ‘Open’ possibility.
Right here, choose ‘Open and Repair’ possibility.
Additionally, if you wish to recuperate knowledge from the workbook > select Extract Information. This can extract your entire potential formulation and values from the workbook.
As soon as performed, you’ll get a affirmation message.
Did this give you the results you want?
Additionally learn: Repair Excel found unreadable content error.
