Chimwe chezvinhu zvakanakisa nezveExcel kugona kuchengetedza mafaera ako pamatanho ese. Iwe unogona kusarudza kuchengetedza Bhuku Rekushanda kubva pakushandurwa kwemaitiro, zvichireva kuti vanhu vasina mvumo havagoni kuchinja nhamba kana kurongeka kwemashizha mubhuku rekushanda. Iwe unogona zvakare kuseta password kudzivirira chero munhu kubva achinje mapepa ebasa, izvo zvinoreva kuti haakwanise kukopa, kugadzirisa kana kudzima chero zvirimo kubva pamapepa ebasa. Uye iwe unogona zvakare kuseta password yekuvhura iyo inodzivirira mumwe munhu kuvhura gwaro kunze kwekunge aine password.
Nepo mapassword aya achigona kushanda, anogona zvakare kukudzivirira kubva pakuwana kana kugadzirisa gwaro paunoda. Kana iwe usingakwanise kuwana gwaro reExcel kana spreadsheet nekuti hauzive password kana kuti waikanganwa, chinyorwa ichi chichabatsira zvakanyanya. Mariri, isu tichatarisa dzimwe nzira dzaungabvisa nayo password kubva kuExcel gwaro.
Chikamu 1: Ndeipi mukana wekubvisa password kubva kuExcel
Tisati takurukura kuti ungabvisa sei password kubva kuExcel sheet, isu tinofunga isu tinofanirwa kugadzirisa iyo general pfungwa yekuvhura password uye mukana wekuvhura Excel password.
Kuvhura pasiwedhi inzira inoshandisa nzira dzakasiyana siyana kudzoreredza kana kubvisa pasiwedhi kubva kune data rakachengetwa kana kufambiswa kuburikidza nekombuta system. Imwe yedzakanyanya kushandiswa nzira yekubvisa password ndeye brute force kurwisa nzira. Iyi nzira inoshandisa nzira yekufungidzira inoramba ichifembera mapassword akasiyana kusvika password chaiyo yawanikwa. Saka ndeipi mukana wekubvisa Excel password? Chokwadi chinotaurirwa, hapana chirongwa chinogona kuvimbisa 100% chiyero chekubudirira mumusika. Asi chirongwa chakanakisa chekudzivirira Excel mapepa chinogona kupfupisa nguva. Nokudaro, mukana wekubvisa kiyi unogona kuwedzera zvakanyanya.
Kune vanhu vasiri tekinoroji, isu tinokurudzira zvikuru kuti uedze Excel password unlocker kuti ikubatsire kubvisa password kubva kuExcel mafaera.
Chikamu 2: Maitiro ekubvisa password nekukurumidza
Kana usingakwanise kuvhura gwaro reExcel pasina password, zvinotevera ndedzimwe sarudzo dzaungaedza.
Nzira yekutanga: Bvisa Password kubva kuExcel Faira ine Passer yeExcel
Kuti uwane mukana wakanyanya wekubudirira, ungangoda kushandisa chirongwa chine simba: Passper yeExcel . Ichi chirongwa chekuvhura password chinogona kubatsira kukubatsira kupfuura password yekuvhura mune chero gwaro reExcel, kunyangwe yazvino vhezheni. Iyo ine akati wandei maficha akagadzirirwa kuita password kudzoreredza kuve nyore. Zvinosanganisira zvinotevera:
- Kurumidza kuvhura password : Iine imwe yeanomhanyisa password kiinura kumhanya pamusika, achikwanisa kuonesa angangoita 3,000,000 mapassword pasekondi.
- Mukana mukuru wekudzoreredza password - Inokupa iwe sarudzo yekusarudza kubva ku4 kurwisa modes uye duramazwi remamiriyoni eanowanzo shandiswa mapassword, zvichiwedzera kuwedzera mikana yekudzoreredza password uye zvakanyanya kuderedza nguva yekudzoreredza.
- Hapana kurasikirwa kwedata : Hapana kana imwe yedata iri muExcel gwaro rako ichakanganiswa neimwe nzira nemaitiro ekudzoreredza.
- Data kuchengetedza : Haufanire kurodha faira rako kune yavo server, saka, yako kuvanzika kwedata ndeye 100% yakavimbiswa.
- Hapana muganhu : Chirongwa ichi chinoenderana neshanduro dzese dzeWindows uye shanduro dzeExcel. Pamusoro pezvo, hapana chinogumira pane saizi yefaira.
Aya ndiwo mashandisiro aungaite Passper yeExcel kuvhura password-yakachengetedzwa Excel faira.
Danho 1 : Isa Passper yeExcel pakombuta yako wobva waitanga. Muhwindo guru, tinya "Dzora mapassword".
Danho rechipiri : Dzvanya bhatani rekuti “+” kuti usarudze gwaro reExcel raunoda kusadzivirira. Kana gwaro racho rawedzerwa kuchirongwa, sarudza nzira yekurwisa yaungada kushandisa uye tinya "Kupora." Iyo nzira yekurwisa yaunosarudza zvinoenderana nekuoma kwepassword uye kana iwe uine chero zano rekuti chingave chii.
Danho rechitatu : Paunongosarudza nzira yekurwisa, tora bhatani rekuti "Dzora" uye Passer yeExcel ichangotanga kushanda kuti idzore password. Mushure memaminitsi mashoma, maitiro acho anopera uye iwe unofanirwa kuona password pachiratidziri.
Unogona kushandisa password yakadzoserwa kuvhura iyo yakachengetedzwa Excel gwaro izvozvi.
Nzira yechipiri: Bvisa password kubva kuExcel faira online
Iko hakuna chikonzero chekuisa chero software pakombuta yako kuti ubvise password yekuvhura muExcel gwaro rako. Unogona kushandisa chimwe chezvishandiso zvakawanda zvepamhepo zvakagadzirirwa basa iroro. Kushandisa online turusi kunogona kunge kwakakunakira iwe kana iyo faira isina ruzivo rwakakosha uye password iri mubvunzo haina kusimba. Maturusi mazhinji epamhepo anoshandisa brute force kurwisa kudzoreredza nzira uye saka anongoshanda nezve 21% yenguva. Kune mamwe maturusi epamhepo ane 61% chiyero chebudiriro, asi iwo maturusi ekutanga, zvichireva kuti unofanirwa kubhadhara kuti uzvishandise.
Asi pamwe chakashata chikuru chekushandisa maturusi epamhepo inyaya yekuti iwe unofanirwa kurodha iyo Excel faira kupuratifomu yepamhepo. Izvi zvinoisa njodzi kune data riri muExcel faira sezvo usingazive zvichaitwa nevaridzi vechokushandisa online negwaro rako kana password yabviswa.
Cons yenzira iyi:
- Low kubudirira mwero : Recovery rate yakaderera kwazvo, isingasviki 100% chiyero chekubudirira.
- Kuganhurwa saizi yefaira : Online Excel password unlockers inogara iine muganho pane saizi yefaira. Kune mamwe mapassword ekuvhura, saizi yefaira haigone kudarika 10 MB.
- Kunonoka kupora : Paunenge uchishandisa Excel password kiinura online, iwe unofanirwa kuve neyakagadzikana uye ine simba internet yekubatanidza. Zvikasadaro, maitiro ekudzoreredza anozonyatso kunonoka kana kutomira.
Chikamu 3: Dhonza password yeExcel kuti ugadzirise
Sezvatakambotaura, zvakare hazvigoneke kuwana gwaro reExcel risingagone kugadziridzwa. Muridzi wegwaro anogona kuisa zvirambidzo zvinoita kuti zviome kune vashandisi kugadzirisa zviri mugwaro. Muchiitiko ichi, unogona kuedza imwe yeinotevera mhinduro:
Nzira yekutanga: Shandisa Passper yeExcel (100% Success Rate)
Kuwedzera kune Excel password kudzoreredza, Passper yeExcel Icho zvakare chishandiso chikuru chekuvhura Excel maspredishiti/mashizha ebasa/mabhuku ebasa. Nekudzvanya kamwe chete, zvese zvekugadzirisa uye zvirambidzo zvefomati zvinogona kubviswa ne 100% chiyero chekubudirira.
Heano maitiro ekuvhura yako Excel spreadsheet/workbook:
Danho 1 : Vhura Passer yeExcel pakombuta yako wobva wadzvanya "Bvisa Zvirambidzo."
Danho rechipiri : Dzvanya "Sarudza Faira" kupinza gwaro muchirongwa.
Danho rechitatu : Kana gwaro racho rawedzerwa, tinya "Delete" uye chirongwa chichabvisa chero zvirambidzo pagwaro mumasekonzi maviri chete.
Nzira yechipiri: Bvisa mapassword eExcel nekuchinja iyo File Extension
Kana uri kushandisa MS Excel 2010 kana kuti yapfuura, unogona kuvhura gwaro nekushandura faira rekuwedzera. Izvi ndizvo zvaunozviita.
Danho 1 : Tanga nekugadzira kopi yepassword-yakachengetedzwa Excel faira, saka une kopi kana chimwe chinhu chikatadza.
Danho rechipiri : Tinya-kurudyi faira wobva wasarudza "Rename." Chinja faira rekuwedzera kubva ku “.csv” kana “.xls” kuita “.zip”.
Danho rechitatu : Vhura zviri mukati meZip file richangogadzirwa wobva waenda ku "xl\worksheets\". Tsvaga bepa rekushanda raunoda kuvhura. Kurudyi tinya pairi uye sarudza iyo "Hora" sarudzo yekuvhura iyo faira muNotepad.
Danho rechina : Shandisa "Ctrl + F" basa kuvhura basa rekutsvaga uye kutsvaga "SheetProtection". Uri kutsvaga mutsara wemavara unotanga na; «
Danho rechishanu : Bvisa mutsara wese wezvinyorwa wobva wachengeta faira worivhara. Chinja faira rekuwedzera kuita .csv kana .xls.
Iwe hauchazoda password kana iwe uchida kugadzirisa kana kugadzirisa pepa rebasa.
Cons yenzira iyi:
- Iyi nzira inongoshanda kune Excel 2010 uye yekutanga shanduro.
- Unogona kuvhura bepa rekushanda rimwe chete panguva. Kana uine akawanda password-akadzivirirwa mapepa ekushanda muExcel faira, unofanira kudzokorora matanho ari pamusoro papepa rega rega.
Nzira 3: Tora password yeExcel kuburikidza neGoogle Sheets
Google Drive yaburitsa imwe nyowani yekutsigira password-yakachengetedzwa MS Office zvinyorwa. Google Drive inopa nzira isina kuoma yekuvhura chero gwaro reExcel kana iwe uchida kurigadzirisa. Matanho anotevera achakuudza nzira yekuvhura password-yakachengetedzwa Excel faira muGoogle Sheets.
Danho 1 : Enda kuGoogle Drive mune chero browser pakombuta yako wopinda kana usati watopinda.
Danho rechipiri : Dzvanya iyo "Itsva" tab uye sarudza Google Sheets. Kana iwe watoisa yako yakakiyiwa Excel faira paDrive yako, unogona kusarudza "Vhura" kuti uvhure faira racho zvakananga. Zvikasadaro, iwe unofanirwa kurodha faira rako nekudzvanya pane "Import" sarudzo.
Danho rechitatu : Zvino vhura gwaro rakachengetedzwa reExcel wobva wadzvanya pakona yekuruboshwe kuti usarudze maseru ese ari mugwaro iroro.
Danho rechina : Dzvanya "Kopi" kana kudzvanya Ctrl + C.
Danho rechishanu : Iye zvino shandisa purogiramu yako yeMS Excel uye wobva wadzvanya Ctrl+ V. Yese data mupassword yakachengetedzwa Excel spreadsheet ichaendeswa kune iri bhuku idzva rebasa. Iwe unogona ipapo kugadzirisa gwaro nenzira ipi zvayo yaunoda.
Cons yenzira iyi:
- Iyi nzira inotora nguva kana paine akawanda mapepa ebasa akakiyiwa mugwaro rako reExcel.
- Google Sheets inoda Indaneti yakagadzikana kuti uise mafaira. Kana yako Internet yekubatanidza isina simba kana faira rako reExcel rakakura, maitiro ekurodha anononoka kana kuparara.
Nzira 4. Bvisa Excel Spreadsheet Password neVBA Code
Nzira yekupedzisira yatichatarisa ndeye kushandisa VBA kodhi kuvhura iyo Excel spreadsheet. Iyi nzira inongoshanda kuExcel 2010, 2007, uye shanduro dzekutanga. Zvakakosha kuziva kuti nzira iyi inogona kubvisa password kubva papepa rekushanda. Kuvhura kwacho kwakaoma, saka matanho anotevera achabatsira.
Danho 1 : Vhura password yakachengetedzwa Excel spreadsheet ine MS Excel. Dzvanya "Alt+F11" kuti uvhure VBA hwindo.
Danho rechipiri : Dzvanya "Isa" uye sarudza "Module" kubva pane zvingasarudzwa.
Danho rechitatu : Isa kodhi inotevera muhwindo idzva.
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Danho rechina : Dzvanya F5 kuti uite murairo.
Danho rechishanu : Imbomira zvishoma. A new dialog box ichaonekwa ine password inoshandiswa. Dzvanya "OK" uye wobva wavhara VBA hwindo.
Danho rechitanhatu : Dzokera kune yako yakachengetedzwa Excel spreadsheet. Iye zvino, iwe uchaona kuti pepa rekushanda rakatariswa.
Cons yenzira iyi:
- Kana paine akawanda password-akadzivirirwa mapepa ekushanda muExcel yako, unofanirwa kudzokorora matanho ari pamusoro papepa rebasa rega rega.
Mhedziso
Kubvisa password kubva kuExcel gwaro hakufanirwe kuve kwakaoma. Nekukurumidza kudzoreredza kumhanya, mamwe maitiro ekurwisa uye chiyero chepamusoro chekudzoreredza, Passper yeExcel inopa yakanakisa sarudzo yekukurumidza kubvisa password kubva kune chero gwaro reExcel.
![Maitiro ekubvisa password kubva kuExcel VBA Project [4 Nzira]](https://www.passmapa.com/images/desbloquear-proyecto-vba-excel-390x220.png)