{"id":9583,"date":"2017-08-16T11:15:34","date_gmt":"2017-08-16T11:15:34","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=9583"},"modified":"2025-07-15T09:41:28","modified_gmt":"2025-07-15T09:41:28","slug":"ms-excel-open-and-repair-option-is-not-working","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/","title":{"rendered":"Solved : &#8216;Open and Repair\u2019 Doesn\u2019t Work in Excel"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>Whether you are a student or an entrepreneur, the features of Microsoft Excel do not delude anyone. Setting goals, creating budgets, analyzing data, calculating salaries, is there anything that Excel can&rsquo;t do? All of us have used it and trusted it to calculate and provide a solution to our most difficult problems. However, like every other software application, this otherwise reliable application can sometimes fall prey to unexpected errors which can even threaten to make our critical data inaccessible.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"644\" height=\"206\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/open-and-repair-1.jpg\" alt=\"Open and Repair doesn&rsquo;t work\" class=\"wp-image-9591 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/open-and-repair-1.jpg 644w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/open-and-repair-1-300x96.jpg 300w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><\/figure>\n<\/div><p>A good idea to avoid loss of data when a Microsoft Excel file becomes corrupt is to take some proactive measures, such as saving a backup copy of your files and creating an automatic recovery file at periodic intervals. If you are faced with a corrupted Excel file, you know you can still use the &lsquo;Open and Repair&rsquo; function provided by Microsoft to fix and open corrupt Excel file. However, what should a user do when &lsquo;<strong>Open and Repair<\/strong>&rsquo; is not working? This is a query shared by millions of Excel users worldwide. Sometimes, the &lsquo;Open and Repair&rsquo; functionality of Excel stops working due to unknown reasons. In such cases, if users face Excel file corruption, they get stuck with no idea how to fix the Excel file.<\/p><p><a href=\"https:\/\/support.office.com\/en-us\/article\/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Manual method &ldquo;Reference&rdquo;<\/a><\/p><p>In this guide, we&rsquo;re providing you with the solutions to this very problem. If Excel &lsquo;Open and Repair&rsquo; is not working, read on to find out the procedures that you can perform to open corrupted files.<\/p><h2 class=\"wp-block-heading\" id=\"how-to-fix-excel-file-that-won&rsquo;t-open-\"><strong>How to Fix Excel file that Won&rsquo;t Open <\/strong><\/h2><p>If your workbook is opening in Excel, there are two options to recover its data. It would be best if you try to perform one, and if you are unsuccessful, move on to the next.<\/p><h3 class=\"wp-block-heading\" id=\"h-revert-the-workbook-to-the-version-that-was-saved-before-the-corruption\"><strong>Revert the workbook to the version that was saved before the corruption<\/strong> <\/h3><ul class=\"wp-block-list\">\n<li>Launch Excel and click <strong>File<\/strong> -&gt; <strong>Open<\/strong><\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"630\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/File-and-Open.png\" alt=\"Excel File Open\" class=\"wp-image-68703 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/File-and-Open.png 550w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/File-and-Open-262x300.png 262w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Select the file that is corrupted and open it<\/li>\n\n\n\n<li>Click &lsquo;<strong>Yes<\/strong>&rsquo; to save the copy of the workbook that was saved before corruption <\/li>\n<\/ul><p><strong>Important Note:<\/strong> If you use this method, you will lose all changes made to the file after it was corrupted.<\/p><h4 class=\"wp-block-heading\" id=\"h-save-the-workbook-in-the-sylk-file-format\"><strong>Save the workbook in the SYLK file format<\/strong> <\/h4><ul class=\"wp-block-list\">\n<li>Launch Excel and click <strong>File<\/strong> -&gt; <strong>Save As<\/strong>.<\/li>\n\n\n\n<li>In the <strong>Save as Type<\/strong> field, select <strong>SYLK (Symbolic Link)<\/strong> from the drop-down menu, and click <strong>Save<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"897\" height=\"547\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/SYLK-format.png\" alt=\"Save Excel Workbook in SYLK File Format \" class=\"wp-image-68704 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/SYLK-format.png 897w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/SYLK-format-300x183.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/SYLK-format-768x468.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/SYLK-format-407x247.png 407w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>To save only the active sheet in the workbook, click <strong>OK<\/strong>. The system will display a message that the sheet has features that are not compatible with the SYLK file format.<\/li>\n\n\n\n<li>Click <strong>Yes<\/strong>.<\/li>\n\n\n\n<li>In Excel click <strong>File<\/strong> -&gt; <strong>Open<\/strong>.<\/li>\n\n\n\n<li>Select the file that you saved in SYLK file format and open it.<\/li>\n\n\n\n<li>In Excel click <strong>File<\/strong> -&gt; <strong>Save As<\/strong>.<\/li>\n\n\n\n<li>In the <strong>Save as Type<\/strong> field, select <strong>Excel Workbook<\/strong> from the drop-down menu.<\/li>\n\n\n\n<li>In the <strong>File Name<\/strong> field, type a new name for your workbook and click <strong>Save<\/strong>. <\/li>\n<\/ul><p>The SYLK file format will filter out the corrupted elements from your workbook, thereby restoring your data.<\/p><blockquote class=\"note_alert\">\n<p><strong>Important Note:<\/strong> Using this method you only be able to salvage the active sheet in the workbook.<\/p>\n<\/blockquote><h2 class=\"wp-block-heading\" id=\"how-to-open\/fix-an-excel-file-that-cannot-be-opened-\"><strong>How to Open\/Fix an Excel file<\/strong><strong> that cannot be opened <\/strong><\/h2><p>In this case too, there are two options to recover the data. Try to perform one, and if you are unsuccessful, move on to the next.<\/p><p><strong>Set the calculation option to Manual<\/strong><\/p><ul class=\"wp-block-list\">\n<li> Launch Excel and click <strong>File<\/strong> -&gt; <strong>New<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"343\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/New-file.png\" alt=\"Launch Excel and click File&gt;New.\" class=\"wp-image-68707 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/New-file.png 156w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/New-file-136x300.png 136w\" sizes=\"auto, (max-width: 156px) 100vw, 156px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>From the <strong>Available Templates<\/strong> window, select <strong>Blank workbook<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"544\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Blank-workbook.png\" alt=\"From the Available Templates window, select Blank workbook.\" class=\"wp-image-68709 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Blank-workbook.png 430w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Blank-workbook-237x300.png 237w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Click <strong>File<\/strong> -&gt; <strong>Options<\/strong>.<\/li>\n\n\n\n<li>Under <strong>Formulas<\/strong>, in the <strong>Calculation options<\/strong> section, click <strong>Manual<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"586\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Calculation-Options.png\" alt=\"Change options related to formula calculation\" class=\"wp-image-68711 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Calculation-Options.png 811w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Calculation-Options-300x217.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2020\/12\/Calculation-Options-768x555.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Click <strong>OK<\/strong>.<\/li>\n\n\n\n<li>In Excel click <strong>File<\/strong> -&gt; <strong>Open<\/strong>.<\/li>\n\n\n\n<li>Select the corrupted file and open it. <\/li>\n<\/ul><p>The system opens the corrupted file. Since the workbook won&rsquo;t be calculated, it might open.<\/p><h2 class=\"wp-block-heading\" id=\"link-the-workbook-to-external-references\"><strong>Link the workbook to external references<\/strong><\/h2><ul class=\"wp-block-list\"><li>Launch Excel and click <strong>File<\/strong> -&gt; <strong>Open<\/strong>.<\/li><li>Copy the name of the corrupted file and click <strong>Cancel<\/strong>.<\/li><li>In Excel click <strong>File<\/strong> -&gt; <strong>New<\/strong>.<\/li><li>From the <strong>Available Templates<\/strong> window, select <strong>Blank workbook<\/strong>.<\/li><li>In the new workbook, on cell A1, type the following: <\/li><\/ul><p class=\"has-text-align-center\">=File Name!A1<\/p><p><strong>In the above command, the filename is the name of the corrupted file.<\/strong><\/p><ul class=\"wp-block-list\">\n<li>On the <strong>Update Values<\/strong> dialog box, select the corrupted file and click <strong>OK<\/strong>.<\/li>\n\n\n\n<li>On the <strong>Select Sheet<\/strong> dialog box, select the sheet and click <strong>OK<\/strong>.<\/li>\n\n\n\n<li>Select cell A1. Select the same range of rows and columns as occupied by the data in the corrupted sheet, including cell A1.<\/li>\n\n\n\n<li>Under the <strong>Home<\/strong> tab, in the <strong>Clipboard<\/strong> section, click <strong>Paste<\/strong>.<\/li>\n\n\n\n<li>While the range of rows and columns are still selected, click <strong>Copy<\/strong>.<\/li>\n\n\n\n<li>Click the <strong>Paste<\/strong><\/li>\n\n\n\n<li>Under <strong>Paste Values<\/strong>, click <strong>Values<\/strong>.<\/li>\n<\/ul><p><strong>Note: <\/strong>This method lets you recover only the data but not the values and formulas from the workbook.<\/p><h2 class=\"wp-block-heading\" id=\"alternative-solution\"><strong>Alternative Solution<\/strong><\/h2><p>In addition to the above-mentioned techniques, you can also use macros to extract data from a corrupted workbook. However, macros are generally risky, and executing them needs prior technical knowledge.<\/p><p>Thus, if the above methods do not yield the desired results, a quick and easy way to reconstruct Excel files is to use <a href=\"https:\/\/www.stellarinfo.com\/repair-excel-file.php\">professional Excel repair software<\/a>. Stellar Repair for MS SQL software is the best choice for rebuilding damaged Excel files and restoring everything to a new Excel file. The product lets you recover tables, charts, chart-sheet, cell comments, images, formulas, sort, and filter data from damaged workbooks and also allows you to fix multiple files at one go.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/cloud.stellarinfo.com\/StellarRepairforExcel-Blog.exe\"><img loading=\"lazy\" decoding=\"async\" width=\"226\" height=\"62\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Microsoft-vs-bing-1.png\" alt=\"Free Download for Windows\" class=\"wp-image-166355 apply-gradient-on-post-images\" style=\"width:252px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Microsoft-vs-bing-1.png 226w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2024\/05\/Microsoft-vs-bing-1-150x41.png 150w\" sizes=\"auto, (max-width: 226px) 100vw, 226px\" \/><\/a><\/figure>\n<\/div><h2 class=\"wp-block-heading\" id=\"wrapping-it-up\"><strong>Wrapping it up<\/strong><\/h2><p>Though one of the above-mentioned techniques should recover Excel file if &lsquo;<em><strong>Open and Repair&rsquo; utility doesn&rsquo;t work<\/strong><\/em>, in case you&rsquo;ve reached nowhere even after using them, contact Microsoft support for more help.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whether you are a student or an entrepreneur, the features of Microsoft&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\">Continue reading <span class=\"screen-reader-text\">Solved : &#8216;Open and Repair\u2019 Doesn\u2019t Work in Excel<\/span><\/a><\/p>\n","protected":false},"author":4,"featured_media":97096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[652,653],"class_list":["post-9583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-file-repair","tag-excel-file-repair","tag-open-and-repair-is-not-working","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u2018Open and Repair\u2019 Doesn\u2019t Work in MS Excel<\/title>\n<meta name=\"description\" content=\"Learn how to fix Excel file when Open and Repair doesn&#039;t work? In this blog, you will see the amazing methods to solve Excel errors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u2018Open and Repair\u2019 Doesn\u2019t Work in MS Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to fix Excel file when Open and Repair doesn&#039;t work? In this blog, you will see the amazing methods to solve Excel errors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/jyoti.keshari\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-16T11:15:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-15T09:41:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jyoti Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jyoti Prakash\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\"},\"author\":{\"name\":\"Jyoti Prakash\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/8f2f854c17c65107a2cb38afc9eb6804\"},\"headline\":\"Solved : &#8216;Open and Repair\u2019 Doesn\u2019t Work in Excel\",\"datePublished\":\"2017-08-16T11:15:34+00:00\",\"dateModified\":\"2025-07-15T09:41:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\"},\"wordCount\":936,\"commentCount\":6,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg\",\"keywords\":[\"Excel file repair\",\"open and repair is not working\"],\"articleSection\":[\"MS Office File Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\",\"name\":\"\u2018Open and Repair\u2019 Doesn\u2019t Work in MS Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg\",\"datePublished\":\"2017-08-16T11:15:34+00:00\",\"dateModified\":\"2025-07-15T09:41:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/8f2f854c17c65107a2cb38afc9eb6804\"},\"description\":\"Learn how to fix Excel file when Open and Repair doesn't work? In this blog, you will see the amazing methods to solve Excel errors.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Solved : \u2018Open and Repair\u2019 Doesn\u2019t Work in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Solved : &#8216;Open and Repair\u2019 Doesn\u2019t Work in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/8f2f854c17c65107a2cb38afc9eb6804\",\"name\":\"Jyoti Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7507f1af3375dcc4cbed6614dc21f92f1a08282ea2f734bf7fd404bcee0f3178?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7507f1af3375dcc4cbed6614dc21f92f1a08282ea2f734bf7fd404bcee0f3178?s=96&d=mm&r=g\",\"caption\":\"Jyoti Prakash\"},\"description\":\"Jyoti Prakash is a Senior Manager at Stellar Information Technology Pvt. Ltd., having over 15+ years of experience with a background in information technology. A tech enthusiast and expert, he specializes in data recovery, &amp; file repair. He has participated for numerous communities, including Microsoft, SpiceWorks etc. He also provide training on Windows, Microsoft Office, Online Marketing, &amp; social media.\",\"sameAs\":[\"https:\/\/www.facebook.com\/jyoti.keshari\",\"https:\/\/www.linkedin.com\/in\/jyoti-keshari-5750629\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/jyoti\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u2018Open and Repair\u2019 Doesn\u2019t Work in MS Excel","description":"Learn how to fix Excel file when Open and Repair doesn't work? In this blog, you will see the amazing methods to solve Excel errors.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/","og_locale":"en_US","og_type":"article","og_title":"\u2018Open and Repair\u2019 Doesn\u2019t Work in MS Excel","og_description":"Learn how to fix Excel file when Open and Repair doesn't work? In this blog, you will see the amazing methods to solve Excel errors.","og_url":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/","og_site_name":"Stellar Data Recovery Blog","article_author":"https:\/\/www.facebook.com\/jyoti.keshari","article_published_time":"2017-08-16T11:15:34+00:00","article_modified_time":"2025-07-15T09:41:28+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg","type":"image\/jpeg"}],"author":"Jyoti Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jyoti Prakash","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/"},"author":{"name":"Jyoti Prakash","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/8f2f854c17c65107a2cb38afc9eb6804"},"headline":"Solved : &#8216;Open and Repair\u2019 Doesn\u2019t Work in Excel","datePublished":"2017-08-16T11:15:34+00:00","dateModified":"2025-07-15T09:41:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/"},"wordCount":936,"commentCount":6,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg","keywords":["Excel file repair","open and repair is not working"],"articleSection":["MS Office File Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/","url":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/","name":"\u2018Open and Repair\u2019 Doesn\u2019t Work in MS Excel","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg","datePublished":"2017-08-16T11:15:34+00:00","dateModified":"2025-07-15T09:41:28+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/8f2f854c17c65107a2cb38afc9eb6804"},"description":"Learn how to fix Excel file when Open and Repair doesn't work? In this blog, you will see the amazing methods to solve Excel errors.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Solved-Open-and-Repair-Doesnot-Work-in-Excel.jpg","width":1000,"height":600,"caption":"Solved : \u2018Open and Repair\u2019 Doesn\u2019t Work in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/ms-excel-open-and-repair-option-is-not-working\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Solved : &#8216;Open and Repair\u2019 Doesn\u2019t Work in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/8f2f854c17c65107a2cb38afc9eb6804","name":"Jyoti Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7507f1af3375dcc4cbed6614dc21f92f1a08282ea2f734bf7fd404bcee0f3178?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7507f1af3375dcc4cbed6614dc21f92f1a08282ea2f734bf7fd404bcee0f3178?s=96&d=mm&r=g","caption":"Jyoti Prakash"},"description":"Jyoti Prakash is a Senior Manager at Stellar Information Technology Pvt. Ltd., having over 15+ years of experience with a background in information technology. A tech enthusiast and expert, he specializes in data recovery, &amp; file repair. He has participated for numerous communities, including Microsoft, SpiceWorks etc. He also provide training on Windows, Microsoft Office, Online Marketing, &amp; social media.","sameAs":["https:\/\/www.facebook.com\/jyoti.keshari","https:\/\/www.linkedin.com\/in\/jyoti-keshari-5750629\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/jyoti\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/9583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=9583"}],"version-history":[{"count":41,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/9583\/revisions"}],"predecessor-version":[{"id":183930,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/9583\/revisions\/183930"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/97096"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=9583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=9583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=9583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}