{"id":466,"date":"2025-06-30T07:40:08","date_gmt":"2025-06-30T07:40:08","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=466"},"modified":"2025-07-02T19:15:43","modified_gmt":"2025-07-02T19:15:43","slug":"9-top-fixes-solutions-excel-formulas-not-working-error","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error","title":{"rendered":"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Undoubtedly, Microsoft Excel provides several functions to analyze, audit, and calculate data. Some of the formulas are frequently used by users by a small group of statistical specialists. Formulas make the work easy for maintaining and carrying out complex calculations as well. But what if <strong>Excel formulas not working? <\/strong>Well, it&#8217;s a very frustrating issue, but it can be fixed by applying the solutions mentioned in this post.<!--more--><\/p>\n<p>So, let\u2019s delve deep into this post\u2026<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover Excel sheet data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>Why Are My Excel Formulas Not Working?<\/strong><\/h2>\n<p style=\"text-align: justify;\">The formula not working in Excel due to numerous reasons, including incorrect syntax, data inconsistencies, or referencing errors. However, such problems should be fixed as soon as you can to streamline your data analysis and improve productivity.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Fix Formulas Not Working in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">The occurrence of <strong>Excel formula not working<\/strong> issue returns the wrong results or sometimes errors too. So, in this section, you will get an idea of how to fix silly mistakes usually made at the time of creating Excel formulas.<\/p>\n<h3 style=\"text-align: left;\"><strong>1. Enter Numbers Without Any Formatting<\/strong><\/h3>\n<p style=\"text-align: justify;\">While using the Excel formula, don\u2019t add a currency sign eg: $ or \u20ac or a decimal separator.<\/p>\n<p style=\"text-align: justify;\">Note: in the Excel formulas, a sign of comma is generally used to separate the function of arguments. Whereas, the sign of dollar is for making an absolute cell reference.<\/p>\n<p style=\"text-align: justify;\">So, you can put a numeric value like this, 50000, instead of putting data like this $50,000. All in all, I just want to say in your Excel formula simply use the numeric value.<\/p>\n<h3 style=\"text-align: left;\"><strong>2. Numbers shouldn&#8217;t be formatted as text values<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another very common reason for the Excel formula not working is that numbers are formatted as text values. It may look like a normal number but MS Excel considers it as a text string and doesn&#8217;t include it in the calculations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2979 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Check-the-Cell-Format-for-Text-1024x560-1.png\" alt=\"Make sure numbers are not formatted as text values\" width=\"705\" height=\"386\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Check-the-Cell-Format-for-Text-1024x560-1.png 1024w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Check-the-Cell-Format-for-Text-1024x560-1-300x164.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Check-the-Cell-Format-for-Text-1024x560-1-768x420.png 768w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Check-the-Cell-Format-for-Text-1024x560-1-600x330.png 600w\" sizes=\"auto, (max-width: 705px) 100vw, 705px\" \/><\/p>\n<p style=\"text-align: justify;\">Visual indicators of a text editor are like this:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Numbers that are formatted as &#8220;text&#8221; will by default, get left-aligned while formal numbers are aligned right in the cells.<\/li>\n<li style=\"text-align: left;\">You will see that on the Home tab&gt; number group, the number format box is selected with <strong>Text <\/strong>option.<\/li>\n<li style=\"text-align: left;\">When many cells having text numbers have been selected from the worksheet you will see that the Status Bar will only show the <em>Count. whereas <\/em>generally, it displays the count, sum, and average of numbers.<\/li>\n<li style=\"text-align: left;\">You will see a green triangle shape in the cell&#8217;s top-left corner or a leading apostrophe visible in the formula bar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-472\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Make-sure-numbers-are-not-formatted-as-text-values.png\" alt=\"make-sure-numbers-are-not-formatted-as-text-values\" width=\"582\" height=\"186\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Make-sure-numbers-are-not-formatted-as-text-values.png 582w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Make-sure-numbers-are-not-formatted-as-text-values-300x96.png 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/p>\n<p style=\"text-align: justify;\">To fix this, just select all the problems having cells and then tap on the yellow warning sign. After that select, the option <strong>Convert to Number<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-471\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/excel-convert-to-number-1.png\" alt=\"excel-convert-to-number\" width=\"282\" height=\"193\" \/><\/p>\n<p style=\"text-align: justify;\">But in some cases, neither the green triangles nor the warning signs seem in the cells. Then in that case go to the <strong>Home tab &gt; <em>Number<\/em> group &gt;number format box<\/strong>. if this shows the text, then clear all the formatting of the cells having the issue. after then set the format of the cell either general or number.<\/p>\n<p style=\"text-align: justify;\">But if it still won\u2019t work then make a new column and enter the data manually. Means just copy down your text to the notepad and then paste it on your Excel sheet. At the end, delete all broken columns.<\/p>\n<h3 style=\"text-align: left;\"><strong>3. Match All Opening And Closing Parentheses\u00a0 In A Formula<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2956 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/check-opeing-and-clcosing-parenthesis.png\" alt=\"Match all Opening and Closing Parentheses\u00a0 in a Formula\" width=\"713\" height=\"350\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/check-opeing-and-clcosing-parenthesis.png 713w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/check-opeing-and-clcosing-parenthesis-300x147.png 300w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/p>\n<p style=\"text-align: justify;\">Generally, arguments of the Excel functions are kept under parentheses and in complex formulas; you may need to put more than a single set of parentheses. When making such complex formula make sure that you have opened and closed the parentheses properly.<\/p>\n<p style=\"text-align: justify;\">Well, Excel shows parentheses pair in some different colors when you use it in the formula. Suppose your formula is lacking with some parentheses then Excel will display the error and allow you to correct it by balancing the pair. And due to this, users start getting <strong>Excel Formulas Not Working <\/strong>error message.<\/p>\n<h3 style=\"text-align: left;\"><strong>4. Put All The Required Arguments Within The Excel Function<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2957 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Enter-all-Required-Arguments-in-an-Excel-Function.png\" alt=\"Enter all Required Arguments in an Excel Function\" width=\"423\" height=\"371\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Enter-all-Required-Arguments-in-an-Excel-Function.png 423w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Enter-all-Required-Arguments-in-an-Excel-Function-300x263.png 300w\" sizes=\"auto, (max-width: 423px) 100vw, 423px\" \/><\/p>\n<p style=\"text-align: justify;\">Each Excel function has single or multiple required arguments. If you are entering optional arguments then enclosed it in the [square brackets] in your formula&#8217;s syntax. So, the formula must have all the necessary arguments. Or else your Excel will display the following <strong>&#8220;<em>You&#8217;ve entered too few arguments for this function<\/em>&#8221; <\/strong>warning message.<\/p>\n<p style=\"text-align: justify;\">If the entered arguments are more than the required one then you will encounter with following <strong>\u201c<em>You&#8217;ve entered too many arguments for this function&#8221; <\/em><\/strong>warning message.<\/p>\n<h3 style=\"text-align: left;\"><strong>5. Include The Full Path To A Closed Workbook<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2958 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Include-the-Full-Path-in-excel.png\" alt=\"Include the Full Path in excel\" width=\"391\" height=\"245\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Include-the-Full-Path-in-excel.png 391w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Include-the-Full-Path-in-excel-300x188.png 300w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><\/p>\n<p style=\"text-align: justify;\">If you are using a formula that references a closed Excel workbook, then your external reference must include the workbook name and the entire path to the workbook. For example:<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>=SUM(&#8216;D:\\Reports\\[Sales.xlsx]Jan&#8217;!B2:B10)<\/strong><\/p>\n<\/blockquote>\n<h3 style=\"text-align: left;\"><strong>6. Don&#8217;t Nest More Than 64 Functions Within A Formula<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2959 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Multiple-IFs-in-Excel.png\" alt=\"Do not Nest more than 64 Functions in a Formula\" width=\"728\" height=\"401\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Multiple-IFs-in-Excel.png 728w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Multiple-IFs-in-Excel-300x165.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Multiple-IFs-in-Excel-600x330.png 600w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/p>\n<p style=\"text-align: justify;\">If you are nesting more than two Excel functions with each other for example suppose to create a nested IF formula. Then follow these limitations:<\/p>\n<ul style=\"text-align: justify;\">\n<li>In Excel 2016\/2013\/2010\/2007, you can make use of max 64 nested functions.<\/li>\n<li>While in Excel 2003 and lower, you can only make use of a maximum of 7 nested functions.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>7. Don&#8217;t Enclose Numbers In Double Quotes<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2960 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Do-not-Enclose-Numbers-in-Double-Quotes-in-excel-formula.png\" alt=\"Do not Enclose Numbers in Double Quotes in excel formula\" width=\"392\" height=\"200\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Do-not-Enclose-Numbers-in-Double-Quotes-in-excel-formula.png 392w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Do-not-Enclose-Numbers-in-Double-Quotes-in-excel-formula-300x153.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/p>\n<p style=\"text-align: justify;\">In the Excel formula, the value encoded within the double quotes is counted as a text string.<\/p>\n<p style=\"text-align: justify;\">That means, if you enter an Excel formula like<strong>=IF(A1&gt;0, &#8220;1&#8221;)<\/strong>, then Excel will consider 1 as a text, and thus you won\u2019t be able to make use of the returned 1&#8217;s in any other calculations. So, don&#8217;t put the double quotes and always write the formula for numeric value, don\u2019t enclose numbers in double-quotes until and unless you want it to count as text.<\/p>\n<h3 style=\"text-align: left;\"><strong>8. Enclose Workbook And Worksheet Names In Single Quotes<\/strong><\/h3>\n<p style=\"text-align: justify;\">When referring to other worksheets or workbooks that have spaces or <strong>non-alphabetical characters<\/strong>\u00a0in their names, enclose the names in single quotation marks.<\/p>\n<p>For example, Reference to another sheet:<br \/>\n<strong>=SUM(&#8216;Jan Sales&#8217;!B2:B10)<\/strong><\/p>\n<p>Reference to another workbook:<br \/>\n<strong>=SUM(&#8216;[2015 Sales.xlsx]Jan sales&#8217;!B2:B10)<\/strong><\/p>\n<h3 style=\"text-align: left;\"><strong>9. Use Right Charcter For Separating The Function Argument<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2961 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Separate-Function-Arguments-with-a-Proper-Character.png\" alt=\"Separate Function Arguments with a Proper Character\" width=\"542\" height=\"185\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Separate-Function-Arguments-with-a-Proper-Character.png 542w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Separate-Function-Arguments-with-a-Proper-Character-300x102.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/h3>\n<p style=\"text-align: justify;\">Most of you separate the Excel function arguments with the comma; however, this doesn\u2019t work on all Excel workbooks. The character that you generally use to divide arguments, moreover, depends on the <strong>List Separator,<\/strong> which is set with the <strong>Regional Settings.<\/strong><\/p>\n<p style=\"text-align: justify;\">European countries use for assigning the <strong>decimal symbol.<\/strong> Whereas, for the list separator semicolon is used.<\/p>\n<p style=\"text-align: justify;\">For e.g: North American Excel user would write <strong>=IF(A1&gt;0, &#8220;OK&#8221;, &#8220;Not OK&#8221;)<\/strong>, whereas <strong>European<\/strong> Excel users would put the same formula like this <strong>=IF(A1&gt;0; &#8220;OK&#8221;; &#8220;Not OK&#8221;)<\/strong>.<\/p>\n<p style=\"text-align: justify;\">\u00a0If you suddenly start getting <strong>Excel Formulas Not Working <\/strong>issue because of the &#8220;<em><strong>We found a problem with this formula&#8230;&#8221;<\/strong><\/em> error. in that case just go to your <strong>Regional Settings, <\/strong>which is present in:<\/p>\n<p style=\"text-align: justify;\"><strong>(<em>Control Panel<\/em>\u00a0&gt;\u00a0<em>Region and Language<\/em>\u00a0&gt;\u00a0<em>Additional Settings<\/em>)<\/strong><\/p>\n<p style=\"text-align: justify;\">After that make a check of the character that is set for <strong>List Separator<\/strong> over there. Make use of the same character for dividing the arguments in the formula of Excel.<\/p>\n<p style=\"text-align: justify;\">Try the given tricks to solve the formula not working in Excel and fix the error easily.<\/p>\n<h2 style=\"text-align: left;\"><strong>How To Fix Excel Formulas Not Updating Automatically?<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2975 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-automatically.gif\" alt=\"How To Fix Excel Formulas Not Updating Automatically\" width=\"619\" height=\"348\" \/><\/p>\n<p style=\"text-align: justify;\">When you are noticing that the <strong>Excel formula is not updating automatically<\/strong> the reason can be your Excel calculation setting is somehow got changed. Generally, it is found that when the calculation setting is changed from automatic to manual. At that time <strong>Excel formula is not updating automatically <\/strong>as issues were being faced.<\/p>\n<p>Here is how to change the calculation setting to<a href=\"https:\/\/www.repairmsexcel.com\/blog\/fix-excel-formulas-not-updating-issue\"><strong> fix the Excel Formula Is Not Updating issue.<\/strong><\/a><\/p>\n<ul>\n<li style=\"text-align: left;\">Go to the <strong>Excel ribbon,<\/strong> and then to the <em><strong>Formulas.<\/strong><\/em><\/li>\n<li style=\"text-align: left;\">From this <strong>formula<\/strong> tab, choose the <em><strong>Calculation <\/strong><\/em><strong>group.<\/strong><\/li>\n<li style=\"text-align: left;\">Tap to arrow key present next to <strong>Calculation Options<\/strong>. From the drop-down, choose the <strong>Automatic<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2969 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-1.png\" alt=\"Excel formulas not updating 1\" width=\"493\" height=\"176\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-1.png 493w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-1-300x107.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/p>\n<p>Or else, you can modify the calculation setting through these steps:<\/p>\n<ul>\n<li>For<strong> Excel 2019, Excel 2016<\/strong>,\u00a0<strong>Excel 2013<\/strong>, and\u00a0<strong>Excel 2010\u00a0 user<\/strong>:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Open<strong> Excel worksheet\u00a0&lt;\u00a0\u00a0<em>Formulas<\/em>\u00a0&lt;\u00a0\u00a0<em>Calculation options<\/em><\/strong>\u00a0group. After then choose the <strong>Automatic<\/strong>\u00a0option present within\u00a0<em>Workbook Calculation<\/em>.<\/p>\n<ul>\n<li>For<strong> Excel 2007 user<\/strong>:<\/li>\n<\/ul>\n<p>Tap to the\u00a0<strong><em>Office button<\/em>\u00a0&lt;\u00a0\u00a0<em>Excel options<\/em>\u00a0&lt;\u00a0\u00a0<em>Formulas<\/em>\u00a0&lt;\u00a0\u00a0<em>Workbook Calculation\u00a0<\/em>&lt;\u00a0<em>Automatic<\/em>.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2970 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-2.png\" alt=\"Excel formulas not updating 2\" width=\"583\" height=\"346\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-2.png 583w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-2-300x178.png 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/p>\n<ul>\n<li>For\u00a0<strong>Excel 2003 user<\/strong>:<\/li>\n<\/ul>\n<p>From your Excel ribbon, choose the <strong><em>Tools<\/em>\u00a0&lt;\u00a0<em>Options<\/em>&lt;\u00a0<em>Calculation<\/em>&lt;\u00a0<em>Calculation<\/em>&lt;\u00a0<em>Automatic<\/em>.<\/strong><\/p>\n<h2 style=\"text-align: left;\"><strong>How To Fix Excel Formulas Not Calculating Automatically?<\/strong><\/h2>\n<p style=\"text-align: justify;\">So, check out the reasons along with their fixes to <strong>troubleshoot Excel formulas not calculating<\/strong> issues.<\/p>\n<h3 style=\"text-align: left;\"><strong>1. Show Formulas Mode Is Left On<\/strong><\/h3>\n<p style=\"text-align: justify;\">One very common reason behind <strong>Excel formula not calculating<\/strong> error is that by mistakenly <strong>show formula mode<\/strong> has been activated in the worksheet.<\/p>\n<p style=\"text-align: justify;\">So, to fix this <strong>Excel formula not calculating <\/strong>issue it\u2019s compulsory to<strong> turn off <em>Show Formulas<\/em>\u00a0mode.<\/strong><\/p>\n<p style=\"text-align: justify;\">Here is the step to be followed:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the Excel <strong>Formulas<\/strong> tab and from the<em><strong> Formula Auditing\u00a0<\/strong><\/em><strong>group <\/strong>tap to the <strong>Show Formulas<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2967 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-calculating-1.png\" alt=\"Excel formulas not calculating 1\" width=\"529\" height=\"120\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-calculating-1.png 529w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-calculating-1-300x68.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>2. A Formula Is Entered As Text<\/strong><\/h3>\n<p style=\"text-align: justify;\">The second reason behind the occurrence of <strong>Excel formula not calculating error <\/strong>is that Excel formulas is been formatted like text. For checking this out, follow these steps:<\/p>\n<ul>\n<li style=\"text-align: justify;\">From the <strong>Excel ribbon<\/strong> go to the home tab and then choose the <strong><em>Number group<\/em>.<\/strong><\/li>\n<li style=\"text-align: justify;\">Now choose the formula cell after then have a look over the <strong>Number Format<\/strong>\u00a0box.<\/li>\n<li style=\"text-align: justify;\">If it\u2019s showing text in the <strong>number group<\/strong> then change it to <strong>General<\/strong> and <strong>press F2 button <\/strong>from the keyword, being in the cell.<\/li>\n<li style=\"text-align: justify;\">Now enter any Excel formula so that it will recalculate the data again and show the calculated data.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2968 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-calculating-2.png\" alt=\"Excel formulas not calculating 2\" width=\"507\" height=\"248\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-calculating-2.png 507w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-calculating-2-300x147.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Steps To <\/strong><\/span><span style=\"text-decoration: underline;\"><strong>Recalculate Excel data<\/strong><\/span><\/h4>\n<p style=\"text-align: justify;\">If due to any reason, you want to set the <em>Calculation<\/em>\u00a0option to <strong>Manual<\/strong>. In excel you have the option to force the Excel formulas to recalculate the data again. For this, you need to click on the calculate button.<\/p>\n<p style=\"text-align: justify;\">So, check this out how to force the Excel formulas to recalculate:<\/p>\n<p style=\"text-align: justify;\"><strong>For Recalculating\u00a0<\/strong><strong>Entire Workbook Data<\/strong><strong>:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>From the <strong>Formulas<\/strong> tab choose the <em><strong>Calculation group<\/strong><\/em><strong>.<\/strong><\/li>\n<li>From the opened <em>Calculation group tap to <\/em><strong>Calculate Now.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>For Recalculating\u00a0 Any Specific\u00a0<\/strong><strong>Active Sheet<\/strong><strong>:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>From the <strong>Formulas<\/strong> tab choose the <em><strong>Calculation group<\/strong><\/em><strong>.<\/strong><\/li>\n<li>From the opened <em><strong>Calculation group<\/strong><\/em><em> tap to <\/em><strong>Calculate Sheet.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2971 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-3.png\" alt=\"Excel formulas not updating 3\" width=\"545\" height=\"220\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-3.png 545w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/Excel-formulas-not-updating-3-300x121.png 300w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><\/p>\n<p style=\"text-align: justify;\">If you to perform this recalculation task in\u00a0<strong>all sheets <\/strong><strong>of your opened Excel <\/strong><strong>workbooks<\/strong>. Then for this just press\u00a0the<strong> Ctrl + Alt + F9<\/strong> button simultaneously.<\/p>\n<p style=\"text-align: justify;\">In case you want to <strong>recalculate one single formula on the sheet<\/strong> then choose the formula cell. After that, get into editing mode by double-tapping the cell or by hitting the<strong> F2\u00a0button<\/strong>. At last hit <strong>Enter key<\/strong> from your keyboard.<\/p>\n<h2 style=\"text-align: left;\"><strong>Automatic Solution: MS Excel Repair Tool<\/strong><\/h2>\n<p style=\"text-align: justify;\">Apart from the manual solution, sometimes the Excel file gets corrupted and starts showing various errors; then, in this case, make use of the<strong>\u00a0<a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\">MS Excel Repair Tool<\/a>. <\/strong>This is the best repair utility to fix all sorts of issues, corruption, and even errors in the Excel file.<\/p>\n<p style=\"text-align: justify;\">With the help of these users can repair the Excel file easily and also restore the entire corrupted data, including cell comments, charts, other data, and worksheet properties. This is a professionally designed program that can easily <a href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-xls-xlsx-file-recovery\"><strong>repair .xls and .xlsx files<\/strong><\/a> and is easy to use.<\/p>\n<p style=\"text-align: justify;\"><center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h3 style=\"text-align: left;\"><strong>Steps to Utilize MS Excel Repair Tool:<\/strong><\/h3>\n<p style=\"text-align: justify;\">\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Enable Formulas in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo enable the formulas in Microsoft Excel, follow the below steps: <ul><li>Go to the Protection tab, clear a Hidden check box. <\/li><li>Then go to the <strong>Formulas<\/strong> &gt;&gt; choose Show Formulas to enable the feature.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why Are My Formulas Not Working in Excel Value?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIt might be possible that your formula refers to other cells that hold spaces, comma, or even trickier: hidden spaces.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Unfreeze Formula in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf you want to unfreeze formula in Excel, click on the <strong>View<\/strong> tab &gt; Window &gt; Unfreeze Panes option.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What To Do If Excel Is Not Taking Formulas?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf Microsoft Excel is not taking formulas, ensure that automatic calculation feature is enabled.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Refresh Formulas in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo refresh formulas in MS Excel, you can either recalculate all the formulas in a spreadsheet or a specific range. However, you can use the F9 key, Ctrl + Alt + F9, Shift + F9, or manually recalculating via the \u2018<strong>Formulas<\/strong>\u2019 tab.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Restore Formula in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo restore a lost formula bar in Excel, you have to follow the below steps carefully: <ul><li>Click on the File (or the Office button in earlier Excel versions). <\/li><li>Then, click on the <strong>Options<\/strong>. <\/li><li>Click on Advanced in the left pane. <\/li><li>Now, scroll down to the Display section &gt;&gt; select the Show Formula bar option.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Enable Formulas in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To enable the formulas in Microsoft Excel, follow the below steps: &lt;ul&gt;&lt;li&gt;Go to the Protection tab, clear a Hidden check box. &lt;\/li&gt;&lt;li&gt;Then go to the <strong>Formulas<\/strong> &gt;&gt; choose Show Formulas to enable the feature.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why Are My Formulas Not Working in Excel Value?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"It might be possible that your formula refers to other cells that hold spaces, comma, or even trickier: hidden spaces.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Unfreeze Formula in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If you want to unfreeze formula in Excel, click on the <strong>View<\/strong> tab &gt; Window &gt; Unfreeze Panes option.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What To Do If Excel Is Not Taking Formulas?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If Microsoft Excel is not taking formulas, ensure that automatic calculation feature is enabled.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Refresh Formulas in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To refresh formulas in MS Excel, you can either recalculate all the formulas in a spreadsheet or a specific range. However, you can use the F9 key, Ctrl + Alt + F9, Shift + F9, or manually recalculating via the \u2018<strong>Formulas<\/strong>\u2019 tab.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Restore Formula in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To restore a lost formula bar in Excel, you have to follow the below steps carefully: &lt;ul&gt;&lt;li&gt;Click on the File (or the Office button in earlier Excel versions). &lt;\/li&gt;&lt;li&gt;Then, click on the <strong>Options<\/strong>. &lt;\/li&gt;&lt;li&gt;Click on Advanced in the left pane. &lt;\/li&gt;&lt;li&gt;Now, scroll down to the Display section &gt;&gt; select the Show Formula bar option.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Final Thoughts<\/strong><\/h2>\n<p style=\"text-align: justify;\">When Excel formulas don\u2019t work, don\u2019t panic. Most issues come from minor settings or entry errors. All you need to do is to go through these steps methodically mentioned above, and you\u2019ll have your spreadsheet back on track in minutes.<\/p>\n<p>Keep your formulas clean, review inputs carefully, and Excel will do the heavy lifting.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/techcommunity.microsoft.com\/discussions\/excelgeneral\/excel-formulas-not-working\/2079483\" target=\"_blank\" rel=\"noopener\">https:\/\/techcommunity.microsoft.com\/discussions\/excelgeneral\/excel-formulas-not-working\/2079483<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Undoubtedly, Microsoft Excel provides several functions to analyze, audit, and calculate data. Some of the formulas are frequently used by &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#more-466\" aria-label=\"Read more about Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":3006,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[814,1961],"class_list":["post-466","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-excel-formulas-not-working","tag-formula-not-working-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!<\/title>\n<meta name=\"description\" content=\"Is your Excel formulas not working? Don\u2019t worry! In this guide, we will show you quick fixes to enable the ruler option in Excel.\" \/>\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.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!\" \/>\n<meta property=\"og:description\" content=\"Is your Excel formulas not working? Don\u2019t worry! In this guide, we will show you quick fixes to enable the ruler option in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-30T07:40:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-02T19:15:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Excel-Formulas-Not-Working-Error.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!\",\"datePublished\":\"2025-06-30T07:40:08+00:00\",\"dateModified\":\"2025-07-02T19:15:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error\"},\"wordCount\":2227,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Excel-Formulas-Not-Working-Error.png\",\"keywords\":[\"Excel Formulas Not Working\",\"formula not working in Excel\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error\",\"name\":\"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Excel-Formulas-Not-Working-Error.png\",\"datePublished\":\"2025-06-30T07:40:08+00:00\",\"dateModified\":\"2025-07-02T19:15:43+00:00\",\"description\":\"Is your Excel formulas not working? Don\u2019t worry! In this guide, we will show you quick fixes to enable the ruler option in Excel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Excel-Formulas-Not-Working-Error.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Excel-Formulas-Not-Working-Error.png\",\"width\":900,\"height\":450,\"caption\":\"Fixes For Excel Formulas Not Working Error\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/9-top-fixes-solutions-excel-formulas-not-working-error#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!","description":"Is your Excel formulas not working? Don\u2019t worry! In this guide, we will show you quick fixes to enable the ruler option in Excel.","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.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error","og_locale":"en_US","og_type":"article","og_title":"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!","og_description":"Is your Excel formulas not working? Don\u2019t worry! In this guide, we will show you quick fixes to enable the ruler option in Excel.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error","og_site_name":"Excel File Repair Blog","article_published_time":"2025-06-30T07:40:08+00:00","article_modified_time":"2025-07-02T19:15:43+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Excel-Formulas-Not-Working-Error.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!","datePublished":"2025-06-30T07:40:08+00:00","dateModified":"2025-07-02T19:15:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error"},"wordCount":2227,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Excel-Formulas-Not-Working-Error.png","keywords":["Excel Formulas Not Working","formula not working in Excel"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error","url":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error","name":"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Excel-Formulas-Not-Working-Error.png","datePublished":"2025-06-30T07:40:08+00:00","dateModified":"2025-07-02T19:15:43+00:00","description":"Is your Excel formulas not working? Don\u2019t worry! In this guide, we will show you quick fixes to enable the ruler option in Excel.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Excel-Formulas-Not-Working-Error.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/01\/Excel-Formulas-Not-Working-Error.png","width":900,"height":450,"caption":"Fixes For Excel Formulas Not Working Error"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/9-top-fixes-solutions-excel-formulas-not-working-error#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel Formulas Not Working\u2013 The Ultimate Fixes You Need!"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":2,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":9080,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/466\/revisions\/9080"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/3006"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}