Excel Error Codes

How to Fix the Excel We Found a Problem with Some Content Error

WPS Content Manager Oct 9, 2026 871 views

Question details

The user needs to fix an error message preventing an Excel workbook from opening properly due to detected problems with its content.

How to Fix the Excel 'We Found a Problem with Some Content' Error

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening an Excel workbook containing complex data, queries, pivot tables, or features affected by shared access.
Observed behavior: Excel repeatedly displays the prompt 'We found a problem with some content' and struggles to load the spreadsheet normally.

Before you start

Create a duplicate copy of the problematic workbook and save it to a different location on your computer before attempting any repair or recovery steps.

Solution 1Recommended

Diagnose the Issue in Excel Safe Mode

Running Excel in Safe Mode disables third-party add-ins and custom settings, helping you identify what is triggering the content error.

Often, incompatible features, damaged Power Query connections, or problematic add-ins cause Excel to misread workbook content. Testing the file in Safe Mode isolates the application from these external variables.

Force Excel into Safe Mode

Press and hold the 'Ctrl' key on your keyboard while double-clicking the Excel application shortcut or the problematic document. Click 'Yes' when prompted to start in Safe Mode.

Check Version and Build Number

Go to File > Account > About Excel. Record your Microsoft 365 version and build number, which can be useful if you need to report the issue to IT support.

Identify the Trigger

Try opening the file. If it opens successfully in Safe Mode, navigate to File > Options > Add-ins to disable them one by one. Check if Power Query, Pivot Tables, or concurrent editing features are the source of the crash.

Restore a Backup if Necessary

If the file still fails to open correctly even in Safe Mode, the corruption may be severe. Locate and restore a known-good backup version of the file.

Testing a Working File: You should also test a known working Excel workbook. If the working file opens without errors, the issue is strictly isolated to the corrupted workbook.

Solution 2

Use the Open and Repair Feature

Excel has a built-in repair utility that can scan and fix minor structural damage within a workbook.

Free Microsoft Office alternative

Try WPS Office to Open Problematic Spreadsheets

If Microsoft Excel continues to struggle with file corruption or specific content errors, WPS Office Spreadsheet provides a lightweight, highly compatible alternative. It seamlessly handles .xlsx files and can often recover and open spreadsheets that trigger stringent content errors in Microsoft Office.

1. Download and Install: Visit the official WPS Office website to download and install the free software suite.
2. Launch the Application: Open WPS Office and select the Spreadsheet module from the main dashboard.
3. Open the File: Go to Menu > Open, and select your problematic Excel file. WPS Office's engine may successfully bypass the content error and display your data.

Excellent compatibility with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture handles complex tables, pivot tables, and large datasets smoothly.Familiar user interface requires no learning curve, allowing for a seamless migration.Free to download and use, significantly reducing your software overhead costs.

Frequently Asked Questions

Why does Excel say it found a problem with some content?

This error generally occurs when the workbook contains structural corruption, incompatible features, damaged Power Query links, broken pivot tables, or when issues arise from network interruptions during a shared editing session.

Can third-party add-ins cause Excel content errors?

Yes. Outdated or conflicting third-party COM add-ins can interfere with how Excel reads a file. Opening the workbook in Safe Mode (holding Ctrl while launching) disables these add-ins and helps isolate the issue.

How can I recover data if the Excel repair fails?

If the 'Repair' option fails, use the 'Extract Data' function found in the same 'Open and Repair' drop-down menu. Alternatively, you can try opening the file in a compatible third-party application like WPS Office to salvage the raw data.

Microsoft Office Error Codes