How to fix We Found a Problem With Some Content error in Excel

To fix this error message in Excel, you can try some of the methods in the article below.

1. Fix errors in Excel files

Office applications such as Excel have built-in repair features to fix common problems with files in use.

Open Excel, then click File, then select Open , then click on the corrupted file and then click Open and Repair at the Open button as shown below.

How to fix We Found a Problem With Some Content error in Excel Picture 1

2. Turn on manual calculation mode in Excel

By default Excel automatically calculates formulas in your spreadsheet. However, this mode sometimes causes errors in opening or updating files, especially if the file contains large data sets and complex formulas.

In the Excel interface, click File then click Options to adjust.

How to fix We Found a Problem With Some Content error in Excel Picture 2

Switching to the new interface, users click on Formulas then look to the side to find Calculation options and then select Manual to switch to manual mode.

How to fix We Found a Problem With Some Content error in Excel Picture 3

3. Copy content to another Excel file

Another way to fix the We Found a Problem With Some Content error in Excel is to open the Excel work window in read-only mode and copy the content to a new file.

Open the Excel file with the error and then click the Open button and select Open Read-Only to open the file in read-only mode. Then you press the key combination Ctrl + A to copy the entire content and then Ctrl + C to copy. Finally, press Ctrl + N to create a new file and paste the copied content.

How to fix We Found a Problem With Some Content error in Excel Picture 4

4. Restore the old version of Excel

If you saved an Excel file to OneDrive, you can restore the previous version. This will help you undo any changes that may have damaged the file.

Open OneDrive on your computer then right-click on the corrupted Excel file and select Show more options .

How to fix We Found a Problem With Some Content error in Excel Picture 5

Display options, click on Version history to view the history of this file.

How to fix We Found a Problem With Some Content error in Excel Picture 6

We will now see a list of the file's edit history. At the version you want to restore, click the 3-dot icon and select Restore .

How to fix We Found a Problem With Some Content error in Excel Picture 7

Isabella Humphrey

Update 03 August 2024