Microsoft Excel yog ib qho kev siv dav siv los npaj, txheeb xyuas thiab pom cov ntaub ntawv. Txawm li cas los xij, qee zaum thaum ua haujlwm nrog nws koj yuav ntsib teeb meem thaum sim qhib Excel cov ntaub ntawv.
Thaum koj nyem ob npaug rau cov ntaub ntawv thiab tsis muaj dab tsi tshwm sim, lossis thaum Excel cov ntaub ntawv qhib tab sis tsis pom, koj yuav xav tias ntxhov siab. Qhov no tuaj yeem muaj teeb meem tshwj xeeb yog tias koj xav tau nkag mus rau cov ntaub ntawv hauv cov ntaub ntawv tam sim ntawd.
Hmoov zoo, peb muaj qee qhov kev daws teeb meem los pab koj daws qhov teeb meem. Hauv tsab xov xwm no, peb yuav qhia koj txog qee yam uas koj tuaj yeem sim kom tau txais koj cov ntaub ntawv Excel qhib thiab pib ua haujlwm dua. Peb tseem yuav qhia koj yuav ua li cas qhib cov ntaub ntawv Excel tiv thaiv tus password yog tias koj muaj teeb meem nrog qhov ntawd, ib yam nkaus.
Part 1: Yuav ua li cas thaum ib daim ntawv Excel tsis tuaj yeem qhib
"Vim li cas kuv tsis tuaj yeem qhib kuv cov ntaub ntawv Excel?" Nws yog ib qho teeb meem uas ntau tus neeg siv ntsib thaum siv MS Excel. Yog tias koj muaj teeb meem tib yam, tsis txhob txhawj: koj tsis nyob ib leeg.
Muaj ob peb lub laj thawj yog vim li cas "Excel nres qhib cov ntaub ntawv" qhov xwm txheej yuav tshwm sim, suav nrog:
- Vim Microsoft kev ruaj ntseg hloov tshiab
- Cov ntaub ntawv yog incompatible nrog koj version ntawm MS Office
- Daim ntawv thov Excel lossis cov ntaub ntawv tsis raug lossis puas
- Cov ntaub ntawv txuas ntxiv tsis raug lossis hloov kho
- Plugins cuam tshuam nrog qhib cov ntaub ntawv
Txawm hais tias Excel yog ib qho software nrov heev, thiab Microsoft ua haujlwm tas li los xyuas kom meej tias nws cov neeg siv tsis muaj teeb meem, qee zaum koj yuav tsis tuaj yeem qhib Excel cov ntaub ntawv.
Yog tias koj tseem tab tom ntsib qhov teeb meem no thiab tsis paub yog vim li cas, ntawm no yog qee qhov kev daws teeb meem uas tuaj yeem pab koj daws nws:
Txoj Kev 1: Kho koj lub Microsoft Office
Ib qho ntawm thawj yam uas koj tuaj yeem sim thaum koj cov ntaub ntawv Excel yuav tsis qhib yog kho Microsoft Office. Qhov no ua haujlwm yog tias MS Office nws tus kheej ua rau muaj teeb meem thiab tiv thaiv koj los ntawm kev qhib cov ntaub ntawv.
MS Office Repair pab koj daws ntau yam teeb meem tshwm sim, suav nrog cov cuam tshuam nrog Excel cov ntaub ntawv tsis qhib.
Rau qhov no, ua raws li cov kauj ruam no:
Kauj ruam 1: Mus rau "Control Vaj Huam Sib Luag" thiab nyob rau hauv "Programs" seem nyem rau ntawm "Uninstall ib qhov kev pab cuam" xaiv.
Kauj ruam 2: Txoj nyem rau ntawm Microsoft Office thiab xaiv "Hloov" kev xaiv.
Kauj ruam 3: Nyob rau hauv lub qhov rai tom ntej uas tshwm, xaiv "Online Kho" thiab ua raws li cov lus qhia kom ua tiav cov txheej txheem.
Kev daws 2: Uncheck lub thawv "Ignore DDE" lub thawv.
Yog tias thawj qhov kev daws teeb meem tsis ua haujlwm rau koj, tsis txhob txhawj. Muaj lwm txoj kev xaiv. Ib qho kev daws teeb meem los daws cov teeb meem "Excel tsis qhib" cov teeb meem yog kom tshem tawm "Ignore DDE" lub thawv.
Dynamic Data Exchange (DDE) yog cov txheej txheem uas tso cai rau cov ntawv thov sib txawv los qhia cov ntaub ntawv. Cov txheej txheem no tuaj yeem ua rau muaj teeb meem nrog MS Office daim ntawv thov, suav nrog qhov tsis muaj peev xwm qhib Excel cov ntaub ntawv thaum tus neeg siv nyem rau ntawm nws.
Txhawm rau tshem tawm lub thawv "Ignore DDE", ua raws cov kauj ruam no:
Kauj ruam 1 : Qhib MS Excel thiab mus rau "Cov Ntaub Ntawv" tab.
Kauj ruam 2 : Nyem "Options" thiab ces xaiv "Advanced".
Kauj ruam 3 : Hauv qhov "Advanced" xaiv qhov rais, nqes mus rau ntu "General" thiab tshem tawm lub thawv nyob ib sab ntawm "Tsis quav ntsej lwm daim ntawv thov uas siv Dynamic Data Exchange (DDE)" thiab txuag cov kev hloov pauv.
Txoj Kev 3: Disable Plugins
Yog tias koj tseem muaj teeb meem qhib koj cov ntaub ntawv Excel, qhov tom ntej no koj tuaj yeem sim yog lov tes taw cov add-ins uas yuav cuam tshuam nrog qhib cov ntaub ntawv.
Excel add-ins yog cov cuab yeej thib peb uas tuaj yeem ntxiv rau Microsoft Office Excel txhawm rau txhim kho nws txoj haujlwm. Txawm hais tias lawv feem ntau muaj txiaj ntsig zoo, qee zaum lawv tuaj yeem ua teeb meem.
Txhawm rau lov tes taw plugins, ua raws li cov kauj ruam no:
Kauj ruam 1 : Qhib MS Excel thiab mus rau "Cov Ntaub Ntawv" tab.
Kauj ruam 2 : Nyem "Options" thiab ces xaiv "Add-ons".
Kauj ruam 3 : Hauv "Add-ons" qhov rai, xaiv "COM Add-ons" los ntawm cov ntawv qhia zaub mov nco thiab nyem "Mus".
Kauj ruam 4 : Nyob rau hauv lub qhov rais tom ntej, uncheck tag nrho cov thawv thiab nias "OK".
Tshuaj 4: Rov pib dua Excel Cov Ntaub Ntawv Koom Tes rau Default
Yog tias tsis siv cov add-ins tsis ua haujlwm, lossis koj tsis muaj ib qho kev teeb tsa, sim rov pib dua tag nrho Excel cov ntaub ntawv koom nrog rau lawv cov nqi qub. Qhov no yuav ua kom ntseeg tau tias qhov kev pabcuam raug (Excel daim ntawv thov) qhib thaum koj sim qhib cov ntaub ntawv Excel.
Txhawm rau rov pib dua cov ntaub ntawv koom nrog, ua raws li cov kauj ruam no:
Kauj ruam 1 : Qhib "Control Vaj Huam Sib Luag" thiab mus rau "Programs> Default Programs> Teem koj cov program default"
Kauj ruam 2 : Lub qhov rais yuav qhib qhia "Default Apps" hauv Windows Settings. Los ntawm no, tsuas yog scroll down me ntsis thiab nyem "Tsim kev ua haujlwm los ntawm app."
Kauj ruam 3 : Tom ntej no, nrhiav "Microsoft Excel" program hauv cov npe thiab nyem rau ntawm nws. Tom qab ntawd nyem "Manage".
Kauj ruam 4: Thaum kawg, xaiv cov extensions ntawm cov ntaub ntawv uas tsis qhib thiab teem lawv default application rau Excel.
Solution 5: Tau txais kev pab los ntawm Microsoft Support
Yog tias koj tau sim tag nrho cov kev daws teeb meem saum toj no thiab koj tseem tsis tuaj yeem qhib koj cov ntaub ntawv Excel, qhov zoo tshaj plaws uas koj tuaj yeem ua yog nug Microsoft kev pab.
Microsoft muab kev txhawb nqa pub dawb rau txhua yam khoom siv hauv Office, yog li yog tias koj muaj teeb meem nrog koj cov ntaub ntawv Excel, lawv pab pawg kws tshaj lij yuav tsum tuaj yeem pab koj daws qhov teeb meem.
Txhawm rau tiv tauj lawv, mus rau "https://support.microsoft.com/contactus/" thiab sau daim foos.
Part 2: Yuav ua li cas qhib ib lo lus zais-tiv thaiv Excel yam tsis muaj tus password
Raws li koj tuaj yeem pom, muaj ntau qhov kev daws teeb meem uas koj tuaj yeem sim yog tias koj muaj teeb meem qhib koj cov ntaub ntawv Excel. Tab sis yuav ua li cas yog tias cov ntaub ntawv tiv thaiv tus password thiab koj tsis muaj ib qho?
Yog tias koj pom koj tus kheej hauv qhov xwm txheej no, tsis txhob txhawj. Qhov no yog qhov Passper rau Excel tuaj txog.
Passper rau Excel yog tsim los pab cov neeg siv rov qab poob lossis tsis nco qab lo lus zais rau lawv cov ntaub ntawv Excel. Nws yog cov cuab yeej muaj zog thiab siv tau yooj yim uas tuaj yeem pab koj sai sai rov qab nkag mus rau koj cov ntaub ntawv Excel tiv thaiv.
Tsis tas li ntawd xwb, tab sis koj kuj muaj ntau dua txoj kev vam meej, tso cai rau koj rov qab mus ua haujlwm ntawm koj cov ntaub ntawv sai li sai tau.
Qee qhov tseem ceeb ntawm Passper rau Excel yog:
- Nws yog sib xws nrog tag nrho cov versions ntawm MS Excel, los ntawm 1997 txog 2019.
- Muaj 4 txoj kev tawm tsam tus password muaj zog
- 100% kev nyab xeeb siv nrog tsis muaj caij nyoog ntawm cov ntaub ntawv poob
- Kev ua tau zoo tshaj plaws thiab lub sijhawm rov qab sai tshaj plaws
- Tsis muaj kev txwv ntawm cov ntaub ntawv loj
- Kev sim dawb thiab nyiaj rov qab lav
Nov yog yuav ua li cas siv Passper rau Excel los qhib cov ntaub ntawv Excel tiv thaiv tus password yam tsis muaj tus password:
Kauj ruam 1: Download tau thiab nruab Passper rau Excel ntawm koj lub computer. Tom ntej no, qhib qhov program thiab nyem "Tshem tawm Passwords."
Kauj ruam 2: Xaiv tus password-tiv thaiv Excel cov ntaub ntawv koj xav qhib, tom qab ntawd xaiv hom kev tawm tsam thiab nyem "Rov qab".
Kauj ruam 3: Tos kom txog thaum qhov kev pab cuam pom tus password ntawm koj cov ntaub ntawv Excel thiab tom qab ntawd nyem "Copy" khaws cia rau hauv daim ntawv teev lus thiab qhib cov ntaub ntawv Excel tiv thaiv.
Xaus
Txawm hais tias Microsoft Excel yog ib qho kev tsim qauv zoo thiab feem ntau ua haujlwm zoo, tseem muaj qee lub sijhawm thaum cov neeg siv ntsib teeb meem thiab qhov tsis raug uas ua rau nws nyuaj rau qhib Excel cov ntaub ntawv. Vam tias cov kev daws teeb meem hauv kab lus no yuav pab koj kho qhov teeb meem kom koj tuaj yeem nkag mus rau koj cov ntaub ntawv Excel tseem ceeb yam tsis muaj teeb meem.
Thiab yog tias koj tsis nco qab lossis poob tus password ntawm koj cov ntaub ntawv Excel tiv thaiv tus password, Passper rau Excel tuaj yeem pab koj rov nkag tau hauv ob peb kauj ruam yooj yim nrog 100% kev ua tiav. Yog li, kuj xav sim nws yog tias koj nyam.
