{"id":67405,"date":"2020-11-24T06:19:08","date_gmt":"2020-11-24T06:19:08","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=67405"},"modified":"2025-06-25T16:49:51","modified_gmt":"2025-06-25T16:49:51","slug":"fix-excel-found-a-problem-with-formula-references-in-this-worksheet","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/","title":{"rendered":"Fix: Excel &#8220;Found a problem with formula references&#8221;Error"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>If you are experiencing the &lsquo;Excel found a problem with one or more formula references in this worksheet&rsquo; error message in the Excel workbook, it indicates that the<a href=\"https:\/\/www.stellarinfo.com\/blog\/what-to-do-when-excel-file-is-corrupted\/\" target=\"_blank\" rel=\"noreferrer noopener\"> Excel file is corrupt<\/a> or partially damaged. However, it may also occur due to incorrect reference to a wrong cell or object linking, which is not working. The complete error message says,<\/p><p><em>&lsquo;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.&rsquo;<\/em><\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"705\" height=\"113\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-problem-with-formula-reference.png\" alt=\"Excel found a problem with one or more formula references\" class=\"wp-image-67410 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-problem-with-formula-reference.png 705w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-problem-with-formula-reference-300x48.png 300w\" sizes=\"auto, (max-width: 705px) 100vw, 705px\" \/><\/figure><p>In any case, resolving the error is critical as it doesn&rsquo;t let you save the file and may result in loss of information from the Excel workbook.<\/p><h2 class=\"wp-block-heading\" id=\"reasons-for-excel-formula-references-error\">Reasons for Excel Formula References Error<\/h2><p>A few reasons that may lead to such error are as follows,<\/p><ul class=\"wp-block-list\">\n<li>Wrong formula or reference cell<\/li>\n\n\n\n<li>Incorrect object linking or link embedding OLE<\/li>\n\n\n\n<li>Empty or no values in named or range cells<\/li>\n\n\n\n<li>Multiple Excel files (not common)<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"methods-to-resolve-&lsquo;excel-found-a-problem-with-one-or-more-formula-references-in-this-worksheet&rsquo;-error\">Methods to Resolve &lsquo;Excel Found a Problem with One or More Formula References in this Worksheet&rsquo; Error<\/h2><p>Following are a few methods that you can follow to fix Excel file that can&rsquo;t be saved due to problems with one or more formula references in the worksheet.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-1-check-formulas\">Method 1: Check Formulas<\/h3><p>If the problem has occurred in a large Excel workbook with multiple sheets, it&rsquo;s quite hard to pinpoint the problem cell. 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.<\/p><p><strong>To run Error Checking in the Excel sheet, follow these steps,<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Go to Formulas and click on the &lsquo;Error Checking&rsquo; button<\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"431\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-error-checking-1024x431.png\" alt=\"Error Checking in the Excel sheet\" class=\"wp-image-67409 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-error-checking-1024x431.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-error-checking-300x126.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-error-checking-768x323.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-error-checking.png 1389w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>This runs a scan on the sheet and displays the issues, if any. If no issue is found, it displays the following message,<\/li>\n<\/ul><p><em>The error check is completed for the entire sheet.<\/em><\/p><p>In such a case, you can try saving the Excel file again. If the error message persists, proceed to the next method.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-2-check-individual-sheet\">Method 2: Check Individual Sheet<\/h3><p>The problem may also occur due to an issue with one of the sheets in the workbook. 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.<\/p><p>This will help you find the faulty sheet from the workbook that you can review. This method makes the entire <a href=\"https:\/\/www.stellarinfo.com\/blog\/excel-formulas-not-working-properly\/\" target=\"_blank\" rel=\"noreferrer noopener\">process of troubleshooting Excel formula<\/a> reference error quite easy and convenient.<\/p><p>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.<\/p><h3 class=\"wp-block-heading\" id=\"h-method-3-check-links\">Method 3: Check Links<\/h3><p>When the Excel file contains external links with errors, MS Excel may display such error messages. To check and confirm if external links are causing the error, follow these steps,<\/p><ul class=\"wp-block-list\">\n<li>Navigate to <em>Data Tab &gt; Queries &amp; Connections &gt; Edit Links<\/em><\/li>\n\n\n\n<li>Check the links. If you find any faulty link, remove it and then save the sheet<\/li>\n<\/ul><h3 class=\"wp-block-heading\" id=\"h-method-4-review-charts\">Method 4: Review Charts<\/h3><p>You can review the charts to check if they are causing the formula reference error in Excel. It may take a while based on the size of the Excel file. Sometimes, it&rsquo;s not practically possible to track down which Excel chart object is causing the error. Thus, you need to check specific locations, such as:<\/p><ol style=\"list-style-type:1\" class=\"wp-block-list\">\n<li>Check horizontal axis formula inside Select Data Source dialog box<\/li>\n\n\n\n<li>Check Secondary Axis<\/li>\n\n\n\n<li>Check linked Data Labels, Axis Labels, or Chart Title<\/li>\n<\/ol><h3 class=\"wp-block-heading\" id=\"h-method-5-check-pivot-tables\">Method 5: Check Pivot Tables<\/h3><p>To check Pivot Tables, follow these steps,<\/p><ul class=\"wp-block-list\">\n<li>Navigate to <em>PivotTable Tools &gt; Analyze &gt; Change Data Source &gt; Change Data Source&hellip;<\/em><\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"84\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-Edit-Links-1024x84.png\" alt=\"Edit links\" class=\"wp-image-67408 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-Edit-Links-1024x84.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-Edit-Links-300x25.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-Edit-Links-768x63.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-Edit-Links-1536x126.png 1536w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/MS-Excel-Edit-Links.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Check if any of the formula used is problematic. Sometimes small typo, such as misplaced comma, can lead to such problems in Excel. Thus, check each formula thoroughly and correct the formulas wherever needed.<\/li>\n<\/ul><h3 class=\"wp-block-heading\" id=\"h-method-6-use-excel-repair-software\">Method 6: Use Excel Repair Software<\/h3><p>When none of the methods resolve the error, then you can rely on advanced <a href=\"https:\/\/www.stellarinfo.com\/repair-excel-file.php\" target=\"_blank\" rel=\"noreferrer noopener\">Excel repair software<\/a>, such as Stellar Repair for Excel. It&rsquo;s a powerful tool that is recommended by several MVPs and IT administrators for resolving common Excel errors, such as &lsquo;Excel found a problem with one or more formula references in this worksheet.&rsquo;<\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/public\/image\/catalog\/screenshot\/excel-repair\/stellar-repair-for-excel-main-interface.png\" alt=\"Stellar Repair for Excel\"><\/figure><p>It repairs corrupt or damaged Excel (.xls\/.xlsx) files, recovers Pivot tables, charts, etc., and save them in a new Excel worksheet. It helps Excel users, facing formula reference error, restore their Excel file without any risk of data loss, while preserving the sheet properties and formatting with 100% precision.<\/p><h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2><p>Although the error &lsquo;Excel found a problem with one or more formula references in this worksheet&rsquo; can be resolved by using various options in MS Excel, it may lead to a partial loss of information. Thus, you must perform these operations after taking a backup of the Excel worksheet. Also, if the MS Excel options fail to resolve the problem, you can use an Excel file repair software, such as <a href=\"https:\/\/www.stellarinfo.com\/repair-excel-file.php\">Stellar Repair for Excel<\/a>. The software helps fix Excel file corruption and restores the information and data from corrupt or damaged Excel files (.xls\/.xlsx) to a new worksheet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are experiencing the &lsquo;Excel found a problem with one or&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\">Continue reading <span class=\"screen-reader-text\">Fix: Excel &#8220;Found a problem with formula references&#8221;Error<\/span><\/a><\/p>\n","protected":false},"author":32,"featured_media":67605,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-67405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-file-repair","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Resolve Excel \u201cProblem with One or More Formula References\u201d<\/title>\n<meta name=\"description\" content=\"Facing the \u2018Excel found a problem with formula references\u2019 error? Our step-by-step guide helps you identify and fix it fast.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resolve Excel \u201cProblem with One or More Formula References\u201d\" \/>\n<meta property=\"og:description\" content=\"Facing the \u2018Excel found a problem with formula references\u2019 error? Our step-by-step guide helps you identify and fix it fast.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/facebook.com\/raavisingh\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-24T06:19:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-25T16:49:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ravi Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/ravi51ngh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ravi Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\"},\"author\":{\"name\":\"Ravi Singh\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/7dea10d15c0307370e21d7da07d0cd11\"},\"headline\":\"Fix: Excel &#8220;Found a problem with formula references&#8221;Error\",\"datePublished\":\"2020-11-24T06:19:08+00:00\",\"dateModified\":\"2025-06-25T16:49:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\"},\"wordCount\":863,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg\",\"articleSection\":[\"MS Office File Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\",\"name\":\"Resolve Excel \u201cProblem with One or More Formula References\u201d\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg\",\"datePublished\":\"2020-11-24T06:19:08+00:00\",\"dateModified\":\"2025-06-25T16:49:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/7dea10d15c0307370e21d7da07d0cd11\"},\"description\":\"Facing the \u2018Excel found a problem with formula references\u2019 error? Our step-by-step guide helps you identify and fix it fast.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Excel Found A Problem with One Or More Formula References in This Worksheet\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fix: Excel &#8220;Found a problem with formula references&#8221;Error\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/7dea10d15c0307370e21d7da07d0cd11\",\"name\":\"Ravi Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9e95cad83fe279b559794f62193f34300d01db8f9f2ec45ce529b7ecde3796ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9e95cad83fe279b559794f62193f34300d01db8f9f2ec45ce529b7ecde3796ba?s=96&d=mm&r=g\",\"caption\":\"Ravi Singh\"},\"description\":\"Ravi Singh is a Senior Writer at Stellar\u00ae. He is an expert Tech Explainer, IoT enthusiast, and a passionate nerd with over 7 years of experience in technical writing. He writes about Microsoft Exchange, Microsoft 365, Email Migration, Linux, Windows, Mac, DIY Tech, and Smart Home. Ravi spends most of his weekends working with IoT (DIY Smart Home) devices and playing Overwatch. He is also a solo traveler who loves hiking and exploring new trails.\",\"sameAs\":[\"https:\/\/stellarinfo.com\/blog\",\"https:\/\/facebook.com\/raavisingh\",\"https:\/\/instagram.com\/ravi.s1ngh\",\"https:\/\/linkedin.com\/in\/ravi-singh-5a65356a\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/ravi51ngh\",\"https:\/\/youtube.com\/ravisingh9\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/ravi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resolve Excel \u201cProblem with One or More Formula References\u201d","description":"Facing the \u2018Excel found a problem with formula references\u2019 error? Our step-by-step guide helps you identify and fix it fast.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/","og_locale":"en_US","og_type":"article","og_title":"Resolve Excel \u201cProblem with One or More Formula References\u201d","og_description":"Facing the \u2018Excel found a problem with formula references\u2019 error? Our step-by-step guide helps you identify and fix it fast.","og_url":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/","og_site_name":"Stellar Data Recovery Blog","article_author":"https:\/\/facebook.com\/raavisingh","article_published_time":"2020-11-24T06:19:08+00:00","article_modified_time":"2025-06-25T16:49:51+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg","type":"image\/jpeg"}],"author":"Ravi Singh","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/ravi51ngh","twitter_misc":{"Written by":"Ravi Singh","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/"},"author":{"name":"Ravi Singh","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/7dea10d15c0307370e21d7da07d0cd11"},"headline":"Fix: Excel &#8220;Found a problem with formula references&#8221;Error","datePublished":"2020-11-24T06:19:08+00:00","dateModified":"2025-06-25T16:49:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/"},"wordCount":863,"commentCount":1,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg","articleSection":["MS Office File Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/","url":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/","name":"Resolve Excel \u201cProblem with One or More Formula References\u201d","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg","datePublished":"2020-11-24T06:19:08+00:00","dateModified":"2025-06-25T16:49:51+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/7dea10d15c0307370e21d7da07d0cd11"},"description":"Facing the \u2018Excel found a problem with formula references\u2019 error? Our step-by-step guide helps you identify and fix it fast.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-Found-A-Problem-with-One-Or-More-Formula-References-in-This-Worksheet.jpg","width":1000,"height":600,"caption":"Excel Found A Problem with One Or More Formula References in This Worksheet"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-excel-found-a-problem-with-formula-references-in-this-worksheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Fix: Excel &#8220;Found a problem with formula references&#8221;Error"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/7dea10d15c0307370e21d7da07d0cd11","name":"Ravi Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9e95cad83fe279b559794f62193f34300d01db8f9f2ec45ce529b7ecde3796ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9e95cad83fe279b559794f62193f34300d01db8f9f2ec45ce529b7ecde3796ba?s=96&d=mm&r=g","caption":"Ravi Singh"},"description":"Ravi Singh is a Senior Writer at Stellar\u00ae. He is an expert Tech Explainer, IoT enthusiast, and a passionate nerd with over 7 years of experience in technical writing. He writes about Microsoft Exchange, Microsoft 365, Email Migration, Linux, Windows, Mac, DIY Tech, and Smart Home. Ravi spends most of his weekends working with IoT (DIY Smart Home) devices and playing Overwatch. He is also a solo traveler who loves hiking and exploring new trails.","sameAs":["https:\/\/stellarinfo.com\/blog","https:\/\/facebook.com\/raavisingh","https:\/\/instagram.com\/ravi.s1ngh","https:\/\/linkedin.com\/in\/ravi-singh-5a65356a\/","https:\/\/x.com\/https:\/\/twitter.com\/ravi51ngh","https:\/\/youtube.com\/ravisingh9"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/ravi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/67405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=67405"}],"version-history":[{"count":11,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/67405\/revisions"}],"predecessor-version":[{"id":183347,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/67405\/revisions\/183347"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/67605"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=67405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=67405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=67405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}