Dua li ntawm qhov tseeb tias, feem ntau, Microsoft Excel muaj qib siab ua haujlwm ntawm kev ua haujlwm, muaj teeb meem tshwm sim nrog rau daim ntawv thov no. Ib qho ntawm cov teeb meem no yog cov lus "yuam kev thaum xa ib lo lus txib rau ib daim ntawv thov." Nws tshwm sim thaum koj sim txuag los yog qhib ib cov ntaub ntawv, nrog rau kev nqa nrog nws ua lwm yam. Cia saib dab tsi ua rau qhov teeb meem no, thiab seb yuav kho li cas.
Ua rau yuam kev
Dab tsi yog qhov tseem ceeb ntawm qhov yuam kev no? Peb tuaj yeem paub qhov txawv hauv qab no:
- Kev puas tsuaj rau lub superstructure;
- Sim mus saib cov ntaub ntawv thov kev ua haujlwm;
- Tsis raug nyob rau hauv lub npe;
- Excel kev puas tsuaj.
Kev daws teebmeem
Txoj kev mus tshem tawm qhov yuam kev no yog nyob ntawm seb nws ua li cas. Tab sis, txij li ntau zaus, nws yog qhov nyuaj rau kev tsim kom muaj qhov ua rau nws tsis zoo, kev daws teeb meem ntau dua yog sim txoj kev sim ua kom pom qhov kev txiav txim siab ntawm cov kev xaiv hauv qab no.
Txoj kev cai 1: lov tes taw DDE Ignore
Feem ntau, nws muaj peev xwm tshem tawm qhov yuam kev thaum xa ib qho lus txib los ntawm qhov tsis taus DDE tsis lees paub.
- Mus rau lub tab "Cov Ntaub Ntawv".
- Nias ntawm yam khoom "Kev xaiv".
- Nyob rau hauv lub qhov tsis cov qhov rai uas tau qhib, mus rau qhov subsection "Qib Siab".
- Peb tab tom nrhiav ib qho chaw ntawm qhov chaw "General". Uncheck qhov kev xaiv "Ignore DDE kev thov los ntawm lwm cov kev siv". Peb nias lub khawm "OK".
Tom qab ntawd, nyob rau hauv ib qho tseem ceeb ntawm tus neeg mob, qhov teeb meem yog tshem tawm.
Txoj kev 2: Lov tes taw Compatibility hom
Lwm cov yuav ua rau muaj qhov teeb meem saum toj no yuav tsum tau muaj kev sib haum xeeb. Yuav kom lov tes taw nws, koj yuav tsum ua raws li cov kauj ruam hauv qab no.
- Peb tsiv, siv Windows Explorer, lossis lwm tus neeg saib xyuas cov ntaub ntawv, rau qhov chaw uas lub Microsoft Office software pack nyob rau hauv lub computer. Txoj kev rau nws yog raws li nram no:
C: Cov ntaub ntawv Microsoft Office OFFICE. Tsis tau. Tus naj npawb ntawm chav ua hauj lwm. Piv txwv, daim nplaub tshev uas Microsoft Office 2007 cov kev zov me nyuam raug khaws tseg yuav OFFICE12, Microsoft Office 2010 yog OFFICE14, Microsoft Office 2013 yog OFFICE15, thiab ntxiv rau. - Hauv daim nplaub tshev KOS, saib cov ntaub ntawv Excel.exe. Peb nias rau nws nrog txoj cai nas khawm, thiab nyob rau hauv lub ntsiab lus teb zaub mov peb xaiv qhov khoom "Cov khoom".
- Hauv Excel cov qhov rai uas qhib, mus rau lub tab "Compatibility".
- Yog tias muaj cov thawv tso rau ntawm sab xub ntiag "Khiav qhov kev pab cuam hauv hom kev sib tw"los yog "Khiav cov txheej txheem no ua thawj tswj hwm", ces tshem tawm lawv. Peb nias lub khawm "OK".
Yog tias lub checkboxes nyob rau hauv cov pawg lus uas tsis tsim, ces mus txuas ntxiv mus nrhiav lub hauv paus ntawm qhov teeb meem lwm qhov.
Txoj kev 3: Registry Cleanup
Ib qho ntawm cov txheej xwm uas ua rau ua yuam kev thaum xa ib qho lus txib rau daim ntawv thov nyob rau hauv Excel yog ib qho teeb meem nyob rau hauv lub npe. Yog li ntawd, peb yuav tsum tau ntxuav nws. Ua ntej yuav pib ua cov yeeb yam ntxiv kom thiaj li tiv thaiv tau yam tsis zoo ntawm txoj kev ua no, peb xav kom tsim kom muaj ib qho chaw rov qab.
- Yuav kom coj tau qhov "Run Run" qhov rais, sau yaum ua ke nrog Win + R ntawm cov keyboard. Hauv qhov rais qhib, nkag mus rau lo lus "RegEdit" tsis muaj quotes. Nias rau ntawm "OK" khawm.
- The Registry Editor opens. Nyob rau sab laug ntawm tus editor yog tsob ntoo. Tsiv mus rau qhov chaw "CurrentVersion" raws li hauv qab no:
HKEY_CURRENT_USER Software Microsoft Windows CurrentVersion. - Rho tawm tag nrho cov folders uas nyob hauv phau ntawv teev npe "CurrentVersion". Ua li no, nyem rau ntawm txhua phau ntawv nrog lub khawm txoj kev nas, thiab xaiv cov khoom hauv cov ntawv qhia zaub mov "Rho tawm".
- Tom qab qhov kev tshem tawm, ua kom tiav lub computer thiab kos cov kev ua tau zoo ntawm Excel.
Method 4: Lov tes taw kho vajtse acceleration
Kev daws ib ntus rau qhov teeb meem yuav xa tawm kho vajtse acceleration hauv Excel.
- Tsiv mus rau seem uas twb paub txog peb los ntawm thawj txoj kev daws teeb meem. "Kev xaiv" nyob rau hauv tab "Cov Ntaub Ntawv". Rov qab nyem rau ntawm yam khoom "Qib Siab".
- Nyob rau hauv lub qhib Excel siab xaiv qhov rais, saib qhov chaw thaiv "Npo". Teem ib zuam nyob ze qhov parameter "Lov tes taw Image kho acceleration". Ndliv lub khawm "OK".
Txoj kev 5: lov tes taw ntxiv
Raws li tau hais los saum no, ib qho ntawm qhov teeb meem no tej zaum yuav yog qhov ua txhaum ntawm qee yam ntxiv. Yog li, raws li qhov kev ntsuas ib ntus, koj tuaj yeem siv cov kev pabcuam ntxiv uas tsis yog Excel ntxiv.
- Ib zaug ntxiv, mus rau lub tab "Cov Ntaub Ntawv"rau seem "Kev xaiv"tab sis lub sij hawm no nias rau yam khoom Ntxiv-ons.
- Hauv qab kawg ntawm qhov rais hauv daim ntawv teev npe "Kev Tswj"xaiv yam khoom COM Ntxiv rau hauv. Peb nias lub khawm "Mus".
- Tshem tawm tag nrho cov add-ons uas tau teev tseg. Peb nias lub khawm "OK".
- Yog hais tias tom qab no, qhov teeb meem tau zoo, ces rov qab rov qab mus rau lub qhov rais ntxiv ntxiv IN COM. Teem ib zuam, thiab nias rau khawm "OK". Khij seb qhov teeb meem rov qab muaj rov qab. Yog hais tias txhua yam yog nyob rau hauv kev txiav txim, ces mus rau tom ntej add-in, lwm yam. Qhov ntxiv ntawm qhov uas qhov yuam kev rov qab yog neeg xiam oob khab, thiab tsis tau qhib lawm. Tag nrho lwm cov add-ons yuav tsum enabled.
Yog tias, tom qab kaw tagnrho cov add-ons, qhov teeb meem tseem tshuav, qhov no txhais tau hais tias ntxiv rau-ntxiv yuav tsum muab rau, thiab qhov yuam kev yuav tsum tau kho nyob rau lwm txoj hau kev.
Txoj kev 6: Pib dua Cov Ntawv Teev Npe
Koj tuaj yeem sim rov qab koom nrog cov koom haum ua ntaub ntawv thov kom daws tau qhov teeb meem.
- Los ntawm khawm "Pib" mus rau "Tswj Vaj Huam Sib Luag".
- Hauv Pawg Tswj Kev Xaiv, xaiv nqe lus "Cov kev pab cuam".
- Nyob rau hauv lub qhov rais uas qhib, mus rau seem "Cov Kev Pab Cuam Tshuam".
- Nyob hauv qhov chaw zov me nyuam qhov chaw zov me nyuam, ua ntej, xaiv qhov khoom "Sib piv ntawm cov ntaub ntawv hom thiab cov txheej txheem ntawm cov kev pab cuam tshwj xeeb".
- Hauv daim ntawv teev npe, xaiv qhov extension xlsx. Peb nias lub khawm "Hloov cov kev pab cuam".
- Nyob rau hauv daim ntawv teev cov kev pom zoo uas tau qhib, xaiv Microsoft Excel. Ndliv lub khawm. "OK".
- Yog hais tias Excel tsis nyob rau ntawm daim ntawv teev cov kev pom zoo, nyem rau ntawm lub pob "Ntsuam xyuas ...". Mus raws li txoj kev uas peb tham txog, sib tham txog kev daws qhov teeb meem los ntawm kev xa cov kev sib tw, thiab xaiv cov ntaub ntawv excel.exe.
- Peb ua cov yeeb yam zoo li cov xls ntxiv.
Txoj kev 7: Download tau lub qhov rais tshiab thiab nruab Microsoft Office
Xeem, tab sis tsis tsawg, qhov tsis tseem ceeb ntawm cov qhov rais tshiab yuav yog qhov ua yuam kev hauv Excel. Nws yog tsim nyog los xyuas seb puas muaj cov tshiab muaj downloaded thiab, yog tias tsim nyog, download tau cov uas ploj lawm.
- Rov qhib qhov kev tswj hwm dua. Mus rau seem "Qhov System thiab Kev Ruaj Ntseg".
- Nias ntawm yam khoom "Qhov Hloov Piav Qhia".
- Yog hais tias muaj lus nyob rau hauv lub qhov rais qhib hais txog qhov muaj tshiab, nias ntawm lub pob "Install Updates".
- Peb tos txog cov kev kho tshiab kom muab ntsia, thiab rov qab qhib lub tshuab computer.
Yog hais tias tsis muaj ib txoj hau kev los daws qhov teeb meem, ces nws yuav tsim nyog xav txog kev muab rov qab rau Microsoft Office software pob, los yog rov qab nruab qhov rais operating system ua ke.
Raws li koj tau pom, muaj ntau ntau txoj kev rau tshem tawm cov kev yuam thaum xa kev txib hauv Excel. Tab sis, raws li txoj cai, hauv txhua qhov teeb meem tsuas yog muaj ib txoj kev daws teeb meem xwb. Yog li, thiaj li yuav tshem tawm tau qhov teeb meem no, nws yog ib qho tsim nyog yuav tau siv txoj kev sim siab los siv ntau txoj kev los mus tshem tawm qhov yuam kev mus txog qhov tsuas yog kev xaiv.
