Yuav ua li cas Kho Excel ntaub ntawv yuav nrhiav tsis tau ib qhov los yog cov tsev qiv ntawv yuam kev

Thaum uas siv cov MS Excel ntaub ntawv los yog MS Access uas assimilate zog los yog tej khawm uas yuav tsum tau VBA (Visual Basic ntawv thov) rau lub Macros ua ib co muab neeg ua hauj lwm, cov neeg siv tej zaum yuav tau txais ib tug muab tso ua ke yuam kev "Yuav nrhiav tsis tau peb tes num los yog cov tsev qiv ntawv" .

• Part 1: Yuav ua li cas yog qhov ua rau ntawm no yuam kev?
• Part 2: Yuav ua li cas Kho ncaj Excel ntaub ntawv
• Part 3: Kho MS Excel ntaub ntawv nrog Excel Kho Tool

Part 1: Yuav ua li cas yog qhov ua rau ntawm no yuam kev?

• Qhov no yuam kev yog feem ntau tshwm sim los ntawm tus neeg siv MS Access los yog MS Excel kev pab cuam. Yog vim li cas yog tias qhov kev pab cuam muaj ib tug siv rau ib tug kwv los yog hom ntawm cov tsev qiv ntawv uas yog uas ploj lawm thiab li no tsis pom los ntawm qhov kev pab cuam. Raws li, qhov kev pab cuam muaj peev xwm siv tsis tau VB los yog Micro raws li zog los yog tej khawm. Yog li ntawd ib qho kev ua yuam kev cov lus yog xa mus.
• Tej zaum lub tsev qiv ntawv tej zaum yuav toggled rau los yog toggled tawm ua ib tug uas ploj lawm link ntawm tsev qiv ntawv thiab kev pab cuam cov cai. Yog li ntawd, muab tso ua ke yuam kev lawm.
• Txij li thaum muaj tus qauv cov tsev qiv ntawv thiaj li ploj lawm cov tsev qiv ntawv suab ib tug me ntsis ntawm tsawg kawg yog lub caij nyoog. Tus lwm tau yog vim li cas, nyob rau hauv cov ntaub ntawv uas, yog hais tias cov tsev qiv ntawv mus dhau-match yog qhov ua rau ntawm kev ua yuam kev. Piv txwv li, tus neeg siv tej zaum yuav muaj lub tsev qiv ntawv (zaum Outlook) version ntawm 2007 tab sis cov kev siv nyob rau hauv lub code yuav tau nrhiav 2010 version ntawm cov uas tej tsev qiv ntawv. Yog li ntawd qhov kev pab cuam tsis mus nrhiav tus coj tsev qiv ntawv li muab qhov no muab tso ua ke yuam kev.
• Lwm scenario rau tib lub yuam kev cov lus yog hais txog kev siv ntawm Microsoft XP uas muaj xws li ib tug siv rau web kev pab cuam nyob rau hauv VBA project. Thaum koj khiav qhov project no nyob rau hauv MS Office 2003, tib lub muab tso ua ke yuam kev zoo nkaus li. Yog vim li cas yog tib yam xws li yam khoom los yog hom ntawm cov tsev qiv ntawv uas ploj lawm (los yog tsis pom).

Part 2: Yuav ua li cas Kho ncaj Excel ntaub ntawv

Rau tej yam ib co ntsiab kom rectify qhov teeb meem los yog mus rau kho corrupted Excel ntaub ntawv yog yeej ib txwm muaj. Zoo li nrhiav kev tawm uas ploj lawm cov tsev qiv ntawv los yog qhov ua rau ntawm mismatch yog hais tias nws tshwm sim. Cov tsev qiv ntawv no ces ntxiv los yog hloov cov code tej zaum yuav rechecked mus txuas rau qhov kev tsim nyog cov tsev qiv ntawv.

Yuav ua li cas yuav nws yuav ua li cas?

Ua raws li cov kauj ruam:

Kauj ruam 1. Qhib lub MS Excel ntaub ntawv, muab ib cov lus yuam.

Kauj ruam 2. Xyuas kom meej tias daim ntawv uas muaj txhais zog los yog tej khawm xaiv.

Kauj Ruam 3. Xovxwm "ALT thiab F11 tuav", rau VB Editor nyob rau hauv lub qhov rai tshiab (raws li hauv qab no).

Kauj ruam 4. Nyem rau ntawm cov cuab yeej rau zaub mov thiab ces xaiv References los ntawm rub cia cov zaub mov, raws li qhia

Kauj ruam 5. Tom qab dialog box yuav tso saib 'ploj lawm yam khoom tsev qiv ntawv los yog hom' yog qhia, raws li qhia hauv qab no

Kauj ruam 6. Raws li nyob rau hauv saum toj no zaub yog kos cim tshwm sim nrog uas ploj lawm cov tsev qiv ntawv, uncheck nws thiab nias OK

Kauj ruam 7. Exit thiab txuag tus thawj Excel ntaub ntawv.

Tam sim no mus saib los xyuas kom meej duas zog ua hauj lwm kom zoo.

Part 3: Kho MS Excel ntaub ntawv nrog Excel Kho Tool

Peb tog Excel ntaub ntawv kho software yog muaj los daws tag nrho xws li teeb meem sai sai thiab meej. Ib tug ntawm cov zoo tshaj plaws Excel ntaub ntawv Kho software , los kho thiab rov qab puas / corrupt Excel ntaub ntawv yog piav rau hauv qab no.

Qhov no Excel ntaub ntawv kho software yog muaj nyob rau ib raws li ntau yam systems. Cov ntaub ntawv kho lub cuab tam txhawb tag nrho cov versions ntawm qhov rais thiab txhawb Excel 2011 rau Mac. Qhov no tso cai rau kev kho corrupted Excel ntaub ntawv (.XLS thiab .XLSX), thiab restore tag nrho cov ntaub ntawv los ntawm lub siab tsis ncaj rau ib tug tshiab Excel ntaub ntawv.

Kauj ruam 1 Xaiv corrupt Excel ntaub ntawv los ntawm tsav thiab nrhiav.

Kauj ruam 2 Chooes ib los yog tag nrho cov corrupt Excel ntaub ntawv pib mus kho cov txheej txheem.

Kauj ruam 3 Preview lub kho Excel ntaub ntawv.

Kauj ruam 4 Xaiv ib tug nyiam qhov chaw los cawm kho Excel ntaub ntawv.

Nyob rau hauv tas li ntawd mus Excel Kho Tool los yog Excel ntaub ntawv kho software , ib tug ob peb lub tswv yim tej zaum yuav pab tau rau ceev fixes (yuav rov qab los yog kev kho corrupted Excel ntaub ntawv).

Case 1. Thaum Excel ntaub ntawv no yog qhib sim muaj ib yam ntawm followings.

1. Sim ib yam txawv computer
2. Hloov tshem pib txuag.
3. Tua cov ntaub ntawv xyaum sib faib khoom.
4. Tsis txhob khiav Excel los ntawm ib tug muag nthas
5. Txuag tau cov ntaub ntawv raws li ib tug web page thiab rov qhib nws raws li Excel ntaub ntawv.

Case 2. Thaum Excel yuav tsis qhib cov ntaub ntawv, sim ib tug ntawm cov nram qab no.

1. Qhib lub siab tsis ncaj cov ntaub ntawv rau ib qho nyuaj-tsav. Luam los ntawm muag nthas.
2. Nrhiav .xlb cov ntaub ntawv. Tsis tas li ntawd kom ib tug thaub qab. Rho tawm .xlb. Restart Excel.
3. Qhib cov ntaub ntawv nyob rau hauv MS lo lus los yog Notepad. Uas yuav qhia rau koj rov qab cov ntaub ntawv, tiam sis tsis formatting
4. Nrog MS Excel 97/2000 tuav koj yuav saib tau cov ntaub ntawv thiab cov ntawv luam. Qhib ntaub ntawv uas siv pub dawb no pab cuam rov qab cov ntaub ntawv. Qhov kev pab no yuav rov qab formatting raws li cell qhov tseem ceeb.
5. Siv Excel XP. Qhov no muaj kev zoo dua qub rau rov qab.