{"id":70,"date":"2017-06-06T06:39:35","date_gmt":"2017-06-06T06:39:35","guid":{"rendered":"https:\/\/www.filerepairtools.com\/tips\/?p=70"},"modified":"2026-03-07T22:52:16","modified_gmt":"2026-03-07T22:52:16","slug":"how-to-repair-corrupt-excel-file-and-back-up-data","status":"publish","type":"post","link":"https:\/\/filerepairtools.com\/tips\/how-to-repair-corrupt-excel-file-and-back-up-data\/","title":{"rendered":"How to Repair Corrupt Excel File and Back up Data"},"content":{"rendered":"<p><strong>MS Excel<\/strong>\u00a0is another great product from Microsoft which allows us to maintain the data properly and in organized manner. With its features of calculations, formulas, Charts it is preferable by various organizations as you can easily calculate the stats. MS Excel finds its use in most of the corporate companies.<\/p>\n<p>Excel maintains the data in workbook form. There might be a chance that it get corrupt due to hyperlinks in the sheet, inappropriate merging of cell and rows. Any corrupt file creates problem for user as it contains important data. Here we will discuss some manual methods to\u00a0<a href=\"http:\/\/excel.filerepairtools.com\/\"><strong>Repair Corrupt Excel file.<\/strong><\/a><\/p>\n<p>While we open a excel sheet or workbook it automatically runs the repair process and then displays the data, however if that doesn\u2019t work we can repair the files manually.<\/p>\n<ul>\n<li>Open a blank excel sheet in your system<\/li>\n<li>Go to File and click Open<\/li>\n<li>The Open dialog box will appear, select the corrupt excel file you want to repair<\/li>\n<li>Now Click on arrow in Open drop down option and select\u00a0<strong>Open and Repair<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-71 size-full\" src=\"https:\/\/www.filerepairtools.com\/tips\/wp-content\/uploads\/2017\/06\/Repair-Excel-File.png\" alt=\"open and repair excel file\" width=\"226\" height=\"232\" \/><\/li>\n<\/ul>\n<p>This will repair excel sheet as much as possible. If you doesn\u2019t seem satisfactory from the result then you can select\u00a0<strong>Extract data<\/strong>\u00a0option to extract values and formulas from corrupt excel sheet.<\/p>\n<p>If the file gets corrupted while working then you can\u00a0<strong>backup to last saved version<\/strong>.Go to file and open the file and double click on name that open in Excel, click on the yes option the file will be\u00a0<strong>reopened to the last saved version<\/strong>. To prevent loss of data from corrupted Excel file or accidentally deleted file you can create an Auto backup of file.<\/p>\n<p><strong>Steps to Auto back up file<\/strong><\/p>\n<ul>\n<li>Open the Excel file<\/li>\n<li>Go to file Menu and click on\u00a0<strong>save as option<\/strong>\u00a0and select Excel Workbook.<\/li>\n<li>The save as dialog box will open. Go to\u00a0<strong>Tools option<\/strong>\u00a0in Save as wizard<\/li>\n<li>Click on the arrow button and Select\u00a0<strong>General Option<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-72 size-full\" src=\"https:\/\/www.filerepairtools.com\/tips\/wp-content\/uploads\/2017\/06\/Back-up-excel-file.png\" alt=\"backup excel file\" width=\"320\" height=\"151\" \/><\/li>\n<\/ul>\n<ul>\n<li>Check mark\u00a0<strong>Always create back up<\/strong>\u00a0and enter the password.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-73 size-full\" src=\"https:\/\/www.filerepairtools.com\/tips\/wp-content\/uploads\/2017\/06\/Automatic-Excel-File-Backup.png\" alt=\"xlsx file backup\" width=\"298\" height=\"184\" \/><\/li>\n<\/ul>\n<ul>\n<li>Finally Click Ok , It will create an\u00a0<strong>auto back up of file<\/strong>\u00a0each time you use excel sheet.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MS Excel\u00a0is another great product from Microsoft which allows us to maintain the data properly and in organized manner. With its features of calculations, formulas, Charts it is preferable by various organizations as you can easily calculate the stats. MS Excel finds its use in most of the corporate companies. Excel maintains the data in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2219,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-70","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-recovery"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/comments?post=70"}],"version-history":[{"count":6,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":7731,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/70\/revisions\/7731"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/media?parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/categories?post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/tags?post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}