%3Ch3%3ERecover%20Corrupted%20Excel%20Workbook%3C/h3%3E%0A%0A%0A%0A%3Col%3E%0A%0A%09%3Cli%3E1.%20Launch%20EaseUS%20Fixo%20Document%20Repair%20and%20choose%20File%20Repair%3C/li%3E%0A%0A%09%3Cli%3E2.%20Tap%20on%20the%20%22Add%20File%22%20button%20to%20upload%20problematic%20files%3C/li%3E%0A%0A%09%3Cli%3E3.%20Click%20%22Repair%22%20to%20start%20the%20repair%20process%3C/li%3E%0A%0A%3C/ol%3E%0A%0A%0A%0A%3Cp%3E%3Ca%20class=%22anchor%22%20href=%22#1%22%3EMore%20Items...%3C/a%3E%3C/p%3E%0A%0A%0A%0A%3Cdiv%20class=%22mb_2018_no1%22%3E%3Cspan%20class=%22t%22%3EPAGE%20CONTENT:%3C/span%3E%0A%0A%0A%0A%3Cdl%3E%0A%0A%09%3Cdt%3E%3Ca%20href=%22#1%22%3E%F0%9F%92%AFRecover%20Corrupted%20Excel%20File%20in%20Windows%2010%20with%20Document%20Repair%20Software%3C/a%3E%3C/dt%3E%0A%0A%09%3Cdt%3E%3Ca%20href=%22#2%22%3EPerform%20Excel%20Corrupted%20File%20Recovery%20with%20Microsoft%20Open%20and%20Repair%20Feature%3C/a%3E%3C/dt%3E%0A%0A%09%3Cdt%3E%3Ca%20href=%22#3%22%3ERestore%20Unopened%20Excel%20Workbooks%20in%20MS%20Excel%20via%20Calculation%20Option%3C/a%3E%3C/dt%3E%0A%0A%09%3Cdt%3E%3Ca%20href=%22#4%22%3EOpen%20Recover%20Excel%20Corrupted%20File%20with%20External%20References%3C/a%3E%3C/dt%3E%0A%0A%09%3Cdt%3E%3Ca%20href=%22#5%22%3EPerform%20Corrupted%20Excel%20File%20Recovery%20with%20Macro%3C/a%3E%3C/dt%3E%0A%0A%3C/dl%3E%0A%0A%3C/div%3E%0A%0A%0A%0A%3Cp%3EIt's%20no%20longer%20a%20new%20problem%20for%20Excel%20users%20to%20encounter%20Excel%20file%20corruption%20errors%20due%20to%20systems,%20viruses,%20or%20other%20unknown%20reasons.%20So,%20how%20to%20effectively%20restore%20a%20corrupted%20Excel%20file%20and%20get%20lost%20data%20back%20has%20become%20a%20new%20question.%3C/p%3E%0A%0A%0A%0A%3Cdiv%20class=%22module_box_230523%20amp_module_box%22%3E%0A%0A%3Cp%20class=%22des%22%3E%22Yesterday,%20I%20was%20editing%20an%20important%20Excel%20file%20on%20my%20computer%20running%20Windows%2010%20when%20the%20Excel%20file%20suddenly%20crashed.%20Then%20I%20tried%20to%20open%20Excel%20again%20and%20got%20the%20error%20message,%20'There%20is%20a%20problem%20in%20this%20file;%20we%20couldn't%20open%20it.'%20Yes,%20the%20Excel%20file%20was%20suddenly%20corrupted.%20Any%20help?%20-%20from%20%3Ca%20href=%22https://answers.microsoft.com/en-us/msoffice/forum/all/my-excel-files-is-corrupted-any-chance/7ce895ff-a210-4cd7-83ff-d67c9dd59812%22%20rel=%22noopener%22%20target=%22_blank%22%3EMicrosoft%20Community%3C/a%3E%22 %3C/p%3E%0A%0A%3C/div%3E%0A%0A%0A%0A%3Cp%3EIf%20you%20are%20having%20a%20similar%20problem,%20don't%20worry.%20Here,%20we%20will%20provide%20two%20quick%20fixes%20and%20one%20complete%20solution%20to%20help%20you%20%3Cstrong%3Erecover%20corrupted%20Excel%20file%20in%20Windows%2010%3C/strong%3E%20effectively. %3C/p%3E%0A%0A%0A%0A%3Ch2%3E%3Ca%20id=%221%22%20name=%221%22%3ERecover%20Corrupted%20Excel%20Files%20in%20Windows%2010%20with%20Document%20Repair%20Software%3C/a%3E%3C/h2%3E%0A%0A%0A%0A%3Cp%3EThe%20best%20method%20for%20solving%20Excel%20file%20corruption%20and%20%3Ca%20href=%22/video-repair-tips/repair-corrupted-excel-file.html%22%3Erepairing%20corrupted%20Excel%20files%3C/a%3E%20is%20to%20consult%20document%20repair%20software.%20%3Ca%20href=%22/repair-tools/document-repair.html%22%3EEaseUS%20Fixo%20Document%20Repair%3C/a%3E%20would%20be%20your%20go-to%20choice%20if%20you%20are%20a%20computer%20rookie%20and%20want%20to%20save%20time.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3C!--icon_content_start--%3E%3C!--icon_id_12051--%3E%0A%0A%3C/p%3E%0A%0A%3Cp%3E%3C/p%3E%0A%0A%0A%0A%3Cp%3EThis%20%3Ca%20href=%22/file-recovery/microsoft-repair-tool.html%22%3EMicrosoft%20repair%20tool%3C/a%3E repairs%20severely%20corrupted%20XLS%20and%20XLSX%20files%20and%20retrieves%20everything%20from%20the%20Excel%20workbook%20without%20modifying%20its%20original%20format.%20You%20can%20read%20the%20following%20features%20of%20this%20reliable%20tool%20to%20know%20more%20about%20its%20robust%20functions:%3C/p%3E%0A%0A%0A%0A%3Cul%20class=%22mb_2018_list_v%20orange%22%3E%0A%0A%09%3Cli%3EFix%20%3Ca%20href=%22/video-repair-tips/excel-running-slow.html%22%3EExcel%20running%20slow%3C/a%3E%3C/li%3E%0A%0A%09%3Cli%3ERepair%20Excel%20opening%20blank%20document%3C/li%3E%0A%0A%09%3Cli%3ESolve%20%3Ca%20href=%22/video-repair-tips/excel-cell-contents-not-visible.html%22%3EExcel%20contents%20not%20visible%3C/a%3E%3C/li%3E%0A%0A%3C/ul%3E%0A%0A%0A%0A%3Cp%3EFollow%20the%20simple%20steps%20below%20to%20recover%20and%20repair%20corrupted%20Excel%20files:%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%201.%3C/strong%3E%20Download%20and%20install%20the%20EaseUS%20%3Ca%20href=%22/data-recovery/best-excel-repair-tools.html%22%3EExcel%20file%20repair%20tool%3C/a%3E.%20Click %22File%20Repair%22%20and%20%22Add%20Files%22%20to%20choose%20the%20corrupted%20MS%20Excel%202016/2019/2021%20files.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%202.%20%3C/strong%3EIn%20the%20ensuing%20screen,%20select%20%22Repair%20All%22%20to%20fix%20numerous%20corrupted%20Excel%20files%20at%20once.%20Another%20option%20is%20to%20use%20the%20Repair%20button%20to%20individually%20recover%20each%20corrupted%20Excel%20spreadsheet.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%203. %3C/strong%3ESave%20the%20Microsoft%20Excel%20files%20that%20have%20been%20fixed,%20then%20click%20the%20%22View%20Repaired%22%20option%20to%20check%20them. %3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3EYou%20can%20share%20this%20post%20to%20forums%20like%20Reddit%20to%20help%20more%20users%20in%20need%20of%20fixing%20corrupted%20Excel%20files:%3C/p%3E%0A%0A%0A%0A%3Cdiv%20class=%22sharethis-inline-share-buttons%22%3E %3C/div%3E%0A%0A%0A%0A%3Ch2%3E%3Ca%20id=%222%22%20name=%222%22%3EPerform%20Excel%20Corrupted%20File%20Recovery%20with%20Microsoft%20Open%20and%20Repair%20Feature%3C/a%3E%3C/h2%3E%0A%0A%0A%0A%3Cp%3EMicrosoft%20Office%20has%20a%20built-in%20open%20and%20repair%20utility%20that%20can%20preliminarily%20repair%20corrupt%20Excel%20files;%20you%20can%20first%20try%20this%20method%20to%20recover%20corrupt%20Excel%20files.%20This%20method%20also%20works%20when%20%3Ca%20href=%22/computer-instruction/excel-has-stopped-working.html%22%3EExcel%20has%20stopped%20working%3C/a%3E.%20Follow%20the%20steps%20here%20to%20perform%20Excel%20corrupt%20file%20recovery:%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%201.%3C/strong%3E%20Launch%20Microsoft%20Excel.%20Navigate%20to%20%22File%22%20>%20%22Open%22>%20%22Browse%22.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%202.%20%3C/strong%3EChoose%20the%20corrupted%20files%20from%20the%20list%20and%20click%20the%20arrow%20beside%20Open.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%203.%20%3C/strong%3EClick%20%22Open%20and%20Repair%22%20to%20start%20the%20repairing%20process.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3EBut%20the%20repair%20rate%20of%20this%20built-in%20feature is%20not%20very%20high;%20if%20this%20process%20fails,%20in%20this%20case,%20you%20can%20try%20EaseUS%20Fixo%20Document%20Repair%20to%20perform%20the%20advanced%20repair:%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3C!--icon_content_start--%3E%3C!--icon_id_12051--%3E%0A%0A%3C/p%3E%0A%0A%3Cp%3E%3C/p%3E%0A%0A%0A%0A%3Ch2%3E%3Ca%20id=%223%22%20name=%223%22%3ERestore%20Unopened%20Excel%20Workbooks%20in%20MS%20Excel%20via%20Calculation%20Option%3C/a%3E%3C/h2%3E%0A%0A%0A%0A%3Cp%3EChange%20the%20calculation%20settings%20from%20Automatic%20to%20Manual%20may%20help%20you%20to%20%3Ca%20href=%22/data-recovery/corrupt-excel-file.html%22%3Efix%20a%20corrupted%20Excel%20file%3C/a%3E:%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep%201%3C/b%3E.%20Open%20the%20Microsoft Excel%20file%20and%20click%20%22File%22%20>%20%22New%22.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep%202%3C/b%3E.%20Click%20Blank%20workbook%20under%20New.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep%203%3C/b%3E.%20Go%20to %22File%22%20>%20%22Options%22.%20Then%20click%20the%20Manual%20option%20under%20Calculation%20options%20in%20the%20Formulas%20category%20and%20tap%20on%20the%20%22OK%22%20button.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep%204%3C/b%3E.%20Find%20the%20corrupted%20Excel%20file%20and%20double-click%20to%20open%20it.%20You%20will%20then%20be%20able%20to%20see%20the%20data%20you%20saved%20in%20Excel.%3C/p%3E%0A%0A%0A%0A%3Cp%3ERemember%20to%20share%20this%20post%20on%20your%20social%20media,%20like%20Twitter,%20to%20show%20more%20users%20how%20to%20recover%20Excel%20corrupt%20files:%3C/p%3E%0A%0A%0A%0A%3Cdiv%20class=%22sharethis-inline-share-buttons%22%3E %3C/div%3E%0A%0A%0A%0A%3Ch2%3E%3Ca%20id=%224%22%20name=%224%22%3EOpen%20Recover%20Excel%20Corrupted%20File%20with%20External%20References%3C/a%3E%3C/h2%3E%0A%0A%0A%0A%3Cp%3EYou%20can%20use%20the%20external%20preferences%20to%20recover%20the%20data%20from%20your%20workbook%20if%20it%20is%20corrupted.%20Follow%20the%20steps%20here:%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep%201%3C/b%3E.%20Open%20Office%20Excel%20and%20follow%20%22File%22%20>%20%22Open%22.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep 2%3C/b%3E.%20Go%20to%20the%20folder%20where%20the%20corrupted%20Excel%20is,%20right-click%20it,%20and%20select%20%22Copy%22 >%20%22Cancel%22.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep 3%3C/b%3E.%20Navigate%20to %22File%22%20>%20%22New%22%20>%20%22Blank%20workbook%22.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep 4%3C/b%3E.%20Type%20the%20following%20command%20and%20then%20hit%20Enter.%3C/p%3E%0A%0A%0A%0A%3Cdiv%20style=%22background:#eeeeee;border:1px%20solid%20#cccccc;padding:5px%2010px;%22%3E%3Cstrong%3E=File%20Name!A1%20in%20cell%20A1%20(Replace%20File%20Name%20with%20the%20name%20of%20corrupted%20Excel%20file.)%3C/strong%3E%3C/div%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep 5%3C/b%3E.%20Select%20corrupted%20Excel%20if%20the%20Update%20Values%20box%20appears%20and%20click%20OK.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep 6%3C/b%3E.%20Select%20cell%20A1%20and%20click%20%22Home%22%20>%20%22Copy%22.%20Then,%20select%20an%20area%20from%20cell%201%20for%20all%20cells%20that%20contain%20data%20in%20the%20corrupted%20Excel%20sheet.%3C/p%3E%0A%0A%0A%0A%0A%0A%0A%0A%3Cp%3E%3Cb%3EStep 7%3C/b%3E.%20Go%20to%20%22Home%22%20>%20%22Paste%22.%3C/p%3E%0A%0A%0A%0A%3Ch2%3E%3Ca%20id=%225%22%20name=%225%22%3EPerform%20Corrupted%20Excel%20File%20Recovery%20with%20Macro%3C/a%3E%3C/h2%3E%0A%0A%0A%0A%3Cp%3EIf%20your%20chart%20is%20linked%20to%20the%20corrupted%20workbook,%20you%20need%20to%20try%20using%20the%20%3Ca%20href=%22https://en.wikipedia.org/wiki/Macro_(computer_science)%22%20rel=%22noopener%22%20target=%22_blank%22%3Emacro%3C/a%3E%20to%20extract%20the%20source%20data.%20It%20is%20a%20bit%20complex,%20for%20you%20need%20to%20type%20the%20command.%3C/p%3E%0A%0A%0A%0A%3Cp%3EFollow%20the%20steps%20here%20to%20recover%20corrupted%20Excel%20files:%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%201.%3C/strong%3E%20Copy%20and%20paste%20the%20following%20macro%20code into%20a%20module%20sheet:%3C/p%3E%0A%0A%0A%0A%3Cdiv%20class=%22step_bg%22%3E%0A%0A%3Col%3E%0A%0A%09%3Cli%3E%3Cstrong%3ESub%20GetChartValues()%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EDim%20NumberOfRows%20As%20Integer%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EDim%20X%20As%20Object%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3ECounter%20=%202%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E'%20Calculate%20the%20number%20of%20rows%20of%20data.%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3ENumberOfRows%20=%20UBound(ActiveChart.SeriesCollection(1).Values)%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EWorksheets(%22ChartData%22).Cells(1,%201)%20=%20%22X%20Values%22%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E'%20Write%20x-axis%20values%20to%20worksheet.%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EWith%20Worksheets(%22ChartData%22)%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E.Range(.Cells(2,%201),%20_%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E.Cells(NumberOfRows%20+%201,%201))%20=%20_%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EApplication.Transpose(ActiveChart.SeriesCollection(1).XValues)%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EEnd%20With%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E'%20Loop%20through%20all%20series%20in%20the%20chart%20and%20write%20their%20values%20to%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E'%20the%20worksheet.%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EFor%20Each%20X%20In%20ActiveChart.SeriesCollection%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EWorksheets(%22ChartData%22).Cells(1,%20Counter)%20=%20X.Name%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EWith%20Worksheets(%22ChartData%22)%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E.Range(.Cells(2,%20Counter),%20_%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3E.Cells(NumberOfRows%20+%201,%20Counter))%20=%20_%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EApplication.Transpose(X.Values)%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EEnd%20With%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3ECounter%20=%20Counter%20+%201%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3ENext%3C/strong%3E%3C/li%3E%0A%0A%09%3Cli%3E%3Cstrong%3EEnd%20Sub%3C/strong%3E%3C/li%3E%0A%0A%3C/ol%3E%0A%0A%3C/div%3E%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%202.%20%3C/strong%3EYou%20need%20now%20insert%20or%20delete%20a%20worksheet%20in%20your%20workbook.%20Right-click%20on%20the%20sheet%20tab%20and%20change%20its%20name%20to%20ChartData.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3Cstrong%3EStep%203.%20%3C/strong%3EChoose%20the%20chart%20from%20which%20you%20want%20to%20extract%20data%20and%20run%20the%20macro.%3C/p%3E%0A%0A%0A%0A%3Ch2%3EClosure%3C/h2%3E%0A%0A%0A%0A%3Cp%3EThis%20post%20has%20looked%20at%20a%20few%20workable%20ways%20to recover%20corrupted%20Excel%20file%20in%20Windows%2010.%20Actually,%20most%20methods%20can%20be%20completed%20within%20Microsoft%20Excel%20itself.%20But%20if%20you%20want%20to recover%20corrupt%20Excel%20file,%20use%20professional%20document%20repair%20like%20EaseUS%20Fixo%20Document%20Repair.%3C/p%3E%0A%0A%0A%0A%3Cp%3E%3C!--icon_content_start--%3E%3C!--icon_id_12051--%3E%0A%0A%3C/p%3E%0A%0A%3Cp%3E%3C/p%3E%0A%0A%0A%0A%3Ch2%3EFAQs%20on%20How%20to%20Recover%20Corrupted%20Excel%20File%202016%3C/h2%3E%0A%0A%0A%0A%3Cp%3EThis%20part%20will%20include%20some%20frequently%20asked%20questions%20on%20Excel%20to%20recover%20corrupted%20files.%20Read%20on!%3C/p%3E%0A%0A%0A%0A%3Ch3%3E1.%20What%20to%20do%20when%20Excel%20says%20the%20file%20is%20corrupted?%3C/h3%3E%0A%0A%0A%0A%3Cp%3EYou%20can%20first%20try%20the%20open%20and%20repair%20feature%20of%20Excel%20to%20fix%20corrupted%20Excel%20files.%20If%20this%20way%20fails%20to%20work,%20use%20document%20repair%20software%20like %3Ca%20class=%22anchor%22%20data-category=%22article_user_experience%22%20data-event=%22eclick_text_anchor%22%20data-event_label=%22article%22%20href=%22#1%22%3EEaseUS%20Fixo%20Document%20Repair%3C/a%3E%20to%20solve%20this%20Excel%20error%3C/p%3E%0A%0A%0A%0A%3Ch3%3E2. How%20do%20I%20recover%20a%20crashed%20Excel%20File%20in%20Windows%2010?%3C/h3%3E%0A%0A%0A%0A%3Cp%3EYou%20can%20recover%20these%20unsaved%20Excel%20files%20after%20the%20computer%20crashes%20or%20Excel%20crashes.%20Follow%20the%20steps%20here:%3C/p%3E%0A%0A%0A%0A%3Cul%3E%0A%0A%09%3Cli%3EGo%20to%20%22File%22%20>%20%22Open%22%3C/li%3E%0A%0A%09%3Cli%3ESelect%20the%20recent%20Workbook %3C/li%3E%0A%0A%09%3Cli%3EScroll%20to%20find%20and%20click%20on%20%22Recover%20Unsaved%20Workbooks%22%3C/li%3E%0A%0A%3C/ul%3E%0A%0A%0A%0A%3Ch3%3E3. How%20do%20I%20repair%20Excel%20in%20Windows?%3C/h3%3E%0A%0A%0A%0A%3Cp%3EUse%20the%20Open%20and%20Repair%20feature%20of%20Microsoft%20Office%20Suite:%3C/p%3E%0A%0A%0A%0A%3Cul%3E%0A%0A%09%3Cli%3EOpen%20Microsoft%20Excel%20and%20follow%20the%20path%20here:%20%22File%22%20>%20%22Open%22>%20%22Browse%22.%3C/li%3E%0A%0A%09%3Cli%3ESelect%20the%20files%20you%20want%20to%20repair%20can%20click%20the%20arrow%20next%20to%20Open.%3C/li%3E%0A%0A%09%3Cli%3ETap%20on%20%22Open%20and%20Repair%22%20to%20repair%20corrupted%20Excel%20files%3C/li%3E%0A%0A%3C/ul%3E%0A%0A