Tshawb nrhiav cov txheej txheem pov thawj kom rov qab tau cov ntaub ntawv Excel tsis raug, los ntawm cov yam ntxwv hauv Excel dawb rau cov txheej txheem siab heev thiab cov cuab yeej kho tshwj xeeb.
1. Nkag siab txog Excel File Corruption
Excel cov ntaub ntawv kev noj nyiaj txiag tsim teeb meem loj rau cov lag luam thiab cov tib neeg. Hauv seem no, peb yuav tham txog txhua yam ntawm Excel cov ntaub ntawv kev noj nyiaj txiag.
1.1 Feem ntau ua rau Excel File Corruption
Hauv qab no yog qee qhov laj thawj ntawm Excel cov ntaub ntawv kev noj nyiaj txiag:
- Lub khoos phis tawj tsis xav tau kaw los ntawm lub zog hluav taws xob, teeb meem kho vajtse lossis software.
- Virus tawm tsam thiab malware.
- Hard disks ua tsis tiav, tshwj xeeb tshaj yog thaum Excel cov ntaub ntawv khaws cia hauv cov haujlwm cuam tshuam.
- Cov ntaub ntawv loj nrog ntau cov qauv thiab cov kev sib txuas muaj kev pheej hmoo siab dua ntawm kev puas tsuaj.
- Ntau tus neeg siv sim nkag mus rau tib cov ntaub ntawv ib txhij.
- Nkag mus rau Excel cov ntaub ntawv ntawm lub network drive.
1.2 Cov lus qhia muaj txiaj ntsig los tiv thaiv Excel File Corruption
Peb tau sau tseg ntau cov lus qhia tseem ceeb los tiv thaiv Excel cov ntaub ntawv kev noj nyiaj txiag. Txawm li cas los xij, thaum nws tshwm sim tiag tiag, koj tseem xav tau txoj hauv kev zoo los kho cov ntaub ntawv corrupted.
1.3 Cov cim qhia ntawm Corrupted Excel ntaub ntawv
Thaum corrupted, koj cov ntaub ntawv Excel yuav pom cov cim no:
- Cov ntaub ntawv qhib tsis tau
- Cov ntaub ntawv siv sijhawm ntev heev los thauj khoom
- Crashes los yog khov thaum ua haujlwm nquag
- Tsis muaj cov ntaub ntawv nkag lossis cov qauv
- Layout teeb meem los yog tawg headers
- Unreadable los yog random cim, los yog incomprehensible code
- Cov lus yuam kev uas pheej tshwm sim
- Cov kev hloov pauv yuav tsis txuag lossis hloov tshiab
- Cov teeb meem uas tsis tau npaj tseg thaum lub sijhawm ua haujlwm txuag
- AutoRecover tsis ua haujlwm
1.4 Cov lus yuam kev thaum cov ntaub ntawv yog Corrupted
Hauv qab no yog cov lus yuam kev uas koj yuav pom thaum Excel cov ntaub ntawv tsis raug, peb siv 'filename.xlsx' los qhia koj lub npe Excel ntaub ntawv tsis raug.
- Excel tsis tuaj yeem qhib cov ntawv 'filename.xlsx' vim tias cov foos ntawm cov ntawv txuas ntxiv tsis tau siv. Txheeb xyuas tias cov ntawv tsis tau tawg thiab hais tias cov ntawv txuas ntxiv tau raws li cov qauv ntawm cov ntawv. (Yuam Kev 101590)
- Excel tsis tuaj yeem qhib cov ntaub ntawv no. Cov ntawv foos lossis cov ntawv txuas ntxiv yog qhov siv tsis tau. Txheeb xyuas tias cov ntawv tsis tau tawg thiab hais tias cov ntawv txuas ntxiv tau raws li cov qauv ntawm cov ntawv.
- Excel tsis tuaj yeem qhib cov ntaub ntawv 'filename.xlsx' vim tias cov file format lossis file extension tsis siv tau. Txheeb xyuas tias cov ntawv tsis tau tawg thiab hais tias cov ntawv txuas ntxiv tau raws li cov qauv ntawm cov ntawv.
- Cov ntaub ntawv hom thiab txuas ntxiv ntawm 'filename.xls' tsis phim. Cov ntaub ntawv yuav raug corrupted los yog tsis zoo. Tshwj tsis yog tias koj ntseeg nws qhov chaw, tsis txhob qhib nws. Koj puas xav qhib nws lawm?
- Cov ntaub ntawv tsis ncaj thiab tsis tuaj yeem qhib.
- Cov ntaub ntawv no tsis yog hom pom tau.
* Yog tias koj paub cov ntaub ntawv yog los ntawm lwm qhov program uas tsis sib xws nrog Microsoft Office Excel, nyem Cancel, ces qhib cov ntawv no hauv nws daim ntawv thov thawj. Yog tias koj xav qhib cov ntawv tom qab hauv Microsoft Office Excel, khaws nws tawm ua hom ntawv uas tau haum, xws li hom ntawv nyeem
* Yog tias koj xav tias cov ntaub ntawv tsis raug, nyem Pab kom paub ntxiv txog kev daws cov teeb meem.
* Yog tias koj tseem xav saib cov ntawv sau dab tsi nyob hauv cov ntawv, nyem OK. Tom qab ntawd nyem Tiav hauv Cov Ntawv Ntshuam Xov Xwm. - Cov ntaub ntawv Excel tsis yog nyob rau hauv hom pom tau.
- Excel pom cov ntsiab lus tsis tau nyeem hauv . Koj puas xav rov qab cov ntsiab lus ntawm phau ntawv no? Yog tias koj ntseeg lub hauv paus ntawm phau ntawv no, nyem Yes.
- Cov ntaub ntawv ua tsis tau zoo thiab tsis tuaj yeem qhib. Txhawm rau sim thiab kho nws, siv qhib thiab Kho qhov hais kom ua nyob rau hauv Qhib Qhib lub thawv, thiab xaiv "Extract Data" thaum hais kom sai.
- Nyeem tsis tau ntawv.
- 'filename.xls' tsis tuaj yeem nkag mus. Daim ntawv tsuas yog nyeem tau nkaus xwb, lossis koj tuaj yeem sim nkag mus nyeem cov chaw nyeem ntawv nkaus xwb. Los yog, cov neeg rau zaub mov daim ntawv khaws tseg rau ntawm yuav tsis muaj teb.
- Microsoft Excel tau tso tseg tsis ua haujlwm lawm.
- Lub converter tsis tau qhib cov ntaub ntawv.
- Lub hloov pauv tsim nyog los qhib cov ntaub ntawv no tsis tuaj yeem pom.
- Peb pom muaj teeb meem nrog qee cov ntsiab lus hauv 'filename.xlsx'. Koj puas xav kom peb sim rov qab ntau li ntau tau? Yog tias koj ntseeg lub hauv paus ntawm phau ntawv no, nyem Yes.
- Thov txim, peb nrhiav tsis tau filename.xlsx. Puas yog nws ua tau tsiv, hloov npe lossis tshem tawm?
1.5 Qhov cuam tshuam rau kev ua lag luam
Cov ntaub ntawv kev noj nyiaj txiag cuam tshuam rau kev lag luam kev lag luam hnyav. Cov lag luam me ntsib kev pheej hmoo siab dua, thiab FEMA tshaj tawm 40% yeej tsis rov qhib dua tom qab poob lawv cov ntaub ntawv. Qhov xwm txheej dhau los ua qhov tseem ceeb tshaj vim tias 88% ntawm cov ntawv nthuav tawm muaj qhov yuam kev. Cov kev ua yuam kev no ua rau cov ntaub ntawv yooj yim rau kev dag, kev noj nyiaj txiag, thiab kev tswj tsis raug. Cov ntaub ntawv ncaj ncees yog qhov tseem ceeb rau kev ua haujlwm ruaj khov thiab kev ruaj ntseg nyiaj txiag.
2. Txoj hauv kev pub dawb los kho corrupted Excel ntaub ntawv
Microsoft Excel los nrog cov cuab yeej tsim muaj zog uas pab cov neeg siv rov qab tau cov ntaub ntawv Excel tsis zoo yam tsis xav tau software thib peb. Cov yam ntxwv no ua raws li koj qhov kev tiv thaiv thawj zaug thaum cov ntaub ntawv tau corrupted.
2.1 Siv Excel's Open and Repair Feature
Excel muaj cov txheej txheem kho ua ke los ntawm nws qhov Open and Repair feature. Koj tuaj yeem siv qhov no los ntawm kev ua raws li cov kauj ruam no:
- In Excel, nyem cov ntaub ntawv > Qhib
- Xaiv cov ntaub ntawv corrupted Excel
- Nyem tus xub nyob ib sab ntawm Qhib khawm
- xaiv Qhib thiab Kho
- xaiv kho kom rov qab tau cov ntaub ntawv siab tshaj plaws
- Yog tias qhov ntawd tsis ua haujlwm, siv Cov ntaub ntawv suav mus muab qhov tseem ceeb thiab cov qauv
Yog xav paub ntxiv, koj tuaj yeem mus saib tau Microsoft nplooj ntawv official .
2.2 Rov qab los ntawm AutoRecover
Excel tiv thaiv koj txoj haujlwm tau txais los ntawm AutoRecover feature. Qhov no feature yuav pib-txuag unsaved versions ntawm koj workbooks rau ib qho chaw tshwj xeeb ntawm lub sij hawm teem.
2.2.1 Teeb AutoRecover
Koj tuaj yeem teeb tsa AutoRecover raws li hauv qab no:
- In Excel, qhib cov ntaub ntawv > Options > Txuag
- pab kom Txuag AutoRecover cov ntaub ntawv (Enabled los ntawm default)
- Teem lub sijhawm ncua sijhawm (default yog 10 feeb)
- xyuas AutoRecover cov ntaub ntawv qhov chaw
2.2.2 Yuav Ua Li Cas AutoRecover Ua Haujlwm
Cia peb piav qhia yuav ua li cas AutoRecover ua haujlwm:
- Thaum koj tsim ib cov ntaub ntawv Test.xlsx, ces ua ib qho kev hloov rau nws, tab sis tsis txhob txuag nws. Tom qab ntawd tom qab lub sij hawm preset lub sij hawm, AutoRecover yuav tsim ib tug subfolder nyob rau hauv preset AutoSave cov ntaub ntawv qhov chaw, zoo li no:
C:\Users\ccw\AppData\Roaming\Microsoft\Excel\Test#####
nyob qhov twg ##### yog tus cim tshwj xeeb Excel siv kom paub qhov txawv ntawm qhov sib txawv AutoRecover zaug. Tom qab ntawd nws yuav txuag qhov kev hloov pauv mus rau qhov pib rov qab ua ntaub ntawv Test((autorecovered-#####)).xlsb. Tus lej ntev hauv kab lus yog tus cim tshwj xeeb Excel siv los sib txawv ntawm cov kev hloov pauv sib txawv. Daim ntawv ceeb toom lawv tau txais kev cawmdim li .xlsb (Microsoft Excel Binary Worksheet) hom ntawv rau kev ua tau zoo dua thiab cov ntaub ntawv me me, txawm tias koj cov ntaub ntawv qub yog .xlsx.
- Yog tias tom qab koj txuag Test.xlsx, AutoRecover yuav TSIS rho tawm thawj cov ntaub ntawv rov qab pib pib.
- Yog tias koj ua lwm qhov kev hloov pauv ntawm cov ntaub ntawv, tab sis tsis txhob khaws nws. Tom qab ntawd tom qab lub sijhawm preset lub sijhawm, AutoRecover yuav txuag qhov kev hloov pauv mus rau 2nd nws pib rov qab cov ntaub ntawv Test((autorecovered-#####)).xlsb, nrog tus cim tshwj xeeb sib txawv kom sib txawv ntawm nws tus kheej los ntawm thawj cov ntaub ntawv rov qab pib.
- Cov txheej txheem saum toj no yuav txuas ntxiv yog tias koj hloov pauv tsis tu ncua tab sis tsis txhob txuag lawv ua ntej lub sijhawm preset lub sijhawm dhau mus. Yog li tej zaum yuav muaj ntau yam pib rov qab cov ntaub ntawv nyob rau hauv subfolder.
- Yog tias kawg, koj kaw Test.xlsx tab sis xaiv TSIS kom txuag tau nws, ces tag nrho cov ntaub ntawv rov qab pib yuav raug muab tshem tawm tsuas yog qhov tseeb, uas yuav raug hloov npe mus rau cov ntaub ntawv tsis tau khaws tseg, Test((Unsaved-#####)).xlsb, qhov twg tus cim tshwj xeeb ##### zoo ib yam rau cov ntaub ntawv rov qab tau zoo sib xws:
- Yog tias koj xaiv "Txuag", tag nrho cov ntaub ntawv rov qab tau pib thiab cov ntaub ntawv tsis tau khaws tseg yav dhau los yuav raug muab tshem tawm, thiab cov subfolder nws tus kheej yuav raug tshem tawm thiab. Lwm lub sij hawm thaum koj qhib thiab kho tib cov ntaub ntawv, AutoRecover yuav tsim ib tug tshiab subfolder Test #### nrog ib tug txawv tus cim.
2.2.3 Ib qho piv txwv tiag
Hauv qab no yog ib qho piv txwv tiag tiag:
Los ntawm cov qauv no, peb tuaj yeem pom:
- Test311582750060201638 yog AutoRecover subfolder rau Test.xlsx.
- Test((Unsaved-311583441505446697)).xlsb yog lub unsaved version ua ntej lub xeem kaw ntawm cov ntaub ntawv.
- Cov ntaub ntawv hauv qab no yog cov ntaub ntawv rov qab tau pib tom qab qhib kawg ntawm cov ntaub ntawv:
Test((Autorecovered-311583633426885544)).xlsb Test((Autorecovered-311583641215697279)).xlsb Test((Autorecovered-311583653173513157)).xlsb
Lub sij hawm stamps rau cov ntaub ntawv no yuav tshiab dua li cov ntaub ntawv tsis tau khaws cia.
- Test.xlsx yog shortcut rau cov ntaub ntawv tiag Test.xlsx.
2.2.4 Siv AutoRecover thaum koj cov ntaub ntawv tsis raug
Tam sim no txoj xov zoo yog tias AutoRecover yog enabled los ntawm neej ntawd hais. Yog li yog tias koj tsis tuaj yeem qhib thiab rov qab tau cov ntaub ntawv Excel tsis raug, koj tuaj yeem rov qab tau cov ntaub ntawv tsis ntev los no ntawm AutoRecover feature.
2.2.5 Siv cov "Rov qab Unsaved Workbooks" Feature
- In Excel, nyem cov ntaub ntawv > Qhib
- Nyem Rov Ua Haujlwm Cov Ntawv Tsis Zoo khawm
- Nrhiav thiab xaiv cov ntaub ntawv .xlsb rau koj cov ntaub ntawv tsis raug hauv AutoRecover cov ntaub ntawv qhov chaw. Txawm hais tias unsaved version los yog nws pib rov qab version yog OK. Tsuas yog xaiv ib qho nrog koj cov ntsiab lus xav tau.
2.2.6 Nrhiav thiab rov qab tau cov ntaub ntawv manually
Koj tseem tuaj yeem qhib qhov "AutoRecover file qhov chaw" thiab nrhiav cov ntaub ntawv xav tau:
- Luam theej "AutoRecover file location" hauv Excel.
- Paste nws rau Windows File Explorer.
2.2.7 Siv "Cov ntaub ntawv rov qab" vaj huam sib luag
Yog tias koj cov ntaub ntawv tau corrupted vim yog qhov kev npaj txhij txog kaw ntawm Excel, tom qab ntawd thaum koj siv Excel qhib nws dua, dua li cov lus yuam kev hais tias koj cov ntaub ntawv tsis raug, koj tseem yuav pom "Cov Ntaub Ntawv Rov Qab" vaj huam sib luag nyob rau sab laug, uas muab Qee cov ntaub ntawv ntxiv txog qhov sib txawv versions, yog li koj tuaj yeem xaiv qhov koj xav tau:
Qee zaum thaum koj nyem ib lub version, koj tseem yuav tau txais cov lus yuam kev hais tias Excel tsis qhib nws. Hauv qhov xwm txheej zoo li no, sim lwm qhov hloov pauv mus txog thaum koj pom ib qho kev noj qab haus huv.
2.2.8 Cov Lus Tseem Ceeb
- AutoRecover yog TSIS AutoSave, lwm qhov tshwj xeeb tau piav qhia hauv qab no.
- AutoRecover yog TSIS auto thaub qab. Nws yuav TSIS khaws cov ntawv tsis tau khaws cia yog tias koj khaws koj cov ntaub ntawv ua ntej lub sijhawm ncua sijhawm. Nws kuj yuav TSIS khaws cov intermediary version yog tias koj khaws koj cov ntaub ntawv thiab kaw nws. Txhawm rau pib thaub qab koj cov ntaub ntawv, koj yuav tsum ua kom muaj lwm txoj kev xaiv tau piav qhia hauv qab no.
- Txhawm rau kom muaj feem yuav rov qab tau cov ntaub ntawv ntawm AutoRecover, koj tuaj yeem txo lub sijhawm ncua mus rau qhov tsawg kawg nkaus ntawm 1 feeb. Txawm li cas los xij, qhov no yuav txo qis Excel kev ua haujlwm thaum ua cov ntaub ntawv loj.
Koj tuaj yeem nrhiav AutoRecover cov ntaub ntawv hauv Microsoft nplooj ntawv official ib yam nkaus. Txawm li cas los xij, lawv tsis muab cov ntaub ntawv nthuav dav zoo li peb ua.
2.3 Rov qab los ntawm AutoSave
AutoSave yog lwm qhov tshwj xeeb uas tuaj yeem pab koj thaum koj cov ntaub ntawv tsis raug. Ntau tus neeg feem ntau tsis meej pem AutoRecover thiab AutoSave, yuam kev ntseeg tias lawv zoo ib yam, tab sis qhov tseeb, lawv txawv kiag li. AutoSave, thaum qhib, yuav pib txuag koj cov ntaub ntawv rau huab cia xws li OneDrive, txhua ob peb feeb.
AutoSave tsuas yog muaj nyob hauv Excel rau Microsoft 365. Nws tau qhib los ntawm lub neej ntawd rau cov ntaub ntawv ntawm OneDrive, OneDrive rau Kev Lag Luam, lossis SharePoint Online. Tab sis neeg xiam rau cov ntaub ntawv ntawm lub computer hauv zos.
2.3.1 AutoSave Option
Koj tuaj yeem nrhiav AutoSave kev xaiv los ntawm:
- In Excel, qhib cov ntaub ntawv > Options > Txuag
- Koj tuaj yeem nrhiav tau AutoSave cov ntaub ntawv khaws cia hauv Huab los ntawm lub neej ntawd hauv Excel kev xaiv. Nws yog enabled los ntawm lub neej ntawd thiab peb xav kom koj ib txwm cia nws enabled tshwj tsis yog rau cov xwm txheej tshwj xeeb.
2.3.2 Pab kom AutoSave rau cov ntaub ntawv hauv zos
Nws kuj tseem tuaj yeem ua kom AutoSave rau cov ntaub ntawv ntawm lub zos tsav, raws li hauv qab no:
- Qhib cov ntaub ntawv hauv zos hauv Excel
- Qhib lub AutoSave toggle nyob rau sab saum toj-sab laug ces kaum.
- Ib tug dialog yuav pop. Tom qab ntawd koj tuaj yeem xaiv Cloud drive khaws cov ntaub ntawv nws pib-txuag.
- Txij thaum ntawd los, koj cov ntaub ntawv hauv zos yuav raug xa mus rau Cloud drive. Thiab tag nrho cov kev hloov tshiab yav tom ntej yuav raug cawm nyob rau ntawd. Cov ntaub ntawv hauv zos yuav TSIS hloov tshiab lawm.
2.3.3 Rov qab Corrupted Excel ntaub ntawv
Thaum koj cov ntaub ntawv ntawm Huab yog qhov tsis raug, koj tuaj yeem siv "Version History" ua haujlwm hauv AutoSave kom rov qab mus rau ib qho qub version uas noj qab nyob zoo:
- In Excel, nyem lub npe cov ntaub ntawv nyob rau sab saum toj bar.
- Hauv cov ntawv qhia zaub mov popup, nyem version keeb kwm.
- Cov keeb kwm version yuav qhia nyob rau hauv txoj cai vaj huam sib luag.
- Nyem qhov version koj xav rov qab:
- Hauv nruab nrab cov ntaub ntawv bar, nyem restore rov qab mus rau qhov version:
2.3.3 Kev ua tim khawv
- Microsoft official nplooj ntawv: AutoSave yog dab tsi?
- Microsoft official nplooj ntawv: Kuv yuav qhib AutoSave li cas?
2.4 Rov qab los ntawm Auto Backup
Koj tseem tuaj yeem tsim cov ntawv thaub qab tsis siv neeg. Qhov no tso cai rau koj nkag mus rau koj cov ntaub ntawv yog tias thawj cov ntaub ntawv ua corrupted. Txawm li cas los xij, tsis zoo li AutoRecover, nws pib thaub qab yog TSIS qhib los ntawm lub neej ntawd.
2.4.1 Qhib Auto Backup Manually
Enabling auto-backup yog yooj yim:
- In Excel, qhib cov ntaub ntawv uas koj xav teeb tsa lub auto-backup.
- xaiv cov ntaub ntawv > Txuag Li > Xauj.
- Nyem cuab yeej > General Options…
- Check Ib txwm tsim thaub qab kev xaiv thiab nias OK khawm.
- Nyem Txuag khawm thiab paub meej tias hloov cov ntaub ntawv uas twb muaj lawm.
Txij thaum ntawd los, yog tias thawj cov ntaub ntawv yog "Test.xlsx", yuav muaj "Thaub qab ntawm Test.xlk" cov ntaub ntawv rau nws. Nco ntsoov .xlk yog cov ntaub ntawv txuas ntxiv rau Microsoft Excel backup cov ntaub ntawv:
2.4.2 Lus Cim:
- Auto backup yog TSIS kev xaiv thoob ntiaj teb, tab sis ib qho kev xaiv ib cov ntaub ntawv. Yog tias koj qhib nws pib thaub qab rau ib cov ntaub ntawv, nws yuav TSIS enabled rau lwm tus.
- Auto backup yuav TSIS backup lub tam sim no version tab sis lub version ua ntej koj txuag. Thiab kev txuag kev ua haujlwm tau txuag cov kev hloov pauv rau cov ntaub ntawv qub, ua rau nws tam sim no version.
- Thawj zaug thaum koj siv "Txuag Raws li" txhawm rau txuag cov ntaub ntawv Excel tshiab nrog cov kev xaiv thaub qab, Excel yuav TSIS tsim cov ntaub ntawv thaub qab, vim tsis muaj version muaj ua ntej koj txuag.
- Yog hais tias tus thawj Excel cov ntaub ntawv yog corrupted thiab koj tau enabled nws pib-backup rau nws, ces koj yuav tau txais cov version ua ntej koj txuag los ntawm thaub qab.
- Thaum koj qhib cov ntaub ntawv .xlk thaub qab, koj yuav pom cov lus ceeb toom hauv qab no:
Cia li tsis quav ntsej nws thiab nyem Yog qhib cov ntaub ntawv.
2.4.3 Pab kom Auto Backup rau ib pawg ntawm cov ntaub ntawv
Txoj kev Excel VBA Phau ntawv.SaveAs muaj qhov xaiv tsis tau CreateBackup, uas tuaj yeem siv los pab kom nws pib thaub qab rau cov ntaub ntawv programminly. Yog li peb tuaj yeem sau ib tsab ntawv VBA yooj yim los pab kom nws pib thaub qab rau ib pawg ntawm cov ntaub ntawv:
Option Explicit Function BatchEnableBackup() Dim fd As FileDialog Dim i As Long Dim fileName As String Dim wb As Workbook Dim fileFormat As Long ' Configure file dialog Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .AllowMulti. Excel cov ntaub ntawv los qhib Thaub qab" .Filters.Clear .Filters.Ntxiv "Excel Files", "*.xls; *.xlsx; *.xlsb" Yog .Show <> -1 Ces Exit Function 'Tawm yog cov neeg siv tshem tawm End With ' Txheej txheem xaiv cov ntaub ntawv Rau i = 1 Rau fd.SelectedItems.Count fileName = fd.SelectedItems(i) ' Sim qhib Workbook On Error Resume Next Set wb = Workbooks.Open(fileName) On yuam kev GoTo 0 Yog Tsis yog wb Tsis Muaj Dab Tsi Ces Application.DisplayAlerts = False 'Suppress overwrite ceeb toom ' Txuag nrog thaub qab enabled On yuam kev Resume Next ' Hla cov ntaub ntawv uas ua tsis tau saved fileFormat = wb.fileFormat wb.SaveAs _ fileName:=fileName, _ fileFormat:=fileFormat, _ CreateBackup:=True On Error GoTo 0 Application.DisplayAlerts = True wb.Close SaveChanges:=False Set wb = Nothing End If Next i End Function
Koj tseem tuaj yeem rub tawm Excel cov ntaub ntawv nrog macro ncaj qha.
Lwm VBA cov cuab yeej nyeem nkaus xwb Workbook.CreateBackup tuaj yeem siv los txheeb xyuas yog tias nws pib thaub qab rau cov ntaub ntawv tau qhib lossis tsis tau.
Tsuas muaj tsawg heev cov ntaub ntawv hais txog qhov pib-backup feature ntawm lub Microsoft nplooj ntawv official .
2.5 Rov qab los ntawm phau ntawv txhais lus hom
Hloov hom kev xam los ntawm kev siv tsis siv neeg mus rau phau ntawv tuaj yeem tiv thaiv Excel los ntawm kev suav tag nrho cov qauv hauv phau ntawv ua haujlwm thaum qhib nws. Txoj kev no tuaj yeem pab qhib thiab rov qab tau qee cov ntaub ntawv Excel tsis raug yog tias lawv tsis xav tau rov suav dua.
Koj tuaj yeem hloov cov kev suav hauv qhov no:
- Hauv Excel, qhib lossis tsim phau ntawv ua haujlwm tshiab.
- Nyem cov ntaub ntawv > Options
- Mus rau qauv tab
- Nyob rau hauv Kev xaiv suav, xaiv phau ntawv rau Workbook xam.
- Tshem tawm Rov xam phau ntawv ua ntej txuag.
- Nyem OK kom txuag tau qhov kev hloov.
- Sim qhib cov ntaub ntawv tsis raug.
- Yog tias cov ntaub ntawv tuaj yeem qhib tau zoo, rov qab nws los ntawm kev txuag nws ua cov ntaub ntawv tshiab.
Microsoft muab cov ntaub ntawv ntau ntxiv ntawm Hloov cov qauv kev suav rov qab thiab hom kev xam tam sim no
.
2.6 Qhib cov ntaub ntawv hauv Safe Mode
Koj tuaj yeem sim qhib koj cov ntaub ntawv tsis raug rau hauv hom kev nyab xeeb . Yog tias nws tuaj yeem qhib tau tiav, khaws ib daim ntawv luam nrog lub npe sib txawv.
3. Advanced Techniques Recover Corrupt Excel Files
Cov txheej txheem rov qab zoo tshaj yog cov kev daws teeb meem zoo rau cov ntaub ntawv Excel uas puas lawm. Cov txheej txheem no pab peb tsom mus rau cov qauv tshwj xeeb thiab cov txheej txheem coding uas khaws cov ntaub ntawv los ntawm cov ntaub ntawv tsis raug.
3.1 SYLK Format Conversion Method
Cov ntaub ntawv Excel siv cov ntaub ntawv binary nyuaj kom nws thiaj li ua rau tsis raug. Yog tias qhov ntawd tshwm sim, koj tuaj yeem sim hloov nws mus rau cov ntawv nyeem, SYLK (Symbolic Link) hom ntawv, lim tawm cov ntsiab lus tsis raug, ces hloov nws rov qab rau Excel hom. Txoj kev no yog qhov tshwj xeeb tshaj yog rau cov teeb meem ntsig txog tshuab luam ntawv. Tab sis nws xav kom koj cov ntaub ntawv tsis raug tuaj yeem qhib hauv Excel.
Hauv qab no yog cov kauj ruam ntxaws:
- xaiv cov ntaub ntawv > Txuag Li
- xaiv SYLK (Symbolic Link) hom
- Sau npe rau daim ntawv actively piav qhia
- Nyem Txuag thiab paub meej tias hom kev hloov pauv
- Rov qhib cov ntaub ntawv khaws tseg .slk
- Txuag nws rov qab rau Excel hom nrog lub npe tshiab
SYLK hom muaj nws cov kev txwv. Nws tsuas yog txhawb nqa ib daim ntawv ua haujlwm xwb, yog li koj yuav tsum rov ua cov kauj ruam saum toj no ntau zaus rau ntau daim ntawv ua haujlwm. Txhawm rau daws qhov teeb meem no, peb tau tsim Excel VBA muaj nuj nqi, uas tuaj yeem kho ntau daim ntawv ua haujlwm ntawm SYLK txoj kev hloov pauv:
Option Explicit Function RepairExcelFileViaSYLKConversion(SrcFile As String, DstFile As String) As Boolean On Error GoTo ErrorHandler Dim srcWb As Workbook Dim dstWb As Workbook Dim tempWb As Workbook Dim slkWb As Workbook Dim ws As Worksheet Dim fso As Object Dim srcBaseName As String Dim dstPath As String Dim slkFileName As String Dim sheetName As String Dim sanitizedName As String Dim isFirst As Boolean Set fso = CreateObject("Scripting.FileSystemObject") Application.ScreenUpdating = False Application.DisplayAlerts = False ' Step 1: Open source workbook Set srcWb = Workbooks.Open(SrcFile) ' Get source base name srcBaseName = fso.GetBaseName(SrcFile) ' Step 2: Save each sheet as SYLK dstPath = fso.GetParentFolderName(DstFile) & "\" If Not fso.FolderExists(dstPath) Then fso.CreateFolder dstPath End If For Each ws In srcWb.Worksheets ' Sanitize sheet name for filename sanitizedName = SanitizeFileName(ws.name) slkFileName = dstPath & srcBaseName & "_" & sanitizedName & ".slk" ' Copy sheet to new workbook and save as SYLK ws.Copy Set tempWb = ActiveWorkbook tempWb.SaveAs Filename:=slkFileName, FileFormat:=xlSYLK tempWb.Close SaveChanges:=False Next ws ' Close source workbook srcWb.Close SaveChanges:=False ' Step 3 and 4: Create new workbook and merge SYLK files Set dstWb = Workbooks.Add isFirst = True ' Get list of SYLK files slkFileName = Dir(dstPath & srcBaseName & "_*.slk") Do While slkFileName <> "" ' Open SYLK file Application.DisplayAlerts = False Set slkWb = Workbooks.Open(dstPath & slkFileName) Application.DisplayAlerts = True ' Copy sheet to destination workbook If isFirst Then ' Copy before first sheet and delete original slkWb.Sheets(1).Copy Before:=dstWb.Sheets(1) Application.DisplayAlerts = False If dstWb.Sheets.Count > 1 Then dstWb.Sheets(2).Delete End If Application.DisplayAlerts = True isFirst = False Else slkWb.Sheets(1).Copy After:=dstWb.Sheets(dstWb.Sheets.Count) End If ' Extract sheet name from filename sheetName = Mid(fso.GetBaseName(slkFileName), Len(srcBaseName) + 2) ' Rename the sheet On Error Resume Next ' Ignore errors (e.g., duplicate name) dstWb.Sheets(dstWb.Sheets.Count).name = sheetName On Error GoTo ErrorHandler ' Resume normal error handling ' Close SYLK workbook slkWb.Close SaveChanges:=False ' Next file slkFileName = Dir() Loop ' Step 5: Save and close destination workbook Application.DisplayAlerts = False ' Suppress overwrite warning dstWb.SaveAs Filename:=DstFile Application.DisplayAlerts = True dstWb.Close SaveChanges:=True ' Cleanup Application.ScreenUpdating = True Application.DisplayAlerts = True RepairExcelFileViaSYLKConversion = True Exit Function ErrorHandler: ' Cleanup code On Error Resume Next If Not srcWb Is Nothing Then srcWb.Close SaveChanges:=False If Not tempWb Is Nothing Then tempWb.Close SaveChanges:=False If Not slkWb Is Nothing Then slkWb.Close SaveChanges:=False If Not dstWb Is Nothing Then dstWb.Close SaveChanges:=False Application.ScreenUpdating = True Application.DisplayAlerts = True RepairExcelFileViaSYLKConversion = False End Function Function SanitizeFileName(name As String) As String Dim invalidChars As String invalidChars = "\/:*?""<>|" Dim i As Long For i = 1 To Len(invalidChars) Dim c As String c = Mid(invalidChars, i, 1) name = Replace(name, c, "_") Next i SanitizeFileName = name End Function
Peb kuj tau tsim GUI rau txoj haujlwm no. Koj tuaj yeem rub tawm Excel cov ntaub ntawv nrog tag nrho cov haujlwm thiab GUIs thiab khiav tus neeg siv daim ntawv MainForm.
Tsuas muaj cov ntaub ntawv tsawg heev ntawm txoj kev no rau Microsoft lub vev xaib official .
3.2 Txoj Kev Hloov Hloov Nplooj Web
Zoo ib yam li SYLK hloov dua siab tshiab txoj kev, koj tuaj yeem hloov cov ntaub ntawv Excel tsis raug rau nplooj ntawv web (HTML) hom ntawv thiab rov qab mus rau Excel cov ntaub ntawv tshiab, txhawm rau tshem tawm kev ua tsis ncaj ncees.
Hauv qab no yog cov kauj ruam:
- xaiv cov ntaub ntawv > Txuag Li
- xaiv Txuag li ntaus rau Nplooj Web or Ib Nplooj Ntawv Cov Ntaub Ntawv.
- Nco ntsoov txuag Phau ntawv ua haujlwm tag nrho es tsis txhob Xaiv: Daim ntawv.
- Nyem Txuag, koj yuav pom cov lus ceeb toom hauv qab no, tsis quav ntsej nws thiab nyem OK kom txuag tau:
3.3 Sab Nraud References Recovery Approach
Cov ntaub ntawv sab nraud muab lwm txoj hauv kev los khaws cov ntaub ntawv thiab rov qab cov ntaub ntawv Excel tsis raug. Cov txheej txheem no tsim cov kev sib txuas mus rau phau ntawv ua haujlwm puas thiab tso cai rau kev rho tawm cov ntaub ntawv yam tsis muaj cov qauv los yog suav cov nqi.
3.3.1 Cov kauj ruam rov qab
- In Excel, tsim ib phau ntawv dawb huv tshiab thiab txuag nws.
- Hauv thawj lub xov tooj ntawm phau ntawv ua haujlwm, sau cov qauv hauv qab no:
=FileName!A1
, qhov twg FileName yog lub npe tsis raug Excel cov ntaub ntawv tsis muaj qhov txuas ntxiv. Piv txwv li, yog tias koj cov ntaub ntawv tsis raug yog Test.xlsx, ces tus qauv yuav yog=Test!A1
. Tom qab nkag rau cov qauv, nias Sau.
- Yog hais tias qhov hloov tshiab Values dialog tshwm, xauj thiab xaiv cov ntaub ntawv Excel tsis raug nrog cov txiaj ntsig rau kev siv sab nraud:
- Yog tias cov ntaub ntawv Excel tsis raug muaj ntau nplooj ntawv, koj yuav tsum xaiv daim ntawv rau cov ntaub ntawv siv sab nraud tam sim no:
- Xaiv lub A1 cell thiab nias Ctrl + C luam nws cov qauv.
- Starting los ntawm A1, xaiv qhov ntau yam uas hais txog tib yam lossis loj dua li cov ntaub ntawv ntau yam hauv phau ntawv ua haujlwm tsis raug, ces nias Ctrl + P muab tshuaj txhuam cov mis rau txhua lub hlwb hauv qhov kev xaiv.
- Tom qab pasting, lub Hloov tshiab tus nqi dialog tej zaum yuav pop up dua, xaiv cov thawj corrupt workbook thiab nias OK.
- Xyuas seb cov nqi ntawm tes puas raug. Cov hlwb nyob rau hauv qhov ntau ntawm cov ntaub ntawv qub yuav qhia qhov tseem ceeb hauv cov ntaub ntawv qub. Cov nyob sab nraum qhov ntau yuav pom zeros.
- Xaiv cov hlwb uas koj xav tau thiab nias Ctrl + C luam lawv.
- Tsim ib daim ntawv tshiab, nyem A1 cell, ces txoj nyem thiab xaiv Paste Values muab tso rau qhov tseem ceeb xwb. Ua li no, peb luam cov txiaj ntsig los ntawm cov ntaub ntawv tsis raug qub rau hauv daim ntawv tshiab. Yog tias peb xaiv muab tso ncaj qha, ces peb yuav tau txais cov qauv siv sab nraud dua, tsis yog qhov tseem ceeb.
3.3.2 Lus cim:
- Txoj kev no tsuas yog rov qab tau cov ntaub ntawv tseem ceeb. Nws yuav TSIS rov qab cov qauv, formattings, kab kos, daim ntawv, thiab macros.
- Yog tias koj ntsib qhov yuam kev hauv kauj ruam 6, txo qhov ntau kom txog thaum ua tiav.
Koj tuaj yeem nrhiav cov ntaub ntawv ntawm txoj kev no hauv lub official Microsoft nplooj ntawv .
3.4 Siv Qhib XML SDK Tool
Koj tuaj yeem siv Open XML SDK cov cuab yeej los nrhiav thiab kho cov ntu tsis raug hauv koj cov ntaub ntawv. Txhawm rau ua qhov no, thov:
- Download tau lub Qhib XML SDK thiab nws nruab.
- Download tau lub Qhib XML SDK Productivity Tool rau Microsoft Office thiab nws nruab.
- Start tus Qhib XML SDK Productivity Tool rau Microsoft Office
- Nyem File> Qhib File… qhib cov ntaub ntawv Excel tsis raug.
- Nyem Kev Ua> validate txhawm rau txheeb xyuas cov ntaub ntawv Excel thiab pom cov teeb meem hauv cov ntaub ntawv:
- Xyuas qhov Validation Result thiab kho qhov yuam kev hauv cov ntaub ntawv manually:
Nco ntsoov: Txoj hauv kev no xav kom koj muaj kev txawj ntse IT xws li programming thiab paub txog Office Open XML file formats, yog li yuav tsis ua haujlwm rau cov neeg siv Excel nruab nrab.
3.5 Rov qab VBA Codes thiab Macros
Cov phau ntawv ua haujlwm nrog cov lej VBA muaj txiaj ntsig thiab macros xav tau txoj hauv kev tshwj xeeb rov qab, raws li hauv qab no:
- Start Excel tsis launching cov ntaub ntawv corrupted.
- teem Phau Ntawv Ua Haujlwm hom rau phau ntawv.
- Clik cov ntaub ntawv > Options.
- In Chaw Cia Siab tab, nias Chaw Cia Siab:
- Nyob rau hauv lub popup Chaw Cia Siab dialog, nias Macro Chaw tab thiab xaiv Diable tag nrho macros yam tsis tau ceeb toom, ces nias OK:
- Tam sim no tag nrho cov kev suav pib thiab macros tau raug kaw lawm.
- Tom qab ntawd koj tuaj yeem qhib cov ntaub ntawv corrupted. Yog tias Excel tuaj yeem qhib tau tiav, yuav muaj TSIS MUAJ ceeb toom hais tias macros tau raug kaw, txij li peb tau xaiv qhov kev xaiv tsis ceeb toom. Yog tias Excel tsis qhib nws, ces koj CEEV FAJ siv txoj kev no kom rov qab tau cov lej ntxiv lawm.
- Xovxwm Alt + F11 qhib Visual Basic Editor.
- Xauj VBAProject thiab xaiv cov khoom xav tau, xws li Daim Ntawv lossis Module, tom qab ntawd nyem rau nws thiab xaiv Export File… export cov khoom manually:
- Rov ua kauj ruam 9 kom txog thaum tag nrho koj cov khoom xav tau raug xa tawm.
- Kaw Visual Basic Editor thiab cov ntaub ntawv tam sim no.
- Tsim ib phau ntawv ua haujlwm tshiab thiab import tag nrho cov khoom rov qab.
Txoj kev no ua haujlwm txawm tias qee lub sijhawm thaum lwm cov txheej txheem rov qab tsis tuaj yeem rov qab ua tiav phau ntawv ua haujlwm.
Cov txheej txheem siab tshaj no ntxiv cov txheej txheem rov qab los nrog cov kev daws teeb meem tshwj xeeb rau ntau hom kev noj nyiaj txiag. Koj qhov kev xaiv ntawm SYLK hloov dua siab tshiab, cov ntaub ntawv sab nraud, lossis VBA rov qab yuav tsum nyob ntawm qhov kev puas tsuaj tshwj xeeb thiab hom ntaub ntawv koj xav tau khaws cia.
3.6 Extract Daim Ntawv Qhia ntawm Macro
Koj tuaj yeem siv macro los rho tawm cov ntaub ntawv qhia los ntawm phau ntawv ua haujlwm tsis raug. Microsoft muab cov ntaub ntawv ntxiv ntawm lub macro thiab yuav siv nws li cas
rov qab tau cov ntaub ntawv qhia.
4. Siv cov cuab yeej thib peb Excel sib xws
Qee cov cuab yeej thib peb kuj txhawb nqa cov ntaub ntawv Excel. Thaum koj cov ntaub ntawv tsis raug thiab tsis tuaj yeem qhib hauv Excel, koj tuaj yeem sim cov cuab yeej no. Hauv qab no yog qee qhov ntawm lawv:
- Google los xij
- OpenOffice
- LibreOffice
Yog tias ib lub cuab yeej tuaj yeem qhib cov ntaub ntawv, khaws cia rau hauv Excel cov ntaub ntawv tsis raug tshiab.
5. Siv DataNumen Excel Repair Kho Corrupted Excel ntaub ntawv
Yog tias tag nrho cov txheej txheem saum toj no ua tsis tiav, koj tuaj yeem xav txog kev siv cov cuab yeej tshaj lij, xws li DataNumen Excel Repair, uas pab cov neeg siv rov qab corrupt Excel ntaub ntawv nrog amazing precision. Lub software ua haujlwm nrog txhua tus Excel version.
5.1 Kho ib daim ntawv Excel
Txhawm rau kho cov ntaub ntawv Excel tsis raug, thov ua raws li hauv qab no:
- Kaw Microsoft Excel thiab lwm daim ntawv thov uas tuaj yeem hloov kho koj cov ntaub ntawv Excel.
- Xaiv cov ntaub ntawv Excel (.xls/.xlsx).
- Yog tias cov ntaub ntawv qhov chaw yog test.xls/test.xlsx, cov ntaub ntawv tso tawm npe yuav raug teem rau test_fixed.xls/test_fixed.xlsx tau. Nco ntsoov cov ntaub ntawv tso zis yog teem raws li version ntawm Excel ntawm koj lub computer hauv zos. Rau Excel 2003 los yog yav dhau los versions, cov ntaub ntawv tso zis yuav nyob rau hauv .xls hom. Rau Excel 2007+, nws yuav yog hom .xlsx. Koj tuaj yeem hloov cov ntaub ntawv tso tawm npe manually (.xls/.xlsx).
- Nyem rau “Start Kho” khawm
- Tom qab cov txheej txheem kho, DataNumen Excel Repair yuav tso tawm cov ntaub ntawv Excel ruaj khov tshiab.
5.2 Kho ib pawg ntawm Excel ntaub ntawv
DataNumen Excel Repair ua rau kev ua ntawm ntau yam ntaub ntawv corrupted yooj yim. Koj tuaj yeem xaiv ntau yam ntaub ntawv Excel lossis tshawb nrhiav cov ntsiab lus tshwj xeeb ntawm koj lub khoos phis tawj, tom qab ntawd kho lawv hauv batch, raws li hauv qab no:
- Mus rau "Batch Repair" tab.
- Nyem "Ntxiv cov ntaub ntawv" ntxiv ntau cov ntaub ntawv Excel (.xls/.xlsx) kom kho.
- Koj tuaj yeem nyem "Nrhiav Cov Ntaub Ntawv" txhawm rau nrhiav cov ntaub ntawv yuav tsum tau kho ntawm lub computer hauv zos.
- Nyem rau “Start Kho” khawm
- Tag nrho cov ntaub ntawv Excel hauv daim ntawv yuav raug kho ib qho los ntawm ib qho.
5.3 Rov qab Excel cov ntaub ntawv los ntawm Hard Drive, Disk Duab, lossis cov ntaub ntawv thaub qab
Excel cov ntaub ntawv tuaj yeem rov qab tau ncaj qha los ntawm hard drives, disk duab, lossis cov ntaub ntawv thaub qab yog tias koj tsis muaj cov ntaub ntawv Excel ntxiv, piv txwv li:
- Koj rho tawm cov ntaub ntawv Excel XLS/XLSX mus tas li.
- Koj format lub hard drive.
- Hard drive tsis ua hauj lwm.
- Lub disk disk hauv VMWare lossis Virtual PC ua tsis ncaj los yog puas lawm.
- Cov ntaub ntawv thaub qab ntawm cov xov xwm thaub qab yog corrupt lossis puas thiab koj tsis tuaj yeem rov qab Excel XLS / XLSX cov ntaub ntawv los ntawm nws.
- Cov ntaub ntawv disk duab tsis raug lossis puas thiab koj tsis tuaj yeem rov qab tau koj cov ntaub ntawv Excel los ntawm nws.
Yog tias koj muaj cov duab disk lossis cov ntaub ntawv thaub qab ntawm tes, koj tuaj yeem ua raws li hauv qab no:
- Nyem "…" khawm xaiv cov ntaub ntawv qhov chaw.
- Hauv "Qhib Cov Ntaub Ntawv" dialog, xaiv "Tag nrho Cov Ntaub Ntawv (*.*)" ua cov lim.
- Xaiv cov duab disk lossis cov ntaub ntawv thaub qab ua cov ntaub ntawv los kho.
- Teem cov ntawv tso tawm tas Excel cov ntaub ntawv, thiab xyuas kom nws qhov txuas ntxiv yog .xlsx yog tias koj muaj Excel 2007+ ntsia, piv txwv li, E_Drive_fixed.xlsx, txwv tsis pub, siv .xls txuas ntxiv, piv txwv li, E_Drive_fixed.xls.
Yog tias koj xav rov qab los ntawm hard drive ncaj qha, koj yuav tsum siv DataNumen Disk Image los tsim cov duab disk rau lub hard drive:
- Xaiv lub hard drive lossis disk.
- Teem lub tso zis duab cov ntaub ntawv npe.
- Nyem “Start Cloning" khawm los tsim cov duab disk los ntawm lub hard drive / disk.
5.4 Rov qab los ntawm Ransomware lossis Virus
Thaub koj cov ntaub ntawv muaj kab mob tam sim ntawd yog ransomware lossis tus kab mob ntaus koj cov ntaub ntawv. Tom qab ntawd koj tuaj yeem siv DataNumen Excel Repair txhawm rau luam theej duab cov ntaub ntawv no thiab sim rov qab nkag rau koj cov ntaub ntawv. Cov txheej txheem scanning siab heev yuav pab txo cov ntaub ntawv poob los ntawm ransomware lossis kab mob cov ntaub ntawv.
5.5 Kho cov ntaub ntawv rov qab
Qee zaum cov ntaub ntawv rov qab los ntawm DataNumen Data Recovery los yog lwm yam zoo xws li cov ntaub ntawv rov qab cov cuab yeej tseem tsis tuaj yeem qhib hauv Excel. Hauv qhov xwm txheej zoo li no, koj tuaj yeem siv DataNumen Excel Repair kho cov ntaub ntawv rov qab uas yog qhib tau hauv Excel.
5.6 Cov ntaub ntawv ua piv txwv
Sample corrupt Excel ntaub ntawv | Cov ntaub ntawv zoo los ntawm DataNumen Excel Repair |
Yuam Kev1.xls | Yuam Kev1_fixed.xlsx |
Yuam Kev4.xlsx | Yuam Kev4_fixed.xls |
Yuam Kev5.xls | Yuam Kev5_fixed.xls |
6. Kev Pabcuam Rov Qab Online
Cov kev pabcuam rov qab online muab rau cov neeg siv lub vev xaib kom rov qab tau cov ntaub ntawv Excel tsis zoo yam tsis muaj kev txhim kho software. Cov neeg siv nrhiav kev kho sai rau cov ntaub ntawv tsis raug yog tig mus rau cov kev pabcuam no.
6.1 Cov txheej txheem rov qab yooj yim
Excel cov ntaub ntawv rov qab los ntawm cov kev pabcuam online ua raws cov kauj ruam no:
- Xaiv qhov kev pabcuam rov qab online uas muaj npe nrov
- Upload lub corrupted Excel ntaub ntawv mus rau qhov kev pab cuam webpage
- Sau koj email chaw nyob kom tau txais kev ceeb toom
- Start cov txheej txheem kho
- Tos kom tiav cov txheej txheem kho
- Rub tawm cov ntaub ntawv ruaj khov lossis tau txais los ntawm email
Cov kev pabcuam no siv ntau yam algorithms los kho ntau hom Excel ntaub ntawv kev noj nyiaj txiag. Kev kho ib txwm siv sijhawm li ob peb feeb, uas ua rau nws txoj hauv kev kom rov qab tau cov ntaub ntawv ceev.
6.2 Pros thiab Cons
Kev nkag siab zoo ntawm cov kev pabcuam rov qab hauv online 'lub zog thiab qhov tsis muaj zog pab cov neeg siv kev xaiv zoo dua.
kev pab cuam:
- Koj tuaj yeem nkag mus rau lawv los ntawm ib qho khoom siv nrog internet
- Tsis tas yuav nruab software lossis muaj kev paub txog kev paub
- Cov ntaub ntawv tau kho sai sai
- Ntau tus nqi pheej yig dua li cov txheej txheem rov qab los
Cov Kev Txwv:
- Uploading rhiab cov ntaub ntawv ua rau muaj kev ruaj ntseg thiab kev txhawj xeeb txog kev ceev ntiag tug
- Koj xav tau kev sib txuas hauv internet ruaj khov
- Feem ntau lawv tsis ua haujlwm zoo nrog cov ntaub ntawv tsis zoo
6.3 Sab saum toj Services
Ob peb online platforms tuaj yeem rov qab tau cov ntaub ntawv Excel, hauv qab no yog qee qhov ntawm lawv:
- OfficeRecovery: coj txoj hauv kev los ua qhov kev pabcuam huab cua uas txhawb nqa Excel versions ntawm 5.0 mus txog 2010. Cov kev pabcuam ua haujlwm ntau hom ntaub ntawv xws li .xls, .xlsx, thiab .xla.
- Rov qab Toolbox rau Excel: sawv tawm hauv kev rov qab cov ntaub ntawv los ntawm ntau hom Excel, suav nrog .xls, .xlsx, .xlsm, .xlt, .xltx, .xltm, thiab .xlam cov ntaub ntawv. Cov kev pabcuam muaj cov ncauj lus kom ntxaws txog kev rov qab los:
- Cell cov ntsiab lus thiab formatting
- Cov qauv thiab kev suav
- Cov ntawv ua haujlwm
- Embedded khoom
- Kev cai style thiab layouts
- Aspose: muab lub peev xwm txhim khu kev qha los kho cov ntaub ntawv sib txawv thiab txhawb nqa XLS, XLSM, XLSX, XLSB, thiab ODS cov ntaub ntawv. Cov kev pabcuam tsom rua kev ruaj ntseg cov ntaub ntawv thiab siv encryption los tiv thaiv cov ntaub ntawv uploaded.
Cov kev pabcuam no muaj cov kev xaiv sib txawv ntawm tus nqi, xws li kev kho yooj yim dawb mus rau cov nqi them nqi nrog cov yam ntxwv zoo rov qab.
7. Ntau Cov Cuab Yeej Tshaj Plaws kom Rov Qab Corrupted Excel ntaub ntawv
Tshaj li cov kev daws teeb meem uas twb tau tham lawm, ntau yam tshwj xeeb Excel kho software xaiv muaj los daws cov ntaub ntawv tsis zoo. Txhawm rau ua kom yooj yim rau koj txoj kev tshawb nrhiav, peb tau nruj me ntsis sim thiab muab tso ua ke cov ncauj lus kom ntxaws most cov cuab yeej txhim khu kev qha, qhia txog lawv cov yam ntxwv thiab kev ua tau zoo rau cov xwm txheej sib txawv.
8. Lwm cov kev daws teeb meem rau Excel ntaub ntawv qhib yuam kev
Lwm yam tshaj li cov ntaub ntawv kev noj nyiaj txiag, qee qhov laj thawj tseem tuaj yeem ua rau Excel cov ntaub ntawv qhib tsis ua haujlwm. Cov tsos mob thiab cov lus yuam kev yuav zoo ib yam lossis txawm tias tib yam li cov ntaub ntawv kev noj nyiaj txiag.
Txhawm rau txiav txim siab seb koj cov ntaub ntawv puas raug, koj tuaj yeem luam koj cov ntaub ntawv mus rau lwm lub khoos phis tawj ua haujlwm thiab qhib nws hauv Excel kom pom tias qhov yuam kev tseem muaj. Los yog siv lub online version ntawm Excel mus xyuas nws.
Yog tias cov ntaub ntawv tuaj yeem qhib rau lwm lub khoos phis tawj lossis online, nws yog tsis puas lawm. Koj tuaj yeem sim cov kev daws teeb meem hauv qab no los kho qhov qhib qhov yuam kev hauv koj lub computer:
- Kho Chaw Ua Haujlwm
- Kho Cov Neeg Siv Kev Paub Virtualization (UE-V)
- Tsis txhob quav ntsej DDE
- Disable tag nrho cov add-ins
- Pib dua cov ntaub ntawv koom nrog
- Lov tes taw cov khoom siv kho tsev nce qib
- Nruab qhov hloov tshiab tshiab
- Nco ntsoov tias tsis muaj teeb meem kev sib raug zoo ntawm Excel, Windows, thiab lwm yam software.
- Txhim kho qhov yuam kev hauv Windows sau npe
.
- Kaw tag nrho lwm daim ntawv thov
9. xaus
Excel cov ntaub ntawv kev noj nyiaj txiag yog qhov most tseem ceeb kev sib tw lag luam ntsib niaj hnub no. Koj muaj ntau txoj kev rov qab los kho qhov teeb meem no. Kev nkag siab zoo ntawm cov txheej txheem rov qab yuav pab tiv thaiv koj cov ntaub ntawv tseem ceeb thiab ua kom koj txoj kev lag luam ua haujlwm zoo. Hauv qab no yog cov ntsiab lus:
Built-in Excel nta, phau ntawv qhia, kev tshaj lij Excel kho software, thiab cov kev pabcuam rov qab online txhua yam ua haujlwm sib txawv. Txhua qhov kev xaiv muaj nws cov txiaj ntsig raws li hom kev noj nyiaj txiag. Excel's built-in cov cuab yeej rov qab yuav tsum yog koj thawj qhov kev xaiv. Rau cov teeb meem kev noj nyiaj txiag hnyav, tshwj xeeb software nyiam DataNumen muab koj cov txheej txheem rov qab siab heev kom rov qab tau cov ntaub ntawv Excel tsis raug.
Nco ntsoov tias kev thaub qab tsis tu ncua thiab tuav cov ntaub ntawv kom raug yog qhov tseem ceeb los tiv thaiv teeb meem. Nyob rau hauv tas li ntawd, koj yuav tsum tau saib rau cov cim qhia txog kev noj nyiaj txiag. Khaws koj cov software Excel tshiab kom txo tau cov kev pheej hmoo.
Txoj cai mix ntawm kev tiv thaiv thiab cov cuab yeej rov qab yuav tiv thaiv koj cov ntaub ntawv Excel los ntawm kev noj nyiaj txiag. Kev rov qab sai yuav yooj yim dua thaum xav tau. Ua ib txoj hauv kev zoo rau kev tiv thaiv cov ntaub ntawv thiab khaws ntau cov kev xaiv rov qab npaj txhij. Txoj kev no, koj tuaj yeem daws teeb meem kev noj nyiaj txiag Excel yam tsis muaj kev ntxhov siab.
References:
- Microsoft Corporation. (nd). Kho ib phau ntawv ua haujlwm tsis raug. Microsoft Support. https://support.microsoft.com/en-us/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53