Yuav ua li cas rau troubleshoot kom raug thaum koj txuag Excel workbooks

Microsoft Excel yog ib tug spreadsheet tsim los ntawm Microsoft. Muaj nyob rau ntawm ntau operating systems uas muaj xws li lub qhov rais, MacOS, iOS no thiab Android thiab muaj hwj chim loj cov cuab yeej zoo li duab, muab xam, pivot ntxhuav thiab lwm leej lwm tus ua ntau yam kev pab raws qib.

• Tshuaj 1: Yuav ua li cas Troubleshoot Excel yuam kev
• Tshuaj 2: Kho Excel Wordbooks nrog Kho Tool

Yuav ua li cas hom ntawm kev ua yuam kev no tshwm sim thaum koj txuag Excel ntaub ntawv

Thaum koj sim mus cawm ib tug Excel ntaub ntawv, koj yuav ua tau tag nrog txhua yam ntawm kom raug. Luckily muaj kev daws teeb meem rau tag nrho cov paub tsis. Cia saib ib co ntawm cov uas tsis thiab yuav ua li cas los txhim kho cov lawv.

Ua ntej koj yuav pib troubleshoot Excel yuam kev los ntawm kev siv classing txoj kev los yog los ntawm kev siv ib tug Excel kho lub cuab tam, nco ntsoov txuag koj tus ua hauj lwm raws li qhov zoo tshaj plaws raws li koj ua tau. Cov nram qab no txoj kev yuav muaj xws li ib tug computer reboot, uas yuav ua tau kom poob koj Excel ntaub ntawv. Cia saib ib co workaround txoj kev mus cawm tau koj Excel ntaub ntawv ua ntej:

1. Qhov teeb meem tej zaum yuav tshwm sim los ntawm lub npe, yog li sim ib tug txawv ib tug:
   - Nyob rau sab saum toj sab laug ces kaum ntawm koj npo, tau nyem rau ntawm "Cov ntaub ntawv" thiab ces nias rau ntawm "txuag raws li"
   - Xaiv ib tug txawv lub npe
2. Xaiv lwm cov ntaub ntawv hom rau koj Excel phau:
   - Nyem rau "Cov ntaub ntawv", ces "txuag tau li"
   - Ib tug tshiab qhov rai yuav qhib; nyob rau hauv qab koj yuav pom "Txuag li hom", nyob rau hauv uas dropdown xaiv lwm version, xws li .xlsm los yog .xlsx.
3. Txuag koj sau thiab khij tau raws li HTML:
   - Nyem rau "Cov ntaub ntawv", ces "txuag tau li"
   - Qhov uas nws hais tias "Cawm li hom", xaiv "Web Page"
   - Txuag koj Excel ntaub ntawv

Tshuaj 1: Yuav ua li cas Troubleshoot Excel yuam kev

Tam sim no uas koj cov ntaub ntawv yog yam xyuam xim rua rau koj Computer, koj muaj peev xwm pib troubleshoot excel kev ua yuam kev . Nyob rau hauv thiaj li yuav to taub yuav ua li cas kho Excel, koj yuav tsum to taub tias dab tsi ua rau qhov teeb meem nyob rau hauv thawj qhov chaw. Muaj ob peb yog vim li cas uas yuav ua rau Excel rau malfunction:

1. Ib tug ntawm cov yog vim li cas yuav ua tau hais tias cov nplaub tshev directory tsis muab koj tso cai rau ua kom tiav no ua hauj lwm. Koj yuav tsum muab ib tug nplaub tshev hauv qab no permissions:
   - Sau
   - Nyeem
   - Rho tawm
   - Hloov
   
2. Lwm qhov teeb meem uas yuav ua rau qhov teeb meem yuav ua tau los ntawm ib tug thib peb-tog ntxiv-nyob rau hauv. Cov me ntsis kev pab cuam pab Excel mus ua kom tiav yam. Ib txhia add-ins, preloaded thaum koj nruab MS Excel thaum lwm tus neeg yuav tsum ntsia manually los ntawm ntau qhov chaw. Tej zaum cov ntxiv-ins yuav ua teeb meem thiab kom paub tseeb tias ib tug ntawm ntau ntawm lawv yog cov los liam, koj muaj peev xwm qhib Excel nyob rau hauv kev ruaj ntseg hom:
   - Thawj ze Excel kiag li
   - Nrhiav qhov chaw uas koj muaj MS Excel
   - Xovxwm rau "CTRL" qhov tseem ceeb thiab sab laug nyem rau ntawm qhov MS Excel executable qhib rau nws. Tuav lub tswj tseem ceeb kom txog rau thaum koj tau txais cov nram qab no cov lus "Excel tau kuaj tias koj yuav tuav cia lub ctrl tseem ceeb. Koj puas xav pib Excel nyob rau hauv kev ruaj ntseg hom? Nyem Yes.
   - Tam sim no uas koj muaj nyob rau hauv kev ruaj ntseg hom, sim qhib ib daim qauv ntawm koj phau thiab pom tias koj muaj peev xwm cawm tau nws.
   

   Yog hais tias koj muaj peev xwm cawm tau nws, ces nws txhais tau hais tias ib tug los yog ntau add-ins, yog yuav ua qhov teeb meem, yog li ntawd koj yuav tau paub uas ib tug thiab rho tawm nws. Tom qab koj nrhiav tau cov puab add-nyob rau hauv, ib tug zoo tswv yim yog hu rau tus tsim tawm ntawm tias tej add-nyob rau hauv raws li lawv tej zaum yuav muaj ib tug fix rau qhov teeb meem.

3. Yog hais tias lub Disk yog tag nrho, yeej tsis zoo li tab sis nws yuav tshwm sim. Koj yuav tsum luaj ib co qhov chaw.
4. Ib tug antivirus yuav cuam tshuam qhov txuag txheej txheem ntawm koj Excel thiab khij tau. Feem ntau cov antivirus software ib ntus interrupts dab raws li lawv luam theej duab nws, kom tsis txhob dag txog cov ntaub ntawv yog kis tau los yog tsis. Yog hais tias koj muaj ib qho active antivirus, sim disabling nws, tsuas yog mus saib yog tias koj muaj peev xwm cawm koj Excel thiab khij tau.
5. Yog hais tias koj siv ib tug sib sau thiab khij tau thiab lwm tus neeg yog sim kom txuag tau tus Excel ntaub ntawv tib lub sij hawm raws li koj yog. Yog hais tias qhov no yog cov ntaub ntawv, qhov uas yooj yim txoj kev zoo los qhia rau tus neeg ntawd mus tos los yog cia li tos ib pliag thiab sim dua.
6. Yog hais tias qhov ntev ntawm cov ntaub ntawv npe yog ntev tshaj li 218 cim koj yuav tau txais cov lus yuam kev "filename yog siv tsis tau", koj yuav tsum hloov lub npe nyob rau hauv cov ntaub ntawv no.

Tshuaj 2: Kho Excel Wordbooks nrog Kho Tool

Muaj kev ua yuam kev uas cov classic txoj kev tsis ua hauj lwm. Luckily muaj Stellar Phoenix Excel Kho uas yog cia li ib tug Excel kho lub cuab tam. Nws yuav zoo kho siab tsis ncaj los yog Excel ntaub ntawv uas tsis tau muab qhib tsis ua tej yam kev hloov rau koj sau thiab khij tau. Ntawm no yog ob peb tug cov ntsiab zoo:

Cov kauj ruam yuav kho Excel ntaub ntawv uas tsis:

Kauj ruam 1 Khiav lub executable ntaub ntawv qhib Stellar Phoenix kho lub cuab tam. Ces nias lub "Ntxiv cov ntaub ntawv" xaiv koj cov ntaub ntawv.

Kauj ruam 2 Ib qhov rais yuav tshwm nyob rau hauv koj lub screen. Thaum no tus taw tes, nyob ntawm seb yog tias koj muaj ib zaug xwb los ntau yam ntaub ntawv los kho, xaiv lub "Xaiv ntaub ntawv" los yog "Xaiv nplaub tshev" kev xaiv.

Kauj ruam 3 Thaum twg koj muaj nyob koj cov ntaub ntawv los yog ntawv tais ceev tseg, nyob rau hauv lub Excel kho lub cuab tam , nias qhov "Scan" khawm.

Kauj ruam 4 Tom qab cia li ob peb lub vib nas this koj yuav muaj ib tug saib ua ntej ntawm lub kho Excel ntaub ntawv.

Kauj ruam 5 Txuag tau cov ntaub ntawv rau lub zos tsav.

Stellar Phoenix yog ib tug haib Excel kho lub cuab tam. Qhov yooj yooj yim rau siv interface thiab ceev ceev ua muaj peev xwm ua pab nws cov neeg siv kho corrupted Excel ntaub ntawv ceev ceev thiaj li hais tias lawv yuav mus ntxiv rau lawv cov ua hauj lwm.

Ib tug ob peb lub tswv yim thaum soj ntsuam nrog ib corrupt Excel ntaub ntawv:

• Kaw tag nrho cov khiav Excel workbooks ua ntej sim kho ib tug corrupted ntaub ntawv .
• Txuag koj ua hauj lwm ua ntej koj troubleshoot excel kev ua yuam kev.
• Ua ntej tau txais mus rau hauv nyuab troubleshooting cov kauj ruam, pib nrog ib qho yooj yim uas sawv daws yuav ua ntej.