Poob koj cov ntaub ntawv Excel? Ua kom tiav cov lus qhia kom nkag siab thiab zam kev txuag qhov yuam kev

Puas yog koj muaj teeb meem khaws koj cov ntaub ntawv hauv Excel? Qhov xwm txheej no tuaj yeem ntxhov siab heev, tshwj xeeb tshaj yog tias koj tau siv sijhawm ntau ua haujlwm ntawm koj daim ntawv teev npe thiab ntshai poob tag nrho koj cov kev hloov pauv. Microsoft Excel yog ib qho ntawm cov cuab yeej siv dav tshaj plaws rau kev tswj cov ntaub ntawv thiab kev tshuaj xyuas, yog li Kev ntsib teeb meem thaum sim khaws cov ntaub ntawv yog ib qho ntawm cov lus nug ntau tshaj plaws thiab txhawj xeeb ntawm nws cov neeg siv.

Nyob rau hauv tsab xov xwm no, peb yuav saib tag nrho cov Tej yam ua tau uas yuav tiv thaiv Excel los ntawm kev txuag koj cov ntaub ntawvthiab peb yuav muab cov lus qhia ntxaws ntxaws rau txhua rooj plaub. Ntawm no koj yuav pom tsis yog cov txheej txheem ib ntus xwb, tab sis kuj tseem muaj cov lus piav qhia meej thiab cov lus qhia muaj txiaj ntsig kom tsis txhob muaj cov teeb meem no yav tom ntej. Los, nyob thiab peb mam li piav qhia rau koj. yuav ua li cas rov qab los ntawm cov xwm txheej no thiab tiv thaiv lawv.

Yuav ua li cas cov txheej txheem txuag ua haujlwm hauv Excel thiab vim li cas nws yuav ua tsis tiav

Ua ntej yuav mus rau hauv kev daws teeb meem, nws yog ib qho tseem ceeb kom nkag siab Excel txuag cov ntaub ntawv li cas, txij li cov txheej txheem tsis yooj yim li nws zoo li. Excel, thaum koj manually lossis cia li khaws phau ntawv ua haujlwm, ua ntej tsim cov ntaub ntawv ib ntus hauv tib qhov chaw raws li cov ntaub ntawv qub. Thaum txuag tau tiav, rho tawm cov ntaub ntawv qub thiab muab cov ntaub ntawv ib ntus rau lub npe raug. Yog tias muaj teeb meem tshwm sim thaum tus txheej txheem no, ntau hom kev ua yuam kev tuaj yeem tshwm sim, thiab cov ntaub ntawv nrog cov kev hloov tshiab tshiab yuav tsis raug cawm kom raug.

Kev cuam tshuam hauv cov txheej txheem txuag tuaj yeem yog vim muaj ntau yam: los ntawm nias lub "Esc" qhov tseem ceeb, teeb meem kho vajtse, teeb meem software, teeb meem kev tiv thaiv kab mob, kev tso cai tsis sib haum, cov ntaub ntawv txoj kev ntev dhau los, lossis txawm tias tsis muaj qhov chaw disk. Koj kuj yuav tsum tau ceev faj nrog cov chaw hauv network lossis cov tsav sab nraud, xws li kev sib txuas ploj thaum Excel txuag, koj tuaj yeem xaus nrog cov ntaub ntawv tsis raug lossis tsis tau hloov pauv.

Feem ntau cov lus yuam kev thaum txuag cov ntaub ntawv hauv Excel

Ntawm cov lus yuam kev tshaj plaws thaum Excel tsis txuag cov ntaub ntawv, cov hauv qab no sawv tawm:

• "Cov ntaub ntawv tsis tau khaws cia"
• "Cov ntaub ntawv tsis tau raug cawm tag nrho"
• «Cov ntaub ntawv nyeem nkaus xwb tsis tuaj yeem nkag mus. »
• "Tag nrho Disk"
• "Qhov yuam kev tau kuaj pom thaum txuag ..."
• "Cov ntaub ntawv npe tsis siv tau"

Txhua qhov yuam kev no taw qhia rau ib qho laj thawj sib txawv., yog li nws yog qhov zoo tshaj los txheeb xyuas cov lus tseeb ua ntej nrhiav kev daws teeb meem.

Cov laj thawj tseem ceeb vim li cas Excel tsis txuag kev hloov pauv

Raws li cov ntaub ntawv raug cai, pab pawg sib tham thiab cov neeg siv kev paub, Cov laj thawj feem ntau yog vim li cas Excel muab teeb meem thaum txuag cov ntaub ntawv:

• Tsis muaj kev tso cai ntawm qhov chaw khaws cia: Yog tias koj tsis tau nyeem, sau, lossis hloov pauv kev tso cai ntawm daim nplaub tshev uas koj tab tom sim khaws phau ntawv ua haujlwm, Excel yuav tsis tuaj yeem ua kom tiav qhov txuag.
• Third Party Plugins: Qee qhov add-ins ntsia hauv Excel tuaj yeem cuam tshuam nrog cov txheej txheem txuag, ua rau poob siab lossis yuam kev.
• Cov ntaub ntawv puas lossis puas: Yog tias cov ntaub ntawv qub tsis raug, Excel tuaj yeem tiv thaiv kev hloov pauv los ntawm kev khaws cia kom raug.
• Qhov chaw disk tsis txaus: Yog tias qhov chaw nyob tsis muaj qhov chaw dawb, Excel yuav tsis ua tiav cov haujlwm txuag.
• antivirus software: Qee cov kev pab cuam antivirus tuaj yeem thaiv cov txheej txheem txuag, tshwj xeeb tshaj yog tias lawv luam theej duab cov ntaub ntawv tshiab lossis hloov kho cov ntaub ntawv qhib thaum lub scan.
• Sib koom tsis sib haum xeeb los yog xauv: Yog tias cov ntaub ntawv raug qhib los ntawm lwm tus lossis hauv lwm qhov piv txwv ntawm Excel, qhov yuam kev yuav tshwm sim thaum txuag.
• Txoj kab ntawv ntev dhau lawm: Excel txwv cov ntaub ntawv npe ntxiv rau tag nrho txoj kev mus rau 218 cim. Yog tias nws dhau, koj yuav tau txais lub npe tsis raug.
• Kev sib txuas teeb meem hauv cov chaw hauv network: Yog tias koj khaws cov ntaub ntawv mus rau lub network tsav thiab kev sib txuas tau ploj, kev txuag yuav ua tsis tau thiab koj tuaj yeem poob cov ntaub ntawv tsis ntev los no.
• Cov ntaub ntawv hauv hom nyeem nkaus xwb: Cov ntaub ntawv yuav muaj hom no enabled los yog tej zaum koj yuav tsis yog tus tswv, txwv lub peev xwm los cawm nws nrog kev hloov.
• Hardware yuam kev (disk, USB drives, thiab lwm yam): Lub cev tsis ua haujlwm lossis kev cuam tshuam ntawm lub tsav thaum txuag tuaj yeem ua rau cov ntaub ntawv tsis raug thiab puas.
• Cov ntaub ntawv kaw los ntawm lub kaw lus lossis lwm daim ntawv thov: Yog tias cov ntaub ntawv siv los ntawm lwm qhov kev pab cuam, nws yuav tiv thaiv kev txuag.

Yuav ua li cas kho Excel tsis txuag kev hloov pauv?

Cia peb tshuaj xyuas ib los ntawm ib qho kev daws teeb meem zoo tshaj plaws rau txhua qhov xwm txheej tshwj xeeb.

1. Tshawb xyuas thiab hloov kho cov ntaub ntawv tso cai

Ua ntej tshaj plaws Xyuas tias koj muaj kev tso cai txaus nyob rau hauv daim nplaub tshev uas koj khaws cov ntaub ntawv. Txoj nyem rau ntawm daim nplaub tshev, xaiv Propiedades, nkag mus tab Kev ruaj ntseg thiab xyuas cov kev tso cai uas muab rau koj tus neeg siv. Yog tias koj tsis tau sau lossis hloov pauv kev tso cai, nug tus thawj tswj pab pawg kom muab lawv rau koj los yog sim txuag cov ntaub ntawv mus rau lwm qhov chaw uas koj muaj lawv.

2. Txuag cov ntaub ntawv ua ib phau ntawv ua haujlwm tshiab lossis nrog lwm lub npe

Ib qho ntawm thawj qhov kev pom zoo ua thaum Excel yuav tsis cia koj txuag yog siv qhov kev xaiv Txuag li thiab hloov cov ntaub ntawv npe lossis txoj kev. Txoj kev no, koj tsis txhob sau cov ntaub ntawv qub thiab zam kev sib tsoo lossis sijhawm txwv. Ua li no:

1. Nkag mus rau cov ntawv qhia zaub mov Khaws thiab xaiv Txuag li.
2. Nkag mus rau lwm lub npe thiab sim txuag nws mus rau lwm qhov chaw.

Qhov kev tawm tsam no feem ntau siv tau thaum qhov kev tsis sib haum xeeb dhau qhov kev tso cai, cov ntaub ntawv tsis raug cai ib ntus, lossis kev sib tsoo ib ntus.

3. Txav cov ntaub ntawv qub mus rau lwm phau ntawv ua haujlwm

Yog hais tias cov ntaub ntawv tshwm corrupted los yog ua tsis tau tejyam, ib tug pab tau txheej txheem yog txav tag nrho cov nplooj ntawv (tshwj tsis yog ib daim ntawv sau) mus rau ib phau ntawv tshiabCov. Yog li:

1. Ntxiv ib daim ntawv sau nrog Hloov + F11.
2. Muab tag nrho cov ntawv tseem ceeb tshwj tsis yog daim ntawv muab tub lim (nyem rau thawj zaug, ua haujlwm-nias ntawm qhov kawg).
3. Txoj nyem thiab xaiv Tsiv los yog Copy… > xaiv (Cov phau ntawv tshiab) > Txais.

Txoj kev no, koj tuaj yeem txuag tau cov ntaub ntawv tshiab yam tsis muaj qhov yuam kev thiab rov qab tau tag nrho cov ntsiab lus, suav nrog VBA macros, los ntawm kev luam cov qauv ntawm tes. Yog tias koj xav paub ntau ntxiv txog yuav ua li cas kom tsis txhob yuam kev hauv Excel, peb pom zoo kom rov xyuas peb tsab xov xwm ntawm BitLocker yuam kev hauv Windows.

4. Txuag raws li hom ntaub ntawv sib txawv (.xlsx, .xlsm, thiab lwm yam)

Qee zaum thawj cov ntaub ntawv hom yog corrupted. Hloov hom ntaub ntawv yuav daws tau qhov teeb meem. Ua li no:

1. En Khaws, nias Txuag li.
2. Hauv kev xaiv Hom, xaiv ib hom ntawv sib txawv (piv txwv li, .xl xwm rau cov ntaub ntawv nrog macros lossis .xlsx yog tus original .xl ua).

Nrog rau qhov no koj tuaj yeem tshem tawm cov qub incompatibilities los yog format yuam kev.

5. Sim txuag cov ntaub ntawv mus rau lwm qhov chaw

Yog tias koj xav tias qhov teeb meem yuav nyob ntawm qhov chaw tsav (piv txwv li, ib qho tsav sab nraud, lub network tsav, lossis cov ntawv txwv txwv), khaws cov ntaub ntawv mus rau lub desktop lossis lwm lub nplaub tshev hauv zos ntawm koj pab neeg. Qhov no txwv tsis pub lub network, kev tso cai, lossis teeb meem chaw. Tsis tas li, yog tias koj muaj lus nug txog kev rov qab cov ntaub ntawv tsis tau khaws cia, koj tuaj yeem tshawb xyuas peb cov lus qhia ntawm rov qab tau cov ntaub ntawv Word uas tsis tau khaws cia.

6. Txuag cov ntaub ntawv tshiab rau qhov chaw qub

Tsim ib phau ntawv ua haujlwm Excel tshiab thiab khaws ib daim ntawv luam rau hauv tib lub nplaub tshev uas tus thawj yog. Yog tias koj ua tsis tau, qhov teeb meem yog qhov kev tso cai, qhov chaw tsis txaus ntawm tus tsav, lossis software teeb meem. Yog tias koj tuaj yeem khaws cov ntaub ntawv tshiab, qhov teeb meem yuav yog nrog cov hom ntawv lossis cov ntsiab lus ntawm tus thawj.

7. Pib Excel hauv hom kev nyab xeeb

Ntau zaus Thib peb plugins ua teeb meem thaum txuag cov ntaub ntawv. Yuav kuaj seb qhov no yog vim li cas:

• 1 kev xaiv: Nias thiab tuav tus yuam sij Ctrl thiab qhib Excel, paub meej tias cov lus muaj kev nyab xeeb.
• 2 kev xaiv: Xovxwm Windows + R, sau kom zoo / nyab xeeb thiab ntaus Sau.

Yog tias koj tuaj yeem txuag tau hauv hom kev nyab xeeb, deactivate lossis tshem tawm cov add-ons ib qho los ntawm ib qho kom txog thaum koj pom tus neeg ua txhaum. Ua li no:

1. Qhib Excel ib txwm.
2. ntawv qhia zaub mov Khaws > xaiv > Kev sib txuam.
3. Hauv qab, xaiv COM plugins thiab nias Ir.
4. Uncheck tag nrho cov add-ins thiab rov pib Excel.

8. Tshawb xyuas qhov chaw disk muaj

Ib qho ntawm cov laj thawj classic tshaj plaws yog tsis muaj chaw txaus txaus. Siv File Explorer txhawm rau txheeb xyuas qhov chaw muaj. Yog tias nws puv, tso qhov chaw los ntawm kev tshem tawm cov thoob khib nyiab, tshem tawm cov ntaub ntawv ib ntus, lossis txuas ntxiv muab faib nrog cov cuab yeej xws li Yooj Yim Sib Pauv Tswv Yim lossis zoo sib xws.

9. Tshem tawm cov software tiv thaiv kab mob ib ntus

Qee qhov kev pab cuam tiv thaiv kab mob tuaj yeem luam theej duab cov ntaub ntawv tshiab lossis cov ntaub ntawv hauv lub sijhawm tiag tiag, txwv tsis pub lawv yuav raug cawm ib ntus. lov tes taw koj lub antivirus ib ntus thaum txuag, tab sis nco ntsoov qhib nws tom qab. Yog tias qhov yuam kev ploj lawm, tshawb xyuas koj qhov chaw tiv thaiv kab mob kom tsis suav cov folders uas koj khaws cov ntaub ntawv Excel.

10. Kho koj lub chaw ua haujlwm installation

Yog tias tsis muaj dab tsi ua haujlwm, koj qhov chaw ua haujlwm kev teeb tsa yuav raug cuam tshuam. Kho nws:

1. Mus rau Tswj Vaj Huam Sib Luag> Kev Pabcuam thiab Nta.
2. Tshawb nrhiav Microsoft Office, txoj nyem thiab xaiv Kho Tau.
3. Xaiv Kev kho sai (ces) los yog Kev kho online (qhov tob dua).

Tom qab ntawd, sim txuag koj cov ntaub ntawv Excel dua.

Cov yuam kev tshwj xeeb thiab lawv cov kev daws teeb meem

"Cov ntaub ntawv nyeem nkaus xwb tsis tuaj yeem nkag tau."

Qhov no tuaj yeem yog vim cov ntaub ntawv raug cim tias nyeem nkaus xwb lossis vim lwm qhov piv txwv tau kaw nws. Kev daws:

• Nco ntsoov tias koj muaj kev tso cai kho kom raug.
• Txuag cov ntaub ntawv nrog lub npe txawv lossis lwm qhov chaw.
• Kaw tag nrho cov piv txwv ntawm Excel thiab rov qhib tsuas yog ib qho.

"Lub disk yog tag nrho"

Raws li peb tau hais, pub dawb qhov chaw ntawm lub tsav lossis sim txuag rau lwm lub disk. Yog tias koj khaws cia rau sab nraud drives, xyuas kom tseeb tias lawv tau txuas zoo thiab tsis txhob cuam tshuam thaum txuag.

"Cov ntaub ntawv npe tsis siv tau"

Xyuas kom tag nrho txoj kev (xws li cov folders thiab cov ntaub ntawv npe) tsis pub tshaj 218 cim. Yog tias muaj, ua kom luv txoj hauv kev los ntawm kev txuag cov ntaub ntawv hauv lub hauv paus nplaub tshev (xws li C: \) thiab siv lub npe luv.

Qhov yuam kev thaum txuag rau qhov chaw hauv network

Yog tias koj ua haujlwm hauv lub network thiab poob koj qhov kev sib txuas thaum ua haujlwm, Excel tuaj yeem tiv thaiv kev txuag thiab txawm tias tso cov lus yuam kev txog kev nkag tsis tau hauv network. Yog tias qhov no tshwm sim:

• Txuag cov ntaub ntawv hauv zos thiab luam nws rov qab mus rau lub network tsav thaum qhov kev sib txuas rov qab.
• Ntawm Windows tes hauj lwm, koj tuaj yeem hloov kho cov npe los txhim kho kev tiv thaiv kom tsis txhob raug cuam tshuam.

Qhov yuam kev cuam tshuam nrog Visual Basic rau Daim Ntawv Thov (VBA)

Yog tias cov ntaub ntawv suav nrog macros lossis VBA thiab ua tsis zoo, Koj tuaj yeem sim kho nws los ntawm kev rho tawm cov haujlwm VBA puas.. Raws li kev daws teeb meem, Nws raug nquahu kom tsim ib daim ntawv theej thaub qab thiab siv cov cuab yeej ua kom pom kev pom zoo kom tshem tawm cov khoom tsis raug ua ntej rov qhib thiab khaws cov ntaub ntawv.

Teeb meem nrog cov ntaub ntawv puas lossis puas

Yog tias koj xav tias koj cov ntaub ntawv tsis raug, Excel suav nrog kev ua haujlwm rau qhib thiab kho:

1. Qhib Excel, mus rau Khaws > Qhib.
2. Xaiv cov ntaub ntawv teeb meem.
3. Ntawm lub pob qhib, nyem lub xub thiab xaiv qhib thiab kho.

Hauv cov xwm txheej nyuaj, koj tuaj yeem siv cov cuab yeej thib peb xws li Wondershare Kho o Stellar Kho rau Excel, uas tso cai rau koj los kho cov ntaub ntawv puas los ntawm kev rov qab cov ntxhuav, qauv thiab lwm yam.

Cov lus qhia tiv thaiv thiab rov qab cov ntaub ntawv tsis tau khaws cia

Txhawm rau kom tsis txhob poob koj txoj haujlwm yav tom ntej, nws yog qhov tseem ceeb rau:

• Qhib thiab teeb tsa autosave: Qhov no Excel yuav txuag tsis siv neeg versions ib ntus.
• Txuas koj tus account Microsoft thiab siv OneDrive: Qhov no tso cai rau koj khaws cov thaub qab tsis siv neeg hauv huab.
• Kho qhov pib-txuag zaus: Koj tuaj yeem txo lub sijhawm kom muaj kev ruaj ntseg ntawm koj cov ntaub ntawv.

Yuav ua li cas rov qab unsaved ntaub ntawv?

Yog tias koj kaw Excel yam tsis tau txuag, sim cov txheej txheem no:

• Qhib Excel, mus rau Khaws > Cov ntaub ntawv > Tswj phau ntawv > Rov qab tau cov phau ntawv uas tsis tau khaws cia. Ntawm no koj tuaj yeem pom cov versions ib ntus.
• Nrhiav cov ntaub ntawv ib ntus hauv C:\Users\YourName\AppData\Local\Temp (hloov "Koj Lub Npe" rau koj lub npe siv). Nrhiav cov ntaub ntawv nrog extension .tmp ua.

Cov txheej txheem no ua rau muaj feem yuav rov qab tau koj txoj haujlwm tom qab qhov kev npaj tsis tiav.

Cov lus qhia thiab kev ua kom yuam kev kom tsis txhob muaj qhov yuam kev yav tom ntej hauv Excel

• Nco ntsoov khaws Office tshiab coj kom zoo dua ntawm kev ruaj ntseg thaj ua rau thaj thiab kho.
• Tsis txhob ua haujlwm ntawm cov ntaub ntawv khaws cia rau ntawm USB drives nkaus xwb los yog qhov chaw tsis ruaj tsis khov.
• Ua nquag luam nyob rau hauv ntau qhov chaw (hauv zos, huab, sab nraud tsav).
• Ceev faj ntawm tus neeg thib peb add-ons uas tsis tau lees paub thiab lov tes taw lawv yog tias koj tsis xav tau lawv.
• Tshawb xyuas koj qhov chaw cia ua ntej ua haujlwm nrog cov ntaub ntawv loj.

Cov lus pom zoo no pab txo txoj kev pheej hmoo ntawm kev ua yuam kev thaum txuag hauv Excel thiab tswj kev ncaj ncees ntawm koj cov ntaub ntawv txhua lub sijhawm.