{"id":7937,"date":"2024-01-25T12:05:52","date_gmt":"2024-01-25T12:05:52","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=7937"},"modified":"2024-02-08T04:25:59","modified_gmt":"2024-02-08T04:25:59","slug":"fix-ref-error-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel","title":{"rendered":"5 Proven Methods- How to Fix #REF In Excel Easily?"},"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;\">Excel users are no strangers to the formula errors in spreadsheets. One such error that users encounter is \u201c#<strong>REF<\/strong>!\u201d. It is a frustrating error that occurs when a formula referring to a specific cell is not valid. This moment can disrupt your entire workflow. Therefore, in this blog, I will explore what #ref error is, why it occurs, and most significantly <strong>how to fix #REF in Excel<\/strong> for a seamless spreadsheet experience.<!--more--><\/p>\n<p><strong>Screenshot of the error:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7938 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix-ref-in-Excel.png\" alt=\"how to fix #ref in Excel\" width=\"499\" height=\"303\" \/><\/p>\n<p style=\"text-align: justify;\">So, let\u2019s dig deep\u2026<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To repair corrupted Excel file, 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<h3><strong>Quick Fixes:<\/strong><\/h3>\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<ul>\n<li><strong><a href=\"#s1\">Method 1- Review Formulas in A Cell<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Method 2- Undo the Changes<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Method 3- Use the Go to Special Option<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Method 4- Using the Find &amp; Replace Feature<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Method 5- Use Conditional Formatting to Highlight Errors<\/a><\/strong><\/li>\n<\/ul>\n<\/div><\/div>\n<h2 style=\"text-align: left;\"><strong>What Is REF Error in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">In Excel, <strong>REF<\/strong> stands for <strong>reference<\/strong>. And #ref error appears when a formula refers to a cell that is invalid or no longer exists. It usually happens after deleting the cells that a formula is referring to.<\/p>\n<p style=\"text-align: justify;\">When this error occurs, it simply means that you can\u2019t even perform calculations or mathematical operations using formulas.<\/p>\n<p style=\"text-align: justify;\"><strong>Let&#8217;s take an example to better understand.\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">Suppose you want to calculate total sales completed in the last quarter and you calculate this in <strong>cell<\/strong> <strong>B5<\/strong> by using the below formula:<\/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>=SUM(B2:B4)<\/strong><\/p>\n<\/div><\/div>\n<p style=\"text-align: justify;\">But later you decide to shift it to cell E2 of your spreadsheet. In this instance, you will get a #REF error.<\/p>\n<h2 style=\"text-align: left;\"><strong>Can REF Errors Lead to Permanent Data Loss?<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>No<\/strong>, REF errors in Excel don&#8217;t directly lead to data loss. But if it is not fixed promptly then it can result in data inaccuracies and complications. But before addressing this formula error, it is important to identify the root causes for better resolution.<\/p>\n<h2 style=\"text-align: left;\"><strong>What Causes #REF Error In Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Identifying the causes behind the occurrence of #REF errors in Excel worksheets can be challenging but not impossible. Here, I have shortlisted the major factors for this error, let\u2019s take a look:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Missing cells or rows<\/li>\n<li>Using incorrect cell references<\/li>\n<li>Invalid formula<\/li>\n<li>Renamed worksheet or workbook<\/li>\n<li>Deleted or moved external references<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">After extracting the common causes, it\u2019s time to know <strong>how to find #ref in Excel<\/strong> or how to fix REF error in Excel using best workarounds.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Fix #REF in Excel Spreadsheet?<\/strong><\/h2>\n<p style=\"text-align: justify;\">When it comes to fixing formula errors in Excel, patience &amp; meticulousness are paramount. Therefore, have patience and apply the below methods carefully to diagnose and resolve Excel REF error when opening files effectively.<\/p>\n<p><a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 1- Review Formulas in A Cell<\/strong><\/h3>\n<p style=\"text-align: justify;\">The very crucial step that you need to take to get rid of this problem is <strong>checking the formula <\/strong>in a cell where the #REF error occurs. Make sure that all the cell references within a formula are accurate and valid. If everything is OK there but still getting the same error, try the next method.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-spill-error\">Strategies to Resolve #SPILL Error Excel Like a Pro!<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 2- Undo the Changes<\/strong><\/h3>\n<p style=\"text-align: justify;\">If you unintentionally or accidentally deleted a named range, then you can revert it by pressing an \u201c<strong>Undo<\/strong>\u201d button. You can find the Undo option on the \u201cQuick Access Toolbar.\u201d Alternatively, you can use the \u201c<strong>CTRL+Z<\/strong>\u201d keyboard shortcut to undo the changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7947 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/2019-04-20-ScreenShot153.png\" alt=\"Undo\" width=\"185\" height=\"272\" \/><\/p>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 3- Use the Go to Special Option<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another effective trick that can be used is the \u201c<strong>Go To Special\u201d <\/strong>option. In<strong>\u00a0<\/strong>Excel, this feature helps find &amp; select the cells holding a specific category of data. So, here you have to use the same Go To Special feature to locate all the instances of #REF! error in a spreadsheet using these steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Ensure to open the Excel file that is showing the REF error.<\/li>\n<li style=\"text-align: left;\">Go to\u00a0<strong>Home <\/strong>tab &gt;&gt; locate \u201c<strong>Find &amp; Select<\/strong>\u201d option.<\/li>\n<li style=\"text-align: left;\">Expand the dropdown menu of that option &gt;&gt; Choose the <strong>Go To Special<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7944 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/doc-sort-data-with-merged-cells-3.png\" alt=\"Go To Special\" width=\"470\" height=\"411\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Under the opened Go To Special\u00a0dialog, choose\u00a0<strong>Formulas<\/strong>. Then, check the <strong>Errors\u00a0<\/strong>checkbox.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7943 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/Select-formula-with-errors-option.png\" alt=\"Errors\u00a0\" width=\"380\" height=\"431\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">The formulas with ref! errors will be selected.<\/li>\n<\/ul>\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;\"><span style=\"color: #ff0000;\"><strong>Note<\/strong><\/span>: This method will only help you to find the ref errors in cells but it will not help to fix it.<\/p>\n<\/div><\/div>\n<a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 4- How to Fix #REF in Excel by Using the Find &amp; Replace Feature?<\/strong><\/h3>\n<p style=\"text-align: justify;\">The Find and Replace feature is the best trick to <strong>fix ref error in Excel worksheets<\/strong>. This feature helps to quickly replace the #REF errors with blanks and enhance your spreadsheet visuality.<\/p>\n<p style=\"text-align: justify;\">Here&#8217;s how you can use it:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Go to\u00a0<strong>Home <\/strong>tab &gt;&gt; locate \u201c<strong>Find &amp; Select<\/strong>\u201d option.<\/li>\n<li style=\"text-align: left;\">Then, expand the dropdown menu of that option &gt;&gt; Choose the \u201c<strong>Replace\u201d<\/strong>. Alternatively, you can use <strong>CTRL + F<\/strong> keys together to open the Find and Replace dialog-box.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7946 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/doc-replace-commas-to-newline-2.png\" alt=\"Find &amp; Select\" width=\"460\" height=\"418\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Under the Find and Replace box, type <strong>#REF<\/strong> in the <strong>Find what<\/strong> box and leave the <strong>Replace with<\/strong> box empty.<\/li>\n<li style=\"text-align: left;\">Now, click on <strong>Replace All<\/strong> button &amp; hit <strong>Close &gt;&gt; OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7945 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/images.png\" alt=\"How to Fix #REF in Excel\" width=\"343\" height=\"147\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">This will automatically replace the #ref data with empty spaces or will be ignored.<\/li>\n<\/ul>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 5- Use Conditional Formatting to Highlight Errors<\/strong><\/h3>\n<p style=\"text-align: justify;\">You can also use the conditional formatting in Microsoft Excel to monitor for REF! error. This will assist you in applying a selected cell format to any current &amp; future #REF errors.<\/p>\n<p style=\"text-align: justify;\">Follow the below steps to use this option:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Select all cells by pressing <strong>Ctrl + A <\/strong>keys within the worksheet.<\/li>\n<li>Go to the <strong>Home <\/strong>tab then click on<strong> Conditional Formatting.<\/strong><\/li>\n<li>Next, choose<strong> Highlight Cell Rules <\/strong>option <strong>&gt;&gt; More Rules.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7948 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/More-rules-copy.png\" alt=\"How to Fix #REF in Excel\" width=\"376\" height=\"419\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Locate \u201cFormat only cells with\u201d and click on the dropdown to choose Errors.<\/li>\n<li>After this, click <strong>Format<\/strong> to create your wanted format &gt;&gt; hit <strong>OK.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7949 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/Fix_.png\" alt=\"Fix #REF In Excel\" width=\"500\" height=\"285\" \/><\/p>\n<p style=\"text-align: justify;\">Now, #Ref formula error cells are formatted. Once you correct them, the selected formatting is removed.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/solve-value-error\">#VALUE! Error in Excel Demystified: A Step-by-Step Guide<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>How to Fix #Ref Error in Google Sheets?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Troubleshooting steps for the <strong>REF error in Google Sheets<\/strong> is almost similar to an Excel spreadsheet. It means you can easily overcome this situation by implementing the resolutions mentioned in the above section.<\/p>\n<p style=\"text-align: justify;\">However, the first thing you need to do in this situation is check the formula in a cell where the #REF error arises. Make sure that all the cell references within a formula are accurate and valid.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Copy and Paste Without Getting the #Ref in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">You can copy and paste data without getting the #Ref error in Excel spreadsheet by following these steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Select the cell<\/strong> that contains the formula &amp; press <strong>Ctrl + C<\/strong> keys together to copy it.<\/li>\n<li>Next, select the destination cell &amp; press <strong>CTL + V<\/strong> keys together to paste the formula exactly<\/li>\n<li>This will not change the cell references, because the formula was copied as text.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>FAQs- Get Your Queries Answered<\/strong><\/h2>\n<p style=\"text-align: justify;\">        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Change a REF to A Value in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can change a REF to a value in Excel worksheet by following the below steps: <ul><li>Select the cell(s) with the formula. <\/li><li>Then, ensure the cells are highlighted &amp; make a right-click. <\/li><li>After that, select the \u2018<strong>Paste Special<\/strong>\u2019 option from a clipboard menu. <\/li><li>Now, choose the \u2018<strong>Values<\/strong>\u2019 option in that tab. This will delete the formula &amp; replace the content in the cell(s) with static values.                     <\/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>Are There Excel Add-Ins That Can Help Prevent #REF Errors?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\t<strong>Yes<\/strong>, some Excel add-ins offer features to prevent &amp; identify formula errors, including ref errors.                    <\/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 Ignore #Ref Errors in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tUsing the <strong>Find and Replace<\/strong> feature, you can ignore #Ref errors in Excel. Press <strong>CTRL + F<\/strong>, then enter '#ref' in a find option &amp; leave the replace option empty &gt;&gt; hit Replace. This will automatically replace the #ref data with empty spaces or will be ignored.                    <\/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 This Error Occurs Due Excel File Corruption?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf Excel formula errors including REF error occur due to Excel file corruption, consider using Microsoft\u2019s <strong>Open and Repair<\/strong> feature to solve the corruption in the file for free.                    <\/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>Is There a Quick Method For #Ref Errors, Or Does It Require In-Depth Troubleshooting?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tNo, there is no quick method for #ref errors, by trying the fixes specified in this blog, you can overcome this error easily.                    <\/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 Fix #REF Error In VLOOKUP?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can fix REF error in Excel VLOOKUP by adjusting the reference range to be larger, or reducing the column lookup value to match the reference range.                    <\/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>Should I Seek Expert Help If I Can&#039;t Resolve this Error on My Own?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf the error continues even after applying the solutions discussed in this post, consider consulting with an Excel expert.                    <\/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 Change a REF to A Value in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can change a REF to a value in Excel worksheet by following the below steps: &lt;ul&gt;&lt;li&gt;Select the cell(s) with the formula. &lt;\/li&gt;&lt;li&gt;Then, ensure the cells are highlighted &amp; make a right-click. &lt;\/li&gt;&lt;li&gt;After that, select the \u2018<strong>Paste Special<\/strong>\u2019 option from a clipboard menu. &lt;\/li&gt;&lt;li&gt;Now, choose the \u2018<strong>Values<\/strong>\u2019 option in that tab. This will delete the formula &amp; replace the content in the cell(s) with static values.\"\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\": \"Are There Excel Add-Ins That Can Help Prevent #REF Errors?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<strong>Yes<\/strong>, some Excel add-ins offer features to prevent &amp; identify formula errors, including ref errors.\"\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 Ignore #Ref Errors in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Using the <strong>Find and Replace<\/strong> feature, you can ignore #Ref errors in Excel. Press <strong>CTRL + F<\/strong>, then enter '#ref' in a find option &amp; leave the replace option empty &gt;&gt; hit Replace. This will automatically replace the #ref data with empty spaces or will be ignored.\"\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 This Error Occurs Due Excel File Corruption?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If Excel formula errors including REF error occur due to Excel file corruption, consider using Microsoft\u2019s <strong>Open and Repair<\/strong> feature to solve the corruption in the file for free.\"\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\": \"Is There a Quick Method For #Ref Errors, Or Does It Require In-Depth Troubleshooting?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"No, there is no quick method for #ref errors, by trying the fixes specified in this blog, you can overcome this error easily.\"\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 Fix #REF Error In VLOOKUP?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can fix REF error in Excel VLOOKUP by adjusting the reference range to be larger, or reducing the column lookup value to match the reference range.\"\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\": \"Should I Seek Expert Help If I Can't Resolve this Error on My Own?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If the error continues even after applying the solutions discussed in this post, consider consulting with an Excel expert.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/fix-excel-formula-errors\">Fix Excel Formula Errors<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Time to Say Good Bye<\/strong><\/h2>\n<p style=\"text-align: justify;\">Well, mastering the art of <strong>fixing the REF error in Excel<\/strong> is crucial for a continuous spreadsheet experience. Therefore, I have covered the causes and resolutions of #ref errors to navigate &amp; overcome this annoying situation with less effort.<\/p>\n<p style=\"text-align: justify;\">I hope you liked this post.<\/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>References:<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-gb\/office\/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-au\/office\/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-au\/office\/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<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>Excel users are no strangers to the formula errors in spreadsheets. One such error that users encounter is \u201c#REF!\u201d. It &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"5 Proven Methods- How to Fix #REF In Excel Easily?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#more-7937\" aria-label=\"Read more about 5 Proven Methods- How to Fix #REF In Excel Easily?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":7939,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[1639,1638,1640],"class_list":["post-7937","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-excel-ref-error-when-opening-file","tag-how-to-fix-ref-in-excel-on-a-protected-sheet","tag-how-to-fix-ref-error-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 Proven Methods- How to Fix #REF In Excel Easily?<\/title>\n<meta name=\"description\" content=\"This blog delves deep into the realm of how to fix #REF in Excel, focusing on enhancing your Excel skills &amp; boosting your productivity...\" \/>\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\/fix-ref-error-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Proven Methods- How to Fix #REF In Excel Easily?\" \/>\n<meta property=\"og:description\" content=\"This blog delves deep into the realm of how to fix #REF in Excel, focusing on enhancing your Excel skills &amp; boosting your productivity...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-25T12:05:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-08T04:25:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"342\" \/>\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=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"5 Proven Methods- How to Fix #REF In Excel Easily?\",\"datePublished\":\"2024-01-25T12:05:52+00:00\",\"dateModified\":\"2024-02-08T04:25:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel\"},\"wordCount\":1627,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png\",\"keywords\":[\"excel REF error when opening file\",\"how to fix #ref in excel on a protected sheet\",\"how to fix ref error in excel\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel\",\"name\":\"5 Proven Methods- How to Fix #REF In Excel Easily?\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png\",\"datePublished\":\"2024-01-25T12:05:52+00:00\",\"dateModified\":\"2024-02-08T04:25:59+00:00\",\"description\":\"This blog delves deep into the realm of how to fix #REF in Excel, focusing on enhancing your Excel skills & boosting your productivity...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png\",\"width\":550,\"height\":342,\"caption\":\"How to Fix #REF In Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Proven Methods- How to Fix #REF In Excel Easily?\"}]},{\"@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:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"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":"5 Proven Methods- How to Fix #REF In Excel Easily?","description":"This blog delves deep into the realm of how to fix #REF in Excel, focusing on enhancing your Excel skills & boosting your productivity...","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\/fix-ref-error-in-excel","og_locale":"en_US","og_type":"article","og_title":"5 Proven Methods- How to Fix #REF In Excel Easily?","og_description":"This blog delves deep into the realm of how to fix #REF in Excel, focusing on enhancing your Excel skills & boosting your productivity...","og_url":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2024-01-25T12:05:52+00:00","article_modified_time":"2024-02-08T04:25:59+00:00","og_image":[{"width":550,"height":342,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"5 Proven Methods- How to Fix #REF In Excel Easily?","datePublished":"2024-01-25T12:05:52+00:00","dateModified":"2024-02-08T04:25:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel"},"wordCount":1627,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png","keywords":["excel REF error when opening file","how to fix #ref in excel on a protected sheet","how to fix ref error in excel"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel","name":"5 Proven Methods- How to Fix #REF In Excel Easily?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png","datePublished":"2024-01-25T12:05:52+00:00","dateModified":"2024-02-08T04:25:59+00:00","description":"This blog delves deep into the realm of how to fix #REF in Excel, focusing on enhancing your Excel skills & boosting your productivity...","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-fix_.png","width":550,"height":342,"caption":"How to Fix #REF In Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-ref-error-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"5 Proven Methods- How to Fix #REF In Excel Easily?"}]},{"@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:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","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\/7937","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=7937"}],"version-history":[{"count":4,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/7937\/revisions"}],"predecessor-version":[{"id":8032,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/7937\/revisions\/8032"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/7939"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=7937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=7937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=7937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}