Navigate to Data Tab > Queries & Connections > Edit Links.To check and confirm if external links are causing the error, follow these steps, When the Excel file contains external links with error, MS Excel may display such error messages. In case the error is not fixed, you can back up the faulty sheet content and remove it from the workbook to save the Excel file. This method makes the entire process of troubleshooting Excel formula reference error quite easy and convenient. This will help you find the faulty sheet from the workbook that you can review. To find the faulty sheet and fix the problem, you can copy each sheet content in a new Excel file and then try to save the Excel file.

The problem may also occur due to an issue with one of the sheets in the workbook. If the error message persists, proceed to the next method. In such a case, you can try saving the Excel file again. The error check is completed for the entire sheet.

If no issue is found, it displays the following message, This runs a scan on the sheet and displays the issues, if any.Go to Formulas and click on the ‘Error Checking’ button.To run Error Checking in the Excel sheet, follow these steps, In such cases, you can use the Error Checking option that runs a scan and checks for a problem with formulas used in the worksheet. If the problem has occurred in a large Excel workbook with multiple sheets, it’s quite hard to pinpoint the problem cell. Methods to Resolve ‘Excel Found a Problem with One or More Formula References in this Worksheet’ Errorįollowing are a few methods that you can follow to fix Excel file that can’t be saved due to problems with one or more formula references in the worksheet. Empty or no values in named or range cells.Incorrect object linking or link embedding OLE.Reasons for Excel Formula References ErrorĪ few reasons that may lead to such error are as follows, In any case, resolving the error is critical as it doesn’t let you save the file and may result in loss of information from the Excel workbook. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.’ ‘Excel found a problem with one or more formula references in this worksheet. However, it may also occur due to incorrect reference to a wrong cell or object linking, which is not working. If you are experiencing the ‘Excel found a problem with one or more formula references in this worksheet’ error message in the Excel workbook, it indicates that the Excel file is corrupt or partially damaged.

Turn off formulas in excel for mac