Methods to Recover Corrupted Files in Microsoft Excel.ppt

《Methods to Recover Corrupted Files in Microsoft Excel.ppt》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、MethodstoRecoverCorruptedFilesinMicrosoftExcelWendalDorseyProductSupportProfessionalPremierApplicationsSupportMicrosoftCorporation2TopicsCoveredWhatisfilecorruptioninMicrosoft®Excel?Generalcorruptedfiletroubleshooting;troubleshootingcorruptioninExcel97

2、TroubleshootingcorruptioninExcel2000TroubleshootingcorruptioninExcel2002(OfficeXP)Suggestedreadingandadditionalresources3ImportantNotesAboutThisPresentationNoneofthefollowingtroubleshootingstepsisa“cure-all”;thereisno“magicbullet”thatwillworkinallcases.Kn

3、ownissuescansometimesappeartobefilecorruption.Donotassumethatafileiscorrupted!ChecktheMicrosoftKnowledgeBaseathttp://support.microsoft.com/forknownissuesrelatedtowhatishappeningand/orwhatstepscausetheissuetooccur.4WhatIsCorruption?FiledoesnotopenFiledoesn

4、otopen;youreceiveanerrormessageExcelstopsresponding(crashes)whileattemptingtoopenafileFileopens,butcausesproblemsExcelcrasheswhileyouareworkingFilecannotbesavedFiledoesnotfunctionasexpectedFormulasarenotproperlycalculatedSomefunctionalityisimpairedorisnot

5、functional5WhatIsCorruption?(2)Ingeneral,ifafileexhibitsunexpectedbehavior,willnotopen,orcausesproblemstotheapplicationwhenitisopened,thatfilemaybecorrupted.Note:Corruptionoccursinmanydifferentformsformanydifferentreasons.Thereisoftennowaytotellwhatcaused

6、afiletobecomecorrupted!6GeneralExcel97CorruptedFileTroubleshootingNobuilt-incorruptionrecoveryfunctionalitypriortoExcel2002(OfficeXP)LeastnumberofoptionsinExcel97Inallversions,troubleshootingislimitedifthefiledoesnotopenAttempttoopenthefileonanothercomput

7、erAttempttolinktothefiletoextractdata7GeneralExcel97CorruptedFileTroubleshooting(2)IftheFileDoesOpenManualre-creationoftheworkbookusingcopyandpasteLongprocesswithmanyobstacles(definednames,links,potentialforcopyingcorruption)Workbookrecovery:Macroutilitya

8、vailableonMicrosoftWebsitehttp://download.microsoft.com/download/excel97win/util/1/WIN98/EN-US/Recover.exeIfpossible,troubleshootthefileinExcel2000or20028GeneralExcel97CorruptedFileTroubleshooting(3)WhenFormulasDon’