Yuav Kho Cov Ntaub Ntawv Excel Ceb Los Los Tsis Zoo Li Cas

Thaum Microsoft Excel cov ntaub ntawv (.xls, .xlw, .xlsx) puas lossis puas thiab qhib tsis tau, ua raws li cov kauj ruam no los kho cov ntaub ntawv:

Nco ntsoov: Ua ntej starting cov ntaub ntawv rov qab txheej txheem, tsim ib tug thaub qab ntawm tus thawj corrupt Excel ntaub ntawv.

  1. Microsoft Excel muaj kev txhim kho hauv kev ua haujlwm. Thaum nws pom koj cov ntaub ntawv Excel tsis raug, nws yuav sim kho koj cov ntaub ntawv. Qee zaum, yog tias qhov ua haujlwm tsis yog started cia li, koj tuaj yeem yuam Excel los kho koj cov ntaub ntawv manually. Siv Excel 2013 ua piv txwv, cov kauj ruam yog:
    1. Nyem Qhib nyob rau hauv lub cov ntaub ntawv ntawv qhia zaub mov.
    2. Nyob rau hauv lub Open dialog box, xaiv cov ntaub ntawv, ces nias lub xub nyob ib sab ntawm Qhib khawm.
    3. xaiv Qhib thiab Kho, tom qab ntawd xaiv txoj kev rov qab los rau koj phau ntawv ua haujlwm.
    4. xaiv kho rau khaws cov nyiaj ntau tshaj ntawm cov ntaub ntawv los ntawm cov ntaub ntawv corrupt.
    5. If kho ua tsis tiav, siv Cov ntaub ntawv suav khaws cov ntaub ntawv xovtooj ntawm tes thiab cov qauv.

    Cov txheej txheem rov qab tuaj yeem sib txawv me ntsis ntawm Excel versions.

  2. Peb qhov kev sim qhia tias txoj kev 1 feem ntau ua haujlwm thaum cov ntaub ntawv kev noj nyiaj txiag tshwm sim thaum kawg ntawm cov ntaub ntawv. Tab sis zoo li yuav ua tsis tau yog tias kev noj nyiaj txiag tshwm sim nyob rau hauv header lossis nruab nrab ntawm cov ntaub ntawv.
  3. Yog tias txoj kev 1 ua tsis tiav, sim ntxiv phau ntawv kho cov txheej txheem nrog Excel, xws li sau ntawv me me VBA macro. Xav paub ntau ntxiv tuaj yeem pom ntawm nplooj ntawv txhawb Microsoft: https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
  4. Qee cov cuab yeej thib peb pub dawb tuaj yeem qhib thiab nyeem cov ntaub ntawv Excel tsis raug, suav nrog OpenOffice, LibreOffice, KingSoft Spreadsheets, Thiab Google los xij. Yog tias ib qho ntawm cov cuab yeej no tuaj yeem qhib koj cov ntaub ntawv ua tiav, txuag nws ua cov ntaub ntawv tsis raug yuam kev tshiab.
  5. xlsx cov ntaub ntawv tau compressed Zip cov ntaub ntawv. Yog li ntawd, qee zaum, yog tias kev noj nyiaj txiag tsuas yog tshwm sim los ntawm cov Zip file, sim siv a Zip kho cuab yeej xws li DataNumen Zip Repair:
    1. Hloov npe cov ntaub ntawv Excel tsis raug (piv txwv li, los ntawm myfile.xlsx rau myfile.zip).
    2. siv DataNumen Zip Repair kho myfile.zip thiab tsim myfile_fixed.zip.
    3. Rename myfile_fixed.zip rov qab mus rau myfile_fixed.xlsx.
    4. Qhib myfile_fixed.xlsx hauv Excel.

    Thaum qhib cov ntaub ntawv kho hauv Excel, koj tseem yuav ntsib qee qhov lus ceeb toom. Tsis quav ntsej lawv, thiab Excel yuav sim qhib thiab kho cov ntaub ntawv. Yog tias cov ntaub ntawv qhib tau tiav, txuag nws cov ntsiab lus rau cov ntaub ntawv tsis raug yuam kev tshiab.

  6. Yog tias tag nrho cov txheej txheem saum toj no ua tsis tiav, siv DataNumen Excel Repair daws qhov teeb meem. Nws yuav luam theej duab cov ntaub ntawv corrupted thiab tsim ib tug tshiab yuam kev-dawb cov ntaub ntawv txiav.