Ukhohlwe iphasiwedi yakho ye-Excel? Izindlela ezi-6 zokuvula i-Excel ngaphandle kwephasiwedi
« Ngaphambilini ngavikela ifayela le-Excel ngephasiwedi, kodwa manje sengikhohlwe iphasiwedi ye-Excel. Umbuzo wami usesimweni esifana nalesi ukuthi ngingalivula kanjani ifayela ?»
Abantu abaningi bengeza amagama ayimfihlo kumafayela e-Excel ukuze bakhawulele ukufinyelela noma ukuguqulwa, kodwa ngezinye izikhathi, kwenzeka kakhulu ukuthi abantu bakhohlwe iphasiwedi ye-Excel. Lokhu kungakhungathekisa njengoba abasebenzisi abaningi bangase balahlekelwe amafayela abalulekile. Kodwa akusadingeki ukhathazeke ngalokho. Uma ukhohlwe iphasiwedi yakho ye-Excel, ziningi izindlela zokuvula ifayela lakho le-Excel, futhi kulesi sihloko, sizokwethula izindlela ezibalulekile ongazisebenzisa ukuze uvule iphasiwedi yakho ye-Excel.
Isimo 1. Vula ukhohlwe iphasiwedi ye-Excel ukuze uvule ifayela
Ungalivula kanjani ifayela le-Excel elivikelwe ngephasiwedi uma ukhohlwe iphasiwedi? Uma uzithola ukulesi simo, zama lezi zindlela ezimbili ezilandelayo.
Indlela Engcono Kakhulu: Iphasiwedi Ye-Excel Password Unlocker
I-Passer ye-Excel Ingelinye lamathuluzi alula futhi asebenza kahle kakhulu uma kuziwa ekuvuleni amagama ayimfihlo e-Excel akhohliwe. Ungakwazi ukuvula iphasiwedi yakho ye-Excel ngaphandle kokuthinta idatha esefayela. Leli thuluzi liphinde libe nezinga eliphezulu lempumelelo njengoba lisebenzisa ama-algorithms anamandla ukuvula iphasiwedi. Ngezansi izici eziyinhloko zalesi Sivuleli Sephasiwedi Se-Excel.
- Inezinhlobo ezi-4 zokuhlasela , okungukuthi ukuhlasela okuhlangene, ukuhlaselwa kwesichazamazwi, ukuhlasela kwemaski kanye nokuhlasela kwe-brute force, ukunciphisa isikhathi sokutakula nokwandisa izinga lokuphumelela.
- Ithuluzi lingavula amashidi/izincwadi zokusebenza ngemizuzwana ngaphandle kwesidingo sephasiwedi.
- Ingabe Kulula ukuyisebenzisa . Ungabuyisa iphasiwedi ekhohliwe ye-Excel kalula njengo-1-2-3.
- Njengoba kuwuhlelo lwedeskithophu, ungavula ifayela le-Excel ngqo kukhompyutha yakho. Ngakho-ke, i- ubumfihlo bedatha yakho buqinisekisiwe ngokugcwele .
- Ihambisana nezinguqulo ze-Microsoft Excel kusukela ku-97 kuya ku-2022. Futhi akukho mkhawulo kusayizi wefayela .
Ungaphinda uhlole izinyathelo ezilula ngezansi ukuze uvule ifayela le-Excel elivikelwe ngephasiwedi:
Isinyathelo 1. Yethula i-Pass ye-Excel, futhi uzobona i-interface yomsebenzisi eyinhloko. Khetha "Phinda uthole amaphasiwedi."
Isinyathelo 2. Chofoza isithonjana "+" ukuze wengeze ifayela le-Excel ofuna ukubuyisela iphasiwedi yakho. Uma lokhu sekwenziwe, ungakhetha imodi yokuhlasela ngokuya ngesimo sakho.
Isinyathelo sesi-3. Manje usungakwazi ukuphumula futhi ulinde ukuthi inqubo yokutakula iphele. Isikhathi sokuthola kabusha sihlobene eduze nobunkimbinkimbi bephasiwedi kanye nohlobo lokutakula olukhethayo. Ngemuva kokuthi igama-mfihlo livele kusixhumi esibonakalayo, ungalikopisha efayeleni lakho le-Excel elibethelwe bese ulivula.
Indlela Ejwayelekile: Phinda Uthole Iphasiwedi Ekhohliwe Ye-Excel Ku-inthanethi
Uma ungafuni ukufaka noma yiziphi izinhlelo zezinkampani zangaphandle kukhompuyutha yakho siqu, ungazama ukusebenzisa ithuluzi lokuthola kabusha eliku-inthanethi. Kulula futhi ukuvula amaphasiwedi e-Excel ku-inthanethi, kodwa kudinga uxhumano lwe-inthanethi oluzinzile nolunamandla. Futhi, kufanelekile ukusho ukuthi udinga ukulayisha ifayela lakho kuseva yabo ukuze uqhubeke nokuthola. Asincomi ukuthi usebenzise le ndlela uma ifayela lakho le-Excel lihlanganisa noma yiluphi ulwazi olubucayi.
Kubasebenzisi abanoxhumo lwe-inthanethi oluqinile futhi abangenandaba nokulayisha amafayela, izinyathelo ezilandelayo zizokusiza uvule amafayela akho e-Excel.
Isinyathelo 1: Finyelela kuwebhusayithi esemthethweni ye-Password Online Recovery.
Isinyathelo sesi-2: Chofoza okuthi “Layisha ifayela lakho elibethelwe” ukuze ulayishe ifayela lakho le-Excel.
Isinyathelo sesi-3: Ngemva kokulayisha, kufanele ufake ikheli le-imeyili elivumelekile.
Isinyathelo sesi-4: Hlola ibhokisi lakho lokungenayo le-imeyili ukuze wenze kusebenze inqubo yokususa ukubethela.
Isinyathelo sesi-5: Linda ithuluzi ukuthi likubuyisela iphasiwedi. Uzokwaziswa nge-imeyili uma ukutholwa sekuqediwe. Iphasiwedi etholiwe izothunyelwa kuwe ngemuva kokukhokha.
Isimo 2. Vula ukhohlwe iphasiwedi ye-Excel ukuze ulungise ifayela
Uma usethe igama-mfihlo ukuze uliguqule ngokungagunyaziwe kodwa ukhohlwe igama-mfihlo leshidi/incwadi yokusebenzela, ngeke ukwazi ukwenza izinguquko ebhukwini lakho lokusebenza noma eshidini. Uma ukulesi simo, ungakwazi ukususa lo mkhawulo ngezindlela ezinikezwe ngezansi.
Vula iphasiwedi ukuze uguqule kuwo wonke amashidi e-Excel ngokuchofoza oku-1
Nge I-Passer ye-Excel Njengoba sishilo ngenhla, ungakwazi ukuvula iphasiwedi ukuze uyilungise ngokuchofoza okukodwa ngisho noma amashidi amaningi evinjiwe ukuthi angalungiswa.
Lezi yizinyathelo okumele uzilandele:
Isinyathelo 1. Faka futhi uqalise i-Passer ye-Excel. Khetha okuthi “Susa Imikhawulo” kumenyu enkulu.
Isinyathelo 2. Chofoza okuthi “Khetha ifayela” ukuze wengeze isipredishithi se-Excel ofuna ukususa kuso imikhawulo.
Isinyathelo 3. Chofoza okuthi "Susa" futhi iphasiwedi yemikhawulo izosuswa phakathi nemizuzwana.
Vula i-Excel Spreadsheet nge-VBA Code
Indlela yesibili esizoyibheka ukusebenzisa ikhodi ye-VBA. Le ndlela izosebenza kuphela ku-Excel 2010, 2007 nezinguqulo zangaphambili. Uma ukhohlwe iphasiwedi ye-Excel 2013/2016/2020/2021, hlola ezinye izindlela esizethula kulesi sihloko.
Qaphela: Kufanele wazi ukuthi le ndlela isebenza kuphela ngamashidi axegayo. Uma unamashidi amaningana okhohlwe ngawo amagama ayimfihlo, kuzodingeka ukuthi usebenzise ikhodi yeshidi ngalinye, uwavule ngemva kwelinye.
Isinyathelo 1: Vula ifayela le-Excel osukhohlwe iphasiwedi.
Isinyathelo sesi-2: Cindezela ukhiye we-Alt plus F11 kukhibhodi yakho bese kuvela iwindi le-VBA.
Isinyathelo sesi-3: Chofoza okuthi “Faka” kubha yamathuluzi bese ukhetha “Imojula” kuzinketho.
Isinyathelo sesi-4: Faka ikhodi yakho ye-VBA efasiteleni le-VBA.
Isinyathelo sesi-5: Cindezela ukhiye F5, futhi ikhodi izokwenziwa.
Isinyathelo sesi-6: Linda imizuzu embalwa ukuze ikhodi ye-VBA isuse ukubethela kwephasiwedi ye-Excel. Kuzovela iwindi elisha le-pop-up lapho uzothola khona iphasiwedi. Yibhale phansi futhi ulisebenzise ukuvula ishidi lakho lokusebenza.
Ukhohlwe iphasiwedi yakho ye-Excel? Vula Iphasiwedi ye-Excel usebenzisa i-Zip
Le ndlela isebenza kumafayela e-Excel akhona ezinguqulo ze-Excel zango-2007 no-2019. Hlola izinyathelo ezingezansi.
Isinyathelo 1: Faka i-7-Zip nanoma yiluphi olunye uhlobo lwethuluzi lokucindezela le-Zip njenge-WinRar ku-PC yakho.
Isinyathelo sesi-2: Sebenzisa ukucindezela ukuze uvule ifayela le-Excel. Chofoza kwesokudla efayeleni bese ukhetha "Vula nge-WinRar noma i-7-Zip."
Isinyathelo sesi-3: Ukuze ususe ukuvikelwa kwephasiwedi kusipredishithi sakho, hamba kokuthi “xlworksheets.”
Isinyathelo sesi-4: Thola ishidi ukuthi ukhohlwe iphasiwedi. Chofoza kwesokudla bese ukhetha inketho "Hlela".
Isinyathelo sesi-5: Cindezela u-Ctrl+F ukuze uthole ithegi ethi “” bese uyisusa.
Isinyathelo sesi-6: Ngemva kokususwa, gcina ifayela bese uvala umhleli. Manje, ishidi lakho lokusebenza lihloliwe.
Vula ifayela le-Excel ngaphandle kwesofthiwe
Uma ukhetha ukuvula ifayela lakho le-Excel ngaphandle kokusebenzisa noma iyiphi isofthiwe, kusenenye indlela yakho. Ukuze ugweme noma yikuphi ukulahleka kwedatha, dala ikhophi yasenqolobaneni yesipredishithi sakho se-Excel kuqala bese ulandela izinyathelo ezingezansi ukuze uvule i-Excel ku-inthanethi.
Isinyathelo 1: Vula i-Google Drayivu bese ungena ngemvume ku-akhawunti yakho ye-Gmail. Chofoza ithebhu “Entsha” bese ukhetha i-Google AmaSpredishithi.
Isinyathelo sesi-2: Ekhoneni eliphezulu kwesokunxele kwesikrini, chofoza Ifayela bese Ngenisa.
Isinyathelo sesi-3: Ibhokisi lengxoxo lizovela; Chofoza okuthi “Layisha” bese ukhetha ifayela kudivayisi yakho ukuze ulayishe ishidi le-Excel elivikelwe ngephasiwedi.
Isinyathelo sesi-4: Ngemva kokulayisha ispredishithi sakho se-Excel, khetha okuthi “Buyisela Ispredishithi” bese uchofoza okuthi “Ngenisa Idatha.” Ishidi le-Excel elivikelwe lizovuleka ku-Google AmaSpredishithi.
Isinyathelo sesi-5: Iya kokuthi “Ifayela” bese uchofoza okuthi “Landa Njenge,” bese ukhetha “I-Microsoft Excel.”
Isinyathelo sesi-6: Ngemva kokuvula leli fayela elisha, uzobona ukuthi ispredishithi/ibhuku lakho lokusebenzela alisavikelekile ngephasiwedi.
Qaphela: Isivinini sokulayisha sihamba kancane futhi inqubo yokulayisha izobambeka uma kunamaspredishithi amaningi kufayela lakho le-Excel. Ukwengeza, ifayela elisha olilande ku-Google AmaSpredishithi lizobonakala livikelekile. Kufanele unike amandla ukuhlela mathupha.
Ithiphu: Ingabe sikhona isixazululo uma ukhohlwe iphasiwedi yakho ye-Excel ku-Mac?
Njengoba ubona, izixazululo ezingenhla zokutholwa kwephasiwedi ye-Excel ikakhulukazi ezabasebenzisi beWindows. Njengomsebenzisi we-macOS, ungahle uzibuze ukuthi ungayibuyisela yini iphasiwedi ye-Excel ekhohliwe ku-Mac. Kule ngxenye sizokucacisela konke. Ungaqhubeka ufunda.
Uma udinga ukuvula iphasiwedi ekhohliwe ye-Excel ukuze ulungise ishidi lakho le-Excel noma incwadi yokusebenzela, izindlela ezishiwo ngenhla njengokusebenzisa ikhodi ye-VBA nesoftware ye-ZIP nayo ingasebenza kuma-macOS. Kodwa-ke, uma ufuna ukubuyisela igama eliyimfihlo elikhohliwe ukuze ufinyelele ifayela lakho le-Excel, kunezindlela ezi-2 kuphela zokukusebenzela. Lezi zindlela ezimbili ziwukusebenzisa uhlelo lwe-Keychain Access noma ukudlulisa ifayela lakho le-Excel kukhompuyutha ye-Windows futhi ubuyisele iphasiwedi ngethuluzi elifana I-Passer ye-Excel .
Manje, sizogxila ekutheni ungawathola kanjani kabusha amaphasiwedi akhohliwe e-Excel ku-Mac ngohlelo lwe-Keychain Access. Ungalandela umhlahlandlela onemininingwane elandelayo:
Isinyathelo 1: Thola ifolda "Uhlelo" kukhompyutha yakho bese uyivula. Okulandelayo, iya kokuthi “Izinsiza> Ukufinyelela kwe-Keychain”. Chofoza ukuze uyivule.
Isinyathelo sesi-2: Thola "Amagama Okungena" kuphaneli yesokunxele yohlelo Lokufinyelela Kwe-Keychain bese uchofoza kulo.
Isinyathelo sesi-3: Uzobona ikholomu "Igama" phezulu kwesokunxele esikrinini esikhulu sohlelo. Manje, skrolela phansi uze uthole "Excel" bese uchofoza kukho.
Isinyathelo sesi-4: Isikrini esisha sizovela. Hlola inketho ethi "Bonisa iphasiwedi" kuthebhu "Izimfanelo". Esinye isikrini sizovela futhi kuzodingeka ufake iphasiwedi ye-keychain "yokungena".
Isinyathelo sesi-5: Cindezela okuthi "Vumela" ukuze uqhubeke. Uzobona iphasiwedi ebhokisini elithi "Bonisa iphasiwedi".
Isiphetho
Ukuthola kabusha iphasiwedi yakho ye-Excel oyikhohliwe akudingeki kube yingcindezi noma kukhungathekise. Ziningi izindlela ezisebenzayo ongavula ngazo ifayela lakho le-Excel njenge I-Passer ye-Excel . Ungasebenzisa leli thuluzi kunoma iyiphi inguqulo ye-Excel.
