Runtii waxay noqon kartaa wax laga xumaado markaad tagto si aad u isticmaasho kheyraadka sirta ah ee lagu ilaaliyo oo aad illowday erayga sirta ah. Xataa boggaga xubinimada ee onlaynka ah waxay noqon karaan kuwo niyad jab ku filan. Laakiin haddii ay tahay mashruuc ku jira dukumeenti Excel ah oo sirta ah lagu ilaaliyo , ka dibna aad illowday erayga sirta ah - waxay noqon kartaa jid-gooyo aan la jeclayn horumarkaaga.

Nasiib wanaag, waxaa jira waxyaabo aad sameyn kartid si aad uga saarto erayga sirta ah ee Excel . Haddii aad rabto in dukumeentigaaga sirta ah uu ilaaliyo, waxaa laga yaabaa inaad rabto inaad dib u kaydiso oo aad ilaaliso ka dib markaad dillaacdo. Laakiin maqaalkan, waxaanu diirada saari doonaa qaybta dildilaaca.

Qaar ka mid ah Eray bixinta^{(Some Terminology)}

Ka saarida erayga sirta ah ee Excel waxa ay la socotaa taas oo kaliya - samaynta faylka si uusan u lahayn erayga sirta ah. Jebinta erayga sirta ah waa mar kale, sida uu u dhawaaqo, jebinta erayga sirta ah si aad u gasho faylka. Taasi waxay noqon kartaa kiis uu furaha sirta ah jabo marka la saarayo ama la jabiyo wadadii loo socday. 

Haa, dhawaaqyada dillaacsan^(cracked) waxay u eg yihiin kuwo jabay laakiin ka fikir hack . Haddii ay dhacdo in la jebiyo^(cracking) erayga sirta ah ee la illoobay, waxaad garanaysaa waxa erayga sirta ah yahay, si aad u gasho faylka.

Xaddid^{(Limitations)}

Barnaamijyo badan oo software-ka ah iyo fursadaha kale ee badan ee la heli karo waxay kaliya ku dambayn doonaan dhammaadka dhintay ama xaddid nooc ka mid ah. Tusaale ahaan waxay u shaqayn doonaan Excel 2007 laakiin uma shaqayn doonaan Excel 2016 ama Mac . Ama waxay ka shaqayn doonaan ilaalinta xaashida shaqada dhexdeeda laakiin maaha haddii aanad furi karin faylka (furaha sirta ah). 

Waxa xiiso leh, xulashooyinka software ee u shaqeyn doona shayadaas (ie Excel 2016, furaha sirta ah, Mac , iwm.) waxay sidoo kale u shaqeyn doonaan barnaamijyadii hore ee Excel . 

Haddaba, maxaad u soo iibsanaysaa laba barnaamij ama aad u baahan tahay inaad hal barnaamij u soo iibsato faylalka cusub oo aad ku shubto kombiyuutarkaaga barnaamij bilaash ah oo loogu talagalay faylalka duugga ah marka aadan u baahnayn? Waxay macno samaynaysaa inaad hesho barnaamijka saxda ah ee xaliya dhibaatadaada. In kasta oo * bilaashka ah * uu yahay mid cajiib ah, $ 9-30 maahan qiimo aad u xun, maaha marka aad tixgeliso wax badan oo qiimo leh (oo loo baahan yahay) softiweerku wuxuu socdaa $300-500.

Si aad u fududayso, halkan waxaa ah xulashooyin * bilaash ah * kuwaas oo laga yaabo inay ka saaraan erayga sirta ah ee Excel , kaa badbaadinaya inaad wax bixiso ama xitaa rakibto. Ka dib^(Later) waxaan tixgelin doonaa qaar ka mid ah xalalka software lacag bixinta.

Hababka bilaashka ah^{(Free Methods)}

Kuwa soo socda ayaa ah habab aad isku dayi karto kuwaas oo kuu ogolaanaya inaad xidho boorsadaada. Wax dammaanad ah ma leh, laakiin waa meel laga bilaabo. Maskaxda ku hay laba arrimood:

1. Haddii aad waqti ku yar tahay ama aad rabto waddo sahlan, waxaa laga yaabaa inaad rabto inaad si toos ah u aado xalalka lacag bixinta (software).
2. Sireeynta Excel ee ka hor 2013 aad ayaa loo fududeeyay. Taasi waxay ka dhigan tahay inay fududahay in la jebiyo warqad shaqo oo la ilaaliyo^(protected) kahor 2013. Mar labaad^(Again) , haddii aad rabto inaad ka boodo dhibka, nooca cusub ee xaashida shaqada (nooca cusub ee Excel ) waxaa laga yaabaa inaad rabto inaad ka boodo noocyada bilaashka ah oo aad toos u tagto kuwa la bixiyay.

Dhib maleh, ha ilaawin inaad kayd u ​​samayso faylka^{(make a backup of the file)} . In ka badan hal kayd ayaa noqon kara xigmad. Jeex nuqul ka mid ah faylka si aad u hubiso in aanu jirin musuqmaasuq ama waxyeelo soo gaadhay faylka asalka ah. Inta badan hababkan software iyo hababka bilaashka ah ma dhaawici karaan faylka, laakiin way fiicantahay inaad ku khaldanto dhinaca taxadarka.

Laba Hababka Qoraalka VBA^{(Two VBA Script Methods)}

Fikradda isticmaalka qoraalka VBA waa in laga shaqeeyo agagaarka habka hubinta erayga sirta ah ee Microsoft Excel oo la jebiyo erayga sirta ah ee Excel . Laakin waxa aad samaynaysaa adiga oo khiyaaneeya barnaamijka ka hor inta aan hawshu bilaabmin, iyada oo luuqadda qoraalka ubucda ah ee Visual Basic . 

Waxay u ekaan kartaa ikhtiyaarka geeky badan laakiin waa suurtogal habka ugu yar ee ku lug leh, marka waxaa laga yaabaa inaad rabto inaad marka hore tijaabiso.

Waa kan qoraalka VBA^{(VBA Script)} . Isla marka aad furto xaashida shaqada ee Excel^{(Excel Worksheet)} , gal Tifaftiraha Alt F11 (wuxuu ku shaqeeyaa Mac sidoo kale), ka dooro faylka liiska oo ku dheji qoraalkan daaqada cadeynta .^{(Declarations)}

Sub BreakPassword()

   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
      Exit Sub
   End If

   Next: Next: Next: Next: Next: Next
   Next: Next: Next: Next: Next: Next

End Sub

Ka dib markaad garaacdo badhanka orodka^(run) (F5) ee qoraalka VBA , sii wakhti iyo marka badhanka uu noqdo mid mar labaad la heli karo, waxaad ogaan doontaa in qoraalku dhammaaday. 

Waxaa jira dhowr fursadood. Tusaale ahaan, in version Mac ah, waxaad si fudud u bilaabi kartaa tafatirka faylka. Noocyo kale, sida Windows , ayaa ku siin doona erayga sirta ah ee ku meel gaadhka ah oo aad isticmaali karto si aad u furto dukumeentiga oo aad bilowdo tafatirka. Halkaa marka ay marayso, waxaad haysataa ikhtiyaarka aad ku dari karto furaha sirta ah ee cusub haddii aad rabto oo aad dib u kaydiso dukumeentiga erayga sirta ah.

Waxaa jira hab kale oo aad u fiican oo VBA Script ah kaas oo qaada faylka Excel oo dib u sameeya nuqul ka mid ah iyada oo aan lahayn erayga sirta ah. Waxaad ka koobi kartaa/ku dhejin kartaa qoraalka VBA boggan^{(this page)} .

John the Ripper Option

Ikhtiyaar kale oo ah in laga saaro erayga sirta ah ee Excel waa hab ka sii muhiimsan, adoo isticmaalaya terminalka. Waa nooca John the Ripper . Tani sidoo kale waa hab wax ku ool ah dildilaaca sirta guud oo si wax ku ool ah loo isticmaalay tobanaan sano. Qaar ka mid ah hababka kale, sida habka (yada) software-ka, waxay u badan tahay inay sahlan yihiin oo waxtar badan yihiin, gaar ahaan noocyada cusub ee Excel . 

Sidoo kale, haddii aad haysato nooc ka da'weyn oo Excel ah (ka hor 2013) oo aadan dan ka lahayn inaad daabacdo, Habka Qoraalka VBA^{(VBA Script Method)} waa mid waxtar leh. Habka John the Ripper , booqo boggan^{(this site)} oo u rog xagga hoose si aad u hesho habka/tilmaamaha.

XML/Zip Method (Pre-Excel 2013)

Ka dib markaad sameysid kaydinta faylka, waxaad sii wadi kartaa inaad isticmaasho habka XML/Zip si aad u jejebiso. 

• Dhammaan waxaad u baahan tahay inaad sameyso waa inaad ka beddeshaa kordhinta faylka xls ilaa zip si ay Windows u maleyneyso in faylka hadda yahay faylka zip halkii faylka Excel . Tani waxay u oggolaan doontaa gelitaanka XML ee jira (iyada oo loo malaynayo in habku shaqeeyo, kaas oo laga yaabo inaanay ahayn).
• Soo saar faylka hadda-zip oo raadi faylka XML . Waxay ku jiri doontaa tusaha  xaashida shaqada .^(worksheets)
• Faylka dhexdiisa, ka raadi ereyga xaashida Ilaalinta^{(sheetProtection)} oo marka aad hesho, ka saar summada ku lifaaqan. Calaamaddu waxay inta badan ka bilaabataa < waxayna ku dhammaataa > . Waxaad doonaysaa inaad meesha ka saarto dhammaan summada, bilawga ilaa dhammaadka. 
• Keydi faylka (wali zip). Ka dib markaad kaydiso faylka, dib u magacaw fidinta siibka^(zip) ilaa kordhintii asalka ahayd. Waa in aad diyaarsan tahay oo aad awood u leedahay inaad furto oo aad la shaqeyso faylka. 

Habkani si fiican uma uu shaqayn oo cilmi-baadhistu waxay sheegaysaa in ay u muuqato in ay kaliya u shaqeyso faylalka hore.

Wax kale (Xogta Uruurinta)^{(Other (Gathering Information))}

Waxaa jira ikhtiyaar kale oo sirta ah oo lagu taliyay oo loo yaqaan Excel Password Recovery Lastic . Waa doorasho xiiso leh, laakiin markii la tijaabiyay, way ku guuldareysatay inay soo jiidato, weligeed ma samayn wax madax ah. 

Taasi waxay tidhi, waxaa jira macluumaad waxtar leh oo laga yaabo in lagu soo ururiyo iyadoo la isticmaalayo barnaamijka xitaa haddii aysan dhamaystirin nidaamka dildilaaca erayga sirta ah (ama saarista).

• Kadib markaad soo dejiso software-ka, laba jeer dhagsii oo u gudub habka aad ugu rakiban tahay mashiinka  Windows -kaaga.^(Windows)
• Furitaanka barnaamijka ayaa kuu keeni doona daaqad u eg kan kore, ka dib marka uu sameeyo scan mashiinkaaga.

Barnaamijku wuxuu faa'iido u leeyahay inuu helo faylalka Excel kuwaas oo u baahan kara xoogaa caawimo ah, taasoo la macno ah kuwa sirta ah lagu ilaaliyo. 

Waxaad ogaan doontaa in faylka ugu horreeya ee liiska sare ku jira uu yahay fayl ka hor 2013 oo leh kordhinta xls iyo erayga sirta ah ee la furayo^{(Password to open)} wuxuu muujinayaa <CSP> . Labada fayl ee kale waa faylal 2016 waxayna muujinayaan kordhinta xlsx iyo Password- ka si loo furo ^{(Password to open)}<strong> .

Sirta ah ee faylka ugu horreeya ee liiska waa erayga sirta ah. ^(password.)Sidan baa loo dejiyay si ay imtixaanku u fududaato. Si kastaba ha ahaatee, xitaa iyada oo si fudud sirta ah, iyo ka sii muhiimsan, sirta daciifka ah (sababtoo ah nooca software Excel ), Excel Password Recovery^{(Excel Password Recovery Lastic)} Tool ayaa weli ku taliyay in la isku dayo doorasho kale. Waxay ku talisay in la booqdo Password-Find , oo aad ka heli karto faahfaahin dheeraad ah xagga hoose.

Faylasha kale (xlsx) sidoo kale waxay heleen talo la mid ah, taas oo la filayay. Haddii software-ku uu farsamayn kari waayo faylka ugu fudud markaa lama filayo in uu farsameeyo faylka Excel 2016 .

Hadda, halkan waa meesha software-kani uu ku caawin karo. Haddii aad haysatid xaashida xisaabaadka ee Excel oo aad ogtahay in erayga sirta ah la ilaaliyo laakiin aadan hubin ilaa xad, waxaad u ogolaan kartaa Excel Password Recovery Lastic inuu helo faylka (marka uu si toos ah u sawiro markaad furto barnaamijka) ka dibna kuu sheeg waxa nooca ilaalinta uu feylku leeyahay (fiiri sawirka kore). 

Waxaad ogaan doontaa in sawirka kore, ay muujinayso <CSP> , sidii aan hore u soo sheegnay, oo naga caawinaysa inaan ogaano nooca faylka (marka laga reebo caawinta kordhinta faylka yar, fiirin haddii ay tahay xls ama xlsx ).

Xog kasta oo yar ayaa ku caawisa. Adigoo isticmaalaya qalabka software-ka, waxaad, ugu yaraan, ogaan kartaa in faylka Excel uu ^(Excel)yahay furaha sirta ah^{(open password)} ama wax ka beddelka erayga sirta ah^{(modify password)} ama labadaba, ama isku-dar kale.

Sawirka kore wuxuu muujinayaa nooc faylal ah oo ka duwan. Ogaanshaha nooca ilaalinta faylka uu leeyahay (iyo sidoo kale nooca), waxay go'doomin kartaa nooca dildilaaca erayga sirta ah ee loo baahan yahay, tanina waxay naga badbaadin kartaa waqti, tamar, iyo suurtogal ahaan lacag. 

Software-kani waxa laga yaabaa in aanu samayn falka (dilaacay faylka) laakiin waxa uu ka caawiyay in la fahmo faylka iyo talaabooyinka xiga ee la qaadi doono.

Hababka Software-ka ee lacagta lagu bixiyo^{(Paid Software Methods)}

Si kastaba ha ahaatee habka aad dooratid inaad isticmaashid si aad uga saarto erayga sirta ah ee Excel , waxaa waxtar leh in la sameeyo nuqul ka mid ah faylka Excel kaliya haddii musuqmaasuq kasta uu ku dhaco habka. Guud ahaan, waxaad si fudud u koobi kartaa faylka aan la furin. Waxa kale oo jira habab kale oo gurmad ah oo ay fiican tahay in la sameeyo dhawr kayd, kaliya si loo badbaadiyo.

Dr.Excel ($29.95)

iSeePassword waxay bixisaa xirmo software ah oo lagu jebiyo furaha sirta ah ee Excel . Waxay sidoo kale bixiyaan ikhtiyaarrada furaha sirta ah ee Windows -ka, markaa ilaa xad waxay yihiin dukaan-joog ah. 

Sidoo kale, waxay si naxariis leh ugu filan yihiin inay bixiyaan tijaabo si aad u aragto haddii barnaamijku xitaa kuu shaqeeyo ka hor intaadan isticmaalin lacagta. Waxaa jira xulashooyin kugu filan oo laga yaabo inaad rabto inaad hubiso in software-ka aad go'aansato inaad isticmaasho uu leeyahay nooc tijaabo ah, oo kuu oggolaanaya inaad qiimeyso ka hor intaadan lacag isticmaalin.

• Marka rakibiddu dhammaato, hubi inaad gujiso sanduuqa Run ExcelPasswordRecovery.exe ka hor intaadan gujin dhame^(Finish) . ExcelPasswordRecovery.exe sidoo kale waa magaca software-ka, Dr.Excel .

• Tallaabada ugu horreysa waa in lagu daro faylka su'aasha. Waxaad taas samayn kartaa adiga oo gujinaya Add File ee geeska sare ee gacanta midig. 
• Tallaabada 2 ayaa kuu ogolaanaysa inaad doorato nooca weerarka. Sharaxaadyadu waa kuwo is-sharaxaya. Nooca weerarku wuxuu ku xiran yahay nooca erayga sirta ah ee aad isticmaashay.

Marka, tusaale ahaan, haddii aad xasuusato inaad isticmaashay furaha sirta ah ee runtii fufudud, laakiin aadan xasuusan waxa uu ahaa erayga sirta ah, waxaa laga yaabaa inaad rabto inaad isticmaasho Weerar Qaamuuska^{(Dictionary Attack)} si uu u isticmaalo ereyo caan ah. Waxa kale oo aad doorbidi kartaa Xoog-Burte-Force oo leh Weerrar Maaskaro ah^{(Brute-Force with Mask Attack)} oo laga yaabo inay qaadato wakhti yar. 

Maskaxda ku hay in aad u baahan doonto inaad gujiso Settings si aad u doorato waxyaabaha gaarka ah ee la xidhiidha nooca weerarka.

• Haddii aadan gujin Settings, Dr.Excel waa ku fiican yahay inuu ku xasuusiyo inaad sidaas sameyso ka dib markaad gujiso OK waxaad ku soo laaban kartaa oo guji Settings .

• Hadda waxaad diyaar u tahay inaad bilowdo weerarka. Maskaxda ku hay in si kasta oo software-kani u dhamaystiran yahay, ay qaadan karto wakhti. Furaha sirta ah ee faylka la tijaabiyay wuxuu ahaa erayga sirta ah^(password) , oo leh in ka badan lix xaraf, waxay qaadatay dhawr saacadood in la dilaaco. Markaa, fudaydnimadu maaha tilmaanta muddada ay qaadanayso.

PassFab ($19.95/yr)

Xalka software kale oo caan ah waa PassFab .

Haddii aad jeedsato ama aanad dheg u dhigin, biraawsarkaaga caadiga ahi waxa uu ku furmi karaa xaqiijinta in software-ka si guul leh loo rakibay. Goobtu waa passfab.com , isla goobtaas oo ah soo-saare software-ka waxaana si toos ah laguugu geynayaa Hagaha Degdegga ah^{(Quick Guide)} ee caawinta. 

Marka aad dhammayso website-ka, ku soo celi habka rakibida oo dhagsii badhanka dhame^(Finish) si aad u furto barnaamijka.

• Shaashadda xigta, waxaad haysataa ikhtiyaarka aad ku gujin karto Ku dar^(Add) oo dooro faylka sirta ah ee aad rabto inaad jebiso (ama ka saarto erayga sirta ah).

Isla shaashaddaas, marka aad doorato faylkaaga, waxaad haysataa ikhtiyaarka ah inaad doorato nooca weerarka aad rabto inaad isticmaasho, oo leh Qaamuuska Weerar^{(Dictionary Attack)} , Xoog Khariidad leh oo werar^{(Brute Force with Mask Attack)} , iyo Weerar Xoog leh^{(Brute Force Attack)} .

Ma la yaaban tahay waxa uu yahay dardargelinta GPU^{(GPU Acceleration)} ? Waa unug farsamayneed garaafeed^{(Processing Unit)} oo ka caawinaya in loo maareeyo dhinacyada muuqaalka kumbiyuutarka sida ugu hufan. Waa processor ka dheereeya kombuyuutarkaaga oo si weyn u dedejin kara weerarka.

Dejinta shaashaddan^(Settings) waxay kuu oggolaanaysaa inaad geliso qaamuus la habeeyey. Markaa haddii aad fikrad ka haysatid waxa erayga sirta ah yahay, waxa laga yaabaa inaad rabto inaad ku taxdo fursadahan qaamuuskaaga habaysan.

Aynu nidhaahno waxaad haysataa furaha sirta ah ee aad si joogto ah u isticmaashid oo marka lagugu qasbo inaad badasho aad ku darto nambar ama astaan ​​gaar ah. Inkasta oo erayga sirta ah uu ka duwan yahay waxa aad inta badan isticmaasho, xaqiiqadu waxa ay tahay in uu aad isku mid yahay. Tani waa fursadaada inaad ku darto erayga sirta ah (iyo kala duwanaanshihiisa) faylkaaga qaamuuska ee la habeeyey si ay kaaga caawiso dedejinta habka dildilaaca erayga sirta ah ee Excel .

Software -ka PassFab ee loo isticmaalay tijaabinta wuxuu ahaa nooc tijaabo ah si loo eego inuu shaqeeyo iyo in kale. Sida aad kor ku arki karto, software-ku wuxuu ku guuleystey inuu jabiyo erayga sirta ah. Ama ugu yaraan waxaynu u qaadanaynaa sidaas, anagoo ku salayna tirada jilayaasha iyo labada xaraf ee ugu horreeya ee iswaafaqaya. 

Furaha galkani wuxuu ahaa erayga sirta ah^(password) sida ku cad sanduuqa sare ee xuduudka cas leh.

PassFab wuxuu rabaa inuu ku fiicnaado si uu ku tuso in softiweerku uu shaqeeyo ka hor intaadan bixin wax lacag ah. Waxa jira dhawr ikhtiyaar oo liisan ah, kuwaas oo kuu oggolaanaya inaad doorato midka kugu habboon. Xasuusnoow^(Remember) , in kasta oo shatiga noloshu uu qiimo fiican leeyahay, haddii shirkadu ka baxdo ganacsiga software-ku ma heli doono casriyeyn.

Taasi maaha saadaal PassFab laakiin waa faallo ku saabsan dabeecadda shatiga software guud ahaan.

Excel Password saar Pro^{(Excel Password Remover Pro)} (waa kala duwan yahay)^{(Excel Password Remover Pro (Varies))}

Xirmada softiweerka (ama xirmooyinka softiweerka) waa noocyo iyo adeegyo aad u kala duwan, markaa hubi inaad akhrido sharraxaadda ka hor intaadan lacag isticmaalin. Sawirka kore wuxuu muujinayaa liiska software-ka ee la heli karo waqtiga qorista.

Hababka Intarneedka ee Lacag bixinta^{(Paid Online Methods)}

Waxaa jira qaar ikhtiyaari ah oo laga heli karo gelitaanka khadka tooska ah. Waxa kale oo jira doorashooyin aad ku soo gudbin karto faylkaaga si ay kuwa kale kuugu dilaan oo ay ku siiyaan xigasho. Waxaan ku soo darnay ikhtiyaarada iskaa wax u qabso ee laga heli karo onlayn.

Password-Find.com (19.95/39.95)

Password-Find waa ikhtiyaarka uu soo jeediyay software-ka Lastic ee kore - software-ka ka caawiyay bixinta macluumaadka ku saabsan faylasha su'aasha si aan u qaadno hab aqooneed iyaga.

Garaafyada tilmaamuhu aad bay u cad yihiin. Tusaale ahaan, tallaabada ugu horreysa waa inaad geliso faylka aad rabto inuu dillaaco, ama laga saaro erayga sirta ah.

Tallaabada labaad, waa waqtigii la dooran lahaa habka. Xaaladdan oo kale, halkii aad ka fikiri lahayd nooca^(type) ama habka^(method) waxaad eegaysaa natiijada. Wali waa hab/soo dhowaansho laakiin go'aami nooca natiijada aad rabto. Ma doonaysaa in aad ka saarto erayga sirta ah ee Excel ama aad ogaato waxa uu yahay erayga sirta ah? 

Waxay macno samaynaysaa in taladu ay tahay in meesha laga saaro erayga sirta ah maadaama aad had iyo jeer kaydin karto faylka (ama dib u kaydin karto faylka) erayga sirta ah ee kale, habkaas (saarida erayga sirta ah) waa dhakhso. Tani waxay ahayd habka la doortay inta lagu jiro tijaabada.

Horumariyayaashu waxay ku talinayaan ikhtiyaarka kale (go'aaminta/helidda erayga sirta ah) xaaladaha laga yaabo inaad haysato dhowr faylal iyo furaha sirta ah ee dhammaantood. Taasina waxay macno samaynaysaa sababtoo ah haddii aad isticmaasho habka saarista oo aad haysato 50 fayl waa inaad martaa habkaas 50 jeer.

Laakiin haddii aad isticmaasho habka dildilaaca hal fayl oo ay qaadato wakhtiga saddexda faylal ee sirta ah ka saarista (lambarka kaliya tusaale ahaan), waxaad kaydisay wakhtiga ay ku qaadan lahayd 47 fayl kale sababtoo ah waxaad ogaatay. erayga sirta ah ee 50 ka fayl.

Waxtarka iyo xawaaraha xalkan khadka tooska ah wuxuu ahaa mid aad u cajiib ah. Weli waxaa jira weji sugitaan inta software-ku uu qabanayo shaqadiisa, laakiin tijaabinta feylkeena Excel 2016 waxay ahayd ilbiriqsi, ma ahayn saacado.

Waxaa xusid mudan in software-kani uusan na siinin faylka laakiin wuxuu na siiyay fursad aan ku aragno faylka aan la ilaalin (password-ka laga saaray). Iyadoo software-ka kale ay na siiyeen qayb ka mid ah aragtida faylka, kiiskan waxaan awoodnay inaan ku aragno faylka dhamaystiran ee horudhaca, caddaynta inuu shaqeeyay.

Ikhtiyaarka waa View online . Xusuusnow inaad gujiso tirtirto^(delete) si aad meesha uga saarto faylkaaga si aadan uga tagin xaashida daabacaadda shaqsiyeed ama ganacsi ee internetka meel.

Sida aad kor ku arki karto, waxaa jira laba ikhtiyaar oo iibsi ah, oo bixiya xalal kala duwan oo ku xiran baahidaada.

Password-Online.com (10 EUR)

Doorashada khadka tooska ah ee ugu dambeysa waa password-online.com . Markaad booqato goobta, waxaad arki doontaa Online Password Recovery Online^{(Excel Password Recovery Online)} ee bar menu ee sare. Waxay u muuqataa in ay leeyihiin hal-cabbir-ku habboon-dhan, hal tallaabo. 

Halkaa marka ay marayso, waxaad geli kartaa faylkaaga sir ah, sida badhanku leeyahay. Lasoco^(Follow) oo waad socotaa

Waxaa lagaa doonayaa inaad geliso iimaylkaaga, taasoo u oggolaanaysa inay ku ogeysiiyaan marka faylkaagu diyaar yahay. Xawaaraha aad ku hesho faylkaagu wuxuu ku xidhan yahay inta faylal ee kaa horeeya, heerka kakanaanta, iyo wax kasta oo kale oo saamayn kara kuwa bixiya adeega.

In kasta oo adeeggan si fiican loogu qiimeeyay 10 EUR oo keliya , ma bixinayso qiyaas inta uu faylkaagu qaadan karo dhammaystirka. Waxaa laga yaabaa inaad dareento fiicnaan inaad wax yar oo dheeri ah ku bixiso fursadaha kale qaarkood haddii aad rabto in badan oo la xakameeyo habka.

How to Remove, Crack, or Break a Forgotten Excel XLS Password

It сan be really frustrating when yоu go to use a password-рrotected resource and yoυ have forgоtten the password. Even online membership sites can be frustrating enough. Bυt if it is a projeсt in a password-protected Excel document, and you then forgot the рassword – іt can be an unwelcome roadblock in your progress.

Fortunately, there are some things you can do to remove a password from Excel. If you want your document password-protected, you may want to re-save and protect it after you have cracked it. But for this article, we will be focusing on the cracking part.

Some Terminology

Removing the password from Excel refers to just that – making the file such that it does not have a password anymore. Breaking the password is again, like it sounds, breaking the password so you can gain access to the file. That could be a case where the password is broken on its way to removal or broken on its way to being cracked. 

Yes, cracked sounds like broken but think hack. In the case of cracking a forgotten password, you are figuring out what the password is, so you can gain access to the file.

Limitations

Many software programs and the multitude of other options available will only result in a dead end or limitation of some sort. For example they will work for Excel 2007 but not for Excel 2016 or Mac. Or they will work for protection within the worksheet but not if you cannot open the file (open password). 

Interestingly, software options that will work for those items (i.e. Excel 2016, open password, Mac, etc.) will also work for the older Excel programs. 

So, why buy two programs or have to buy one program for the new files and clutter up your computer with a free program for the older files when you don’t need it?  It makes sense to get the right program that solves your problem. And while *free* is wonderful, $9-30 is not an absolutely horrible price, not when you consider a lot of valuable (and needed) software runs $300-500.

Too keep it simple, here are some *free* options that might remove the password from Excel, saving you from having to pay or even install anything. Later we will consider some paid software solutions.

Free Methods

The following are some methods that you can try that might allow you to keep your wallet closed. No guarantees, but it is a place to start. Keep in mind two things:

1. If you are short on time or want an easier route, you might want to go straight to the paid solutions (software).
2. The Excel encryption prior to 2013 was quite simplified. That means it is easier to crack a worksheet that was protected prior to 2013. Again, if you want to skip the hassle, for a newer version of the worksheet (newer version of Excel) you might want to skip the free versions and go straight for the paid.

No matter what, don’t forget to make a backup of the file. More than one backup can be wise. Crack a copy of the file so you can ensure that there is no corruption or damage to the original file. Most of these software methods and free methods do not damage the file but it is better to err on the side of caution.

Two VBA Script Methods

The idea of using a VBA script is to work around the password checking mechanism of Microsoft Excel and break the Excel password. But you do it by fooling the program before the process starts, with the core scripting language of Visual Basic. 

It might seem the more geeky option but it is possibly the least involved method, so you might want to try it first.

Here is the VBA Script. As soon as you open the Excel Worksheet, access the Editor with Alt F11 (works on Mac, too), choose the file from the list and paste this script in the Declarations window.

Sub BreakPassword()

   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
      Exit Sub
   End If

   Next: Next: Next: Next: Next: Next
   Next: Next: Next: Next: Next: Next

End Sub

After hitting the run button (F5) for the VBA script, give it some time and when the button becomes available again, you will know that the script has finished. 

There are a couple of possibilities. For example, in the Mac version, you can simply start editing the file. Other versions, like Windows, will give you a temporary password that you can use to unlock the document and start editing. At this point, you have the option to add a new password if you like and re-save the document with that password.

There is another excellent VBA Script method that takes the Excel file and recreates a copy of it without the password(s). You can copy/paste the VBA script from this page.

John the Ripper Option

Another option to remove a password from Excel is a more core approach, utilizing the terminal. It is the John the Ripper version. This is also an effective method for general password cracking and has been used effectively for decades. Some of the other methods, like the software method(s), are probably easier and more effective, especially for the newer versions of Excel. 

Also, if you have an older version of Excel (pre-2013) and you don’t mind typing, the VBA Script Method is effective. For the John the Ripper method, visit this site and scroll to the bottom for the how-to method/instructions.

XML/Zip Method (Pre-Excel 2013)

After you have made a backup of the file, you can proceed to use the XML/Zip method to crack it. 

• All you need to do is change the extension on the file from xls to zip so that Windows thinks that the file is now a zip file instead of an Excel file. This will allow access to the XML that exists (assuming the method works, which it may not).
• Extract the now-zip file and look for the XML file. It will be in the worksheets directory. 
• Within the file, search for the term sheetProtection and when you find it, remove the tag that encloses it. A tag usually starts with < and ends with >. You want to remove the entire tag, beginning to end. 
• Save the file (still zip). After saving the file, rename the zip extension to the original extension. You should be all set and able to open and work with the file. 

This method did not perform well and research says that it seems to only work for the older files.

Other (Gathering Information)

There is another password option that is recommended called Excel Password Recovery Lastic. It is an interesting option but when tested, it failed to impress, never making any headway. 

That said, there is some helpful information that may be gleaned by using the program even if it doesn’t complete the process of password cracking (or removing).

• After downloading the software, double-click on it and go through the process of installing it on your Windows machine. 
• Opening the program will bring you to a window that looks like the one shown above, after it has done a scan of your machine.

The program is useful in that it finds the Excel files that may need some help, meaning those that are password-protected. 

You’ll notice that the first file in the list above is a pre-2013 file with an extension of xls and the Password to open shows <CSP>. The other two files are 2016 files and show the extension of xlsx and the Password to open of <strong>.

The password for the first file in the list is password. It was set this way to keep the testing simple. However, even with an easy password, and more importantly, weak encryption (because of the version of Excel software), the Excel Password Recovery Lastic tool still recommended that another option be tried. It recommended a visit to Password-Find, which you can find more details about below.

The other files (xlsx) also received the same recommendation, which was expected. If the software could not process the easiest file then it wouldn’t be expected to process the Excel 2016 file.

Now, here is where this software may be helpful. If you have an Excel spreadsheet and you know it is password protected but you are not sure to what extent, you could let Excel Password Recovery Lastic find the file (when it does its automatic scanning when you open the program) and then tell you what type of protection the file has (see above image). 

You’ll notice that in the image above, it shows the <CSP>, as we mentioned earlier, helping us to know what version of file (beyond that little file extension help, looking at whether it is xls or xlsx).

Every little bit of information helps. By using this software tool, you can, at least, figure out whether the Excel file is an open password or modify password or both, or some other combination.

The image above shows a different file type. Knowing what type of protection the file has (as well as version), can isolate what type of password cracking is needed, and this might save us time, energy, and possibly money. 

This software may not have done the deed (cracked the file) but it helped to understand the file and what steps to take next.

Paid Software Methods

No matter what method you choose to use to remove the password from Excel, it is helpful to make a backup of the Excel file just in case any corruption occurs in the process. Generally, you can simply duplicate the unopened file. There are also other methods of backup and it is fine to make a couple of backups, just to be safe.

Dr.Excel ($29.95)

iSeePassword offers a software package for cracking Excel passwords. They also offer options for normal Windows passwords, so to some extent they are a one-stop-shop. 

Also, they are kind enough to offer a trial so that you can see if the program even works for you before you spend the money. There are enough options out there that you might want to ensure that the software you decide to use has a trial version, allowing you to evaluate before spending money.

• When the installation is complete, be sure to click the box for Run ExcelPasswordRecovery.exe before clicking Finish. ExcelPasswordRecovery.exe is also the name of the software, Dr.Excel.

• The first step is to add the file in question. You can do that by clicking on Add File in the upper right-hand corner. 
• Step 2 lets you pick the type of attack. The descriptions are pretty self-explanatory. The type of attack depends on what type of password you used.

So, for example, if you recall that you used a really easy password but you do not remember what that password was, you may want to use a Dictionary Attack so that it uses more common words. You may also prefer a Brute-Force with Mask Attack that might take less time. 

Keep in mind that you will need to click on Settings to choose specifics related to the attack type.

• If you do not click on Settings, Dr.Excel is nice enough to remind you to do so and after clicking OK you can return and click on the Settings.

• You are now ready to start the attack. Keep in mind that no matter how thorough this software is, it can take a while. The password on the file tested was password, and with over six characters, it took several hours to crack. So, simplicity is not an indicator of how long it takes.

PassFab ($19.95/yr)

Another popular software solution is PassFab.

If you turn away or are not paying attention, your default browser may open with a confirmation that the software was successfully installed. The site is passfab.com, the same site that is the developer of the software and you are taken directly to the Quick Guide for help. 

When you have finished with the website, return to the installation process and click the Finish button to open the program.

• On the next screen, you have the option to click Add and choose the password-protected file that you want to crack (or remove the password).

On that same screen, once you have selected your file, you have the option to choose what type of attack you want to use, with Dictionary Attack, Brute Force with Mask Attack, and Brute Force Attack.

Are you wondering what GPU Acceleration is? It is a Graphical Processing Unit that helps to manage the computer’s visual aspects in the most efficient manner. It is a faster processor than your computer processor and can speed up the attack considerably.

The Settings on this screen allows you to upload a customized dictionary. So if you have an idea of what the password is, you may want to list these possibilities in your customized dictionary.

Let’s say you have a particular password that you use regularly and when you are forced to change it you add a number or a special character to it. Though the password is somewhat different than what you usually use, the reality is that it is pretty much the same. This is your opportunity to include that password (and its variations) in your customized dictionary file to help speed up the process of cracking the password in Excel.

The PassFab software that was used for testing was a trial version to see if it worked. As you can see above, the software managed to crack the password. Or at least we are assuming so, based on the number of characters and the first two characters that match. 

The password for this file was password as shown in the above box with the red border.

PassFab wants to be nice enough to show you that the software works before you have to spend any money. There are a number of license options available, allowing you to choose the one that suits you best. Remember, that while a lifetime license is good value, if the company goes out of business the software will no longer receive upgrades.

That is not a prediction with PassFab but rather a comment on the nature of software licensing in general.

Excel Password Remover Pro (Varies)

The final software package (or software packages) are quite a few different types and services, so be sure to read the description before spending money. The image above shows a listing of the software that is available at the time of writing.

Paid Online Methods

There are some options available via online access. There are also options to submit your file for others to crack for you and give you a quote. We included the semi-self-serve options available online.

Password-Find.com (19.95/39.95)

Password-Find was the option suggested by the Lastic software above — the software that helped to provide information about the files in question so that we could take an educated approach to them.

The graphics for the instructions are very clear. For example, the first step is to upload the file that you want cracked, or password removed.

In step two, it is time to select the approach. In this case, instead of thinking of type or method you are looking at the outcome. It is still a method/approach but decide what type of outcome you want. Do you want to remove the password in Excel or figure out what the password is? 

It makes sense that the recommendation is to remove the password since you can always save the file (or re-save the file) with another password, and that approach (removing the password) is faster. This was the method chosen during testing.

The developers recommend the other option (determining/finding the password) in cases where you may have several files and the same password for all of them. And that makes sense because if you use the removal process and you have 50 files you have to go through that process 50 times.

But if you use the cracking method on one file and it takes the time of three file password removals (just a number for example sake), you have saved the amount of time it would have taken for the other 47 files because you have figured out that password for the 50 files.

The effectiveness and speed of this particular online solution was very impressive. There is still a waiting phase while the software does its work, but for testing on our Excel 2016 file it was seconds, not hours.

It is worth noting that this software did not give us the file but rather gave us the opportunity to view the unprotected (password removed) file. While other software gave us partial views of the file, in this case we were able to see the complete file in the preview, proving that it worked.

The option is View online. And remember to click delete to remove your file so as not to leave your personal or business spreadsheets on the internet somewhere.

As you can see above, there are two options for purchase, offering different solutions depending on your needs.

Password-Online.com (10 EUR)

The final online option is password-online.com. When you visit the site, you will see Excel Password Recovery Online in the menu bar above. It appears that they have a one-size-fits-all, one step process. 

At this point, you can upload your encrypted file, just like the button says. Follow along and you are on your way.

You’ll be required to enter your email, allowing them to notify you when your file is ready. The speed at which you receive your file depends on how many files are ahead of yours, the level of complexity, and any other factors that may impact those providing the service.

Though this service is well priced at only 10 EUR, it gives no estimate on how long your file might take to complete. You might feel better paying a little extra with some of the other options if you want more control of the process.

Related posts

• Sida loo xafido erayga sirta ah ee Excel File

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Sida loo daro oo loo daabaco sawirada asalka ah ee Excel

• Sida Loo Sameeyo Liiska hubinta gudaha Excel

• Sida loo isticmaalo VLOOKUP gudaha Excel

• Sida Si Toos ah Loogu Soo Kabto Dukumeenti Word OneDrive

• Sida Loogu Beddelayo Inta u dhaxaysa Waraaqaha Shaqada ee Excel

• Jadwalka xogtaada Excel

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Geli xaashida shaqada ee Excel Word Doc

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Sida loo xisaabiyo kala duwanaanshaha Excel

• Sida loo isticmaalo COUNTIFS, SUMIFS, AVERAGEIFS gudaha Excel

• Balacaha Saarka AutoFit iyo Dhismayaasha Saf ee Excel

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel