Table of Contents
About the Author
Reviews and Awards
- Video Recovery
- SD Card Recovery
- Recycle Bin Recovery
- Recover Data from USB
- Recover Deleted Emails
- Hard Drive Not Showing Up in Windows
- Recover Unsaved Word Documents
- Recover Deleted Files
- Recover Files from Virus Infected Hard Drive
- Best Free Photo Recovery Software
- Recover Files from Formatted Hard Drive
Excel Found a Problem with One Or More Formula References!
"One of my least favorite messages that Excel provides is: Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct. But I can never find bad references. It's usually buried somewhere very deep, in a chart series formula, or a name definition, or who knows where else".
If you are experiencing the error - Excel found a problem with one or more formula references in this worksheet in the Excel workbook, it indicates that the Excel file is corrupt or partially damaged. Resolving the error is critical as it doesn't let you save the file and may cause Excel data loss.
Here are some methods that you can follow to fix the error "Excel found a problem with one or more formula references in this worksheet".
Workable Solutions | Step-by-step Troubleshooting |
---|---|
Isolate the Spreadsheet Tab | Copy your tabs from the old workbook to a new one. Keep checking which tab...Full steps |
Run Excel Repair Software | Download, install and launch EaseUS Data Recovery Wizard. Go to the software's home screen and...Full steps |
Check Formulas in Excel | Go to Formulas and click on the "Error Checking" button. This runs a scan...Full steps |
Check the External Links | Go to the "Data" Tab. In the Connections group, click on "Edit Links". It opens...Full steps |
Other Workable Solutions |
Check Your Charts...Full steps Check Pivot Tables...Full steps |
Solution 1. Isolate the Specific Spreadsheet Tab
The first thing you need to do is isolate the specific Excel sheet. If you have a file with lots of tabs, you may want to start by isolating the specific tab to solve the case. It's easy to isolate the tab.
Step 1. Copy your tabs from the old workbook to a new one.
Step 2. Keep checking which tab in the new workbook throws the error message.
Step 3. Click "Save" after copying each of the tabs. The error message usually appears at the time of saving the event. Then, you can find the problematic tab.
This will help you find the faulty sheet from the workbook that you can review. In case you can't fix the error, back up the specific sheet and remove it after the backup.
Solution 2. Run Excel Repair Software to Repair Excel Files
If Method 1 can't solve the error - Excel found a problem with one or more formula references in this worksheet, you can turn to advanced Excel repair software. EaseUS Fixo Document Repair is a powerful tool that can repair corrupt Word documents, Excel files, PPT files, and PDFs. Follow the steps below to recover and repair Excel files.
Step 1. Download and launch Fixo on your PC or laptop. Choose "File Repair" to repair corrupted Office documents, including Word, Excel, PDF, and others. Click "Add Files" to select corrupted documents.
![add files to repair documents with Fixo](/images/en/data-recovery/file-repair/fixo-document-repair-step1.png)
Step 2. To repair multiple files at once, click the "Repair All" button. If you want to repair a single document, move your pointer to the target file and choose "Repair". You can also preview the documents by clicking the eye icon.
![select documents to repair](/images/en/data-recovery/file-repair/fixo-document-repair-step2.png)
Step 3. Click "Save" to save a selected document. Select "Save All" to save all the repaired files. Choose "View Repaired" to locate the repaired folder.
![save repaired documents in Fixo](/images/en/data-recovery/file-repair/fixo-document-repair-step3.png)
Solution 3. Check Formulas in Excel to Fix Excel Errors
Small and silly formula errors in Excel can also lead to big consequences. To avoid such a case, it's advised to check your formula and make it error-free.
Step 1. Go to Formulas and click on the "Error Checking" button
Step 2. This runs a scan on the sheet and displays the issues.
If no issue is found, it displays the following message:
"The error check is completed for the entire sheet."
Then, you can try to save the Excel file again. If the error message persists, proceed to the next method.
Solution 4. Check the External Links
The next option to solve this issue is to find the external links that have errors. Follow the steps below to check out the external links containing errors:
Step 1. Go to the "Data" Tab.
Step 2. In the Connections group, click on "Edit Links". It opens the Edit Links dialog box will list all the workbooks that are being referenced.
Step 3. Check the links. If you find any faulty link, remove it and then save the sheet.
Solution 5. Check Your Charts
If you are still experiencing the fault, you can try to review the charts to solve the problem. As you know, if the error is within a chart it will pop up after you have selected the chart or when you are entering the Select Data Source dialog box.
Here is a list of area locations where you need to check for errors.
- In the source data of the chart.
- In each of the chart series formulas present within the Select Data Source dialog box.
- Check for the errors in the horizontal axis formula which is present inside the Select Data Source dialog box.
- Also, check in the chart's Secondary Axis.
- Also check in the linked Axis Labels, Data Labels, or the Chart Title.
Solution 6. Check Pivot Tables
There could be an error in your Pivot Table's Data Source formula. To check Pivot Tables, follow these steps:
Step 1. Go to "PivotTable Tools > Analyze > Change Data Source > Change Data Source…"
Step 2. Check out whether any of your formulas are having the error or not.
Conclusion
This article has provided you with almost all the fixes to troubleshoot this error "Excel found a problem with one or more formula references in this worksheet" error. But the solutions may lead to a partial loss of information. Therefore, you'd better make a backup to external devices in advance.
Was This Page Helpful?
![](/images/en/icon/dany.png)
Dany is an editor of EaseUS who lives and works in Chengdu, China. She focuses on writing articles about data recovery on Mac devices and PCs. She is devoted to improving her writing skills and enriching her professional knowledge. Dany also enjoys reading detective novels in her spare time.
![](/images/en/icon/brithny.jpg)
Brithny is a technology enthusiast, aiming to make readers' tech lives easy and enjoyable. She loves exploring new technologies and writing technical how-to tips. In her spare time, she loves sharing things about her game experience on Facebook or Twitter.
-
EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.
Read More -
EaseUS Data Recovery Wizard is the best we have seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past.
Read More -
EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.
Read More
Related Articles
-
No Bootable Device Error - What Does It Mean, What Cause the Error, How to Fix
Cedric/2023/11/14
-
Recycle Bin Empties Itself: How to Stop Recycle Bin Auto Deletion in Windows 7/8/10
Brithny/2023/07/20
-
Data Recovery Software Full Version Free Download (in 2023)
Tracy King/2023/07/20
-
How to Undo ESD-USB and Convert It to Normal
Tracy King/2023/10/31