Badbaadinta faylashaada waa tallaabo fiican laakiin haddii aad illowdo erayga sirta ah, waxaad waayi doontaa xogtaada. Dhammaanteen waan ognahay sida badanaa loo isticmaalo faylasha Excel si loo kaydiyo xogta muhiimka ah. Dadka intiisa badan waxay rabaan inay xafidaan xogtooda sirta ah iyagoo sir siinaya dhammaan buuga shaqada ama xaashi gaar ah oo faylka excel ah. Nasiib darro, haddii aad illowdo erayga sirta ah, uma baahnid inaad argaggixiso. Waad soo ceshan kartaa faylkaaga Maxaa dhacaya haddii aad rabto inaad ka saarto furaha sirta ah faylka Excel? Ma samayn kartaa? Haa, waxaa jira habab aad si fudud uga saari karto erayga sirta ah. Ma awoodi doontid inaad soo ceshato erayga sirta ah laakiin waxaad ka saari kartaa erayga sirta ah.

Sida looga saaro erayga sirta^(Password) ah ee Excel File

Habka 1: Ka saar erayga sirta ah ee xaashida shaqada ee Excel^{(Remove Excel Worksheet Password)}

Kahor intaanan bilaabin nidaamka, waxay ahaan lahayd badbaado inaad kaydiso xaashidaada. Si kastaba ha ahaatee, xogtu shaqo kuma laha habka laakiin wali qaadashada tillaabo taxadar leh ayaa noqon doonta fikrad wanaagsan.

Ka bilow magaca kordhinta^{(renaming the extension)} faylkaaga ".xlsx ilaa zip"

Markaad bedesho kordhinta hubi inaad shiday ikhtiyaarka kordhinta faylka ee hoos yimaada qaybta aragtida haddii aadan awoodin inaad aragto fidinta faylka faylalkaaga.

Tallaabada 1: Midig ku dhufo^{(Right-click)} faylka oo dooro ikhtiyaarka beddelka^(rename) . Guji haa^{( yes)} marka laguu sheego

Talaabada 2: Hadda waxaad u baahan tahay inaad soo saarto xogta faylasha zip adiga oo isticmaalaya ^{(extract the zip)}barnaamij kasta oo kombaresarada faylka ah^{( file compressor software)} . Waxaa jira software kala duwan sida 7 zip, WinRAR , iwm oo laga heli karo internetka.

Tallaabada 3: Ka dib soo saarista faylasha, waxaad u baahan tahay inaad hesho^(locate) " xl " folder.

Talaabada 4: Hadda soo ogow galka " Worksheets " oo guji si aad u furto.

Talaabada 5: Under galka Worksheet^{(Worksheet folder)} , waxaad ka heli doontaa xaashida^{( spreadsheet)} aad . Ku fur xaashida qoraalka ee Notepad. 

Tallaabada 6: Haddii aad haysato hal xaashi shaqo oo ka hoosaysa xaashida faafintaada, way kuu fududaan doontaa inaad horay u sii waddo. Si kastaba ha ahaatee, haddii ay dhacdo in aad kaydiso faylal badan, waxaad u baahan tahay inaad furto fayl kasta oo ku jira Notepad oo aad hubiso:

<sheetProtection algorithmName=”SHA-512″ hashValue=”x9RyFM+j9H4J3IFFhsHo3q1kQkuLydpJlLh2mdvfvk15He/Yps8xizWt/XkAJ//g+TyqgcU+8o1QBjQvKDqIzg==” saltValue=”57YXDPnVjawU5s1nGyT8fQ==” spinCount=”100000″ sheet=”1″ objects=”1″ scenarios=”1″/>

Xusuusin:^(Note:) "HashValue" iyo "qiimaha milixda" way ka duwanaan doonaan faylkaaga.

Tallaabada 7: Hadda waxaad u baahan tahay inaad tirtirto dhammaan xariiqda^{( delete the entire line)} laga bilaabo < sheetprotection….to =1/ >.

Tallaabada 8: Ugu dambeyntii kaydi faylkaaga .xml. Waxaad u baahan tahay inaad raacdo tallaabada 4 fayl kasta .xml oo aad kaydiso dhamaantood. Ku soo celi faylashan galkaaga sibka Si aad ugu darto galalka xml la beddelay, waxaad u baahan tahay inaad hubiso inaad haysato barnaamijka software-ka-buuxinta faylka oo ka^{(file compression software program )} furan nidaamka. Hadda waxaad u baahan tahay inaad dib u baadho meesha aad ku kaydisay faylalkaaga la beddelay oo aad ku kaydiso galka zip-ka adigoo isticmaalaya software-ka-buufinta faylka.

Talaabada 9: Magaca^(Rename) kordhinta faylkaaga dib ugu magacow .xlsx ka siib^{(back to .xlsx from zip)} . Ugu dambeyntii, dhammaan faylashaada waa kuwo aan la ilaalin oo si fudud ayaad u furi kartaa.

Sidoo kale Akhri: ^{(Also Read:)} Waa maxay faylka XLSX & Sida loo furo faylka XLSX?^{(What is an XLSX file & How to open XLSX File?)}

Habka 2: Ka saar gacanta ilaalinta erayga sirta ah ee Excel^{(Remove Excel Password Protection Manually)}

Haddii aad rabto inaad gacanta ku saarto ilaalinta sirta ah ee Excel, tillaabooyinkan hoos ku xusan ayaa ku caawin doona.

Tallaabada 1: Ka fur dhammaan^(All) barnaamijyada menu- ka ama ku qor Excel ^(Excel)sanduuqa^(excel) raadinta.

Tallaabada 2: Guji File oo u gudub qaybta Open . Guji furaha sirta ah ee ilaaliya faylka Excel^{(password protecting excel file)} .

Tallaabada 3: Ku qor erayga sirta ah^(password) oo fur^(open) faylka.

Talaabada 4: Guji " Faylka^(File) " ka dibna " Info " ka dibna ku dhufo Encrypt with password.^{(Encrypt with password.)}

Tallaabada 5: Ka saar erayga sirta ah sanduuqa oo ka tag sanduuqa faaruq^{(Remove the password from the box and leave the box empty)} . Ugu dambeyntii, dhagsii keydka^(save.)

Habka 3: Ka saar erayga sirta^(Password) ah ee Excel Password^{(Excel Password Remover)}

Waxaa jira qaar ka mid ah barnaamijyada ka saarista sirta ah ee Excel sidoo kale laga heli karo online. Haddii aad rabto inaad ka gudubto habka kor ku xusan ee ilaalinta faylalkaaga Excel, waxaad dooran kartaa habka aad uga saarto furaha sirta ah ee Excel.

https://www.straxx.com/

Mareegtan waxay ku siinaysaa pro iyo nooca bilaashka ah ee ikhtiyaarka ka saarida erayga sirta ah ee Excel. Waxaad ka heli doontaa macluumaad dhamaystiran oo ku saabsan sida ay u shaqeyso mareegahan. Waa shabakad fudud oo isticmaale-saaxiibtinimo ah oo kaa caawinaysa inaad ka saarto furaha sirta ah ee la illoobay ee faylkaaga Excel.

Habka 4: Ka saar furaha sirta^(Password) ah markaad kaydinayso faylka Excel

Habkan, waxaad ku baran doontaa sida meesha looga saaro erayga sirta ah ee Excel adiga oo kaydinaya feylkaaga Excel oo leh muuqaal “Save as”. Habkani waxa uu shaqayn doonaa oo kaliya haddii aad hore u taqaanay erayga sirta ah ee faylkaaga Excel oo aad rabto in aad ka saarto si aad u isticmaasho. Si aad meesha uga saarto, raac tillaabooyinka hoose:

Tallaabada 1: Fur faylka Excel ee erayga sirta ah lagu ilaaliyo^{(Open password-protected Excel file)} oo geli erayga sirta ah^{(Enter the password)} markaad isla markiiba gasho.

Talaabada 2: Guji tab "File" ee ku yaala dhinaca sare ee bidixda ka dibna dhagsii "Save As" ee liiska.

Tallaabada 3: Daaqada "Save As" ayaa furmi doonta. Guji "Tools" hoos-hoosaadka ka dibna dooro "Ikhtiyaarada Guud"^{(“General options”)} liiska.

Tallaabada 4: Xulashada Guud, ka tag meesha "password to open" iyo "password to modify"^{(leave the “password to open” and “password to modify”)} oo madhan^(empty) ka dibna riix OK oo furahaaga ayaa laga saarayaa.

Hadda waxaad awoodi doontaa inaad furto feylka Excel adigoon gelin furaha sirta ah.

Waxaan rajeyneynaa, hababka kor ku xusan waxay kaa caawin doonaan inaad ka saarto ilaalinta eraygaaga sirta ah faylkaaga Excel^{(remove password protection from your Excel file)} iyo sidoo kale xaashida shaqada. Si kastaba ha noqotee, xasuusnoow in xogta muhiimka ah ay u baahan tahay in la sugo, markaa xafid feylashaada Excel sirta sirta ah.

How to Remove Password from Excel File

Keeping your files secure is a nice step bυt in case you forgеt the pаssword, you will lоse уour data. We all are familiar with how frequently excel files are used to store important data. Most of the people wish to secure their confidential data by encrypting either the entire workbook or a particular sheet of the excel file. Unfortunately, if you forget the password, уou need not panic. You can recover yоur file. What if уou want to remove the password from the excel filе? Can you do it? Yes, there are some mеthods through which you can easіly remove the password. You would not be able to rеcoνer the password but can remove the paѕsword.

How to Remove Password from Excel File

Method 1: Remove Excel Worksheet Password

Before we start with the process, it would be safe to take a backup of your spreadsheet. However, data has nothing to do with the process but still taking a precautionary step would be a better idea.

Start with renaming the extension of your file from “.xlsx to zip”

While changing the extension make sure that you have turned on the file extension option under view section in case you are not able to see file extension of your files.

Step 1: Right-click on the file and select the rename option. Click on yes when prompted.

Step 2: Now you need to extract the zip files data by using any file compressor software. There are various software such as 7 zip, WinRAR, etc available on the internet.

Step 3: After the extraction of the files, you need to locate the “xl” folder.

Step 4: Now find out the “Worksheets” folder and click on it to open.

Step 5: Under the Worksheet folder, you will find out your spreadsheet. Open the spreadsheet with Notepad. 

Step 6: If you have a single worksheet under your spreadsheet, it will be easier for you to go ahead. However, in case you have multiple files saved, you need to open every single file in Notepad and check for:

<sheetProtection algorithmName=”SHA-512″ hashValue=”x9RyFM+j9H4J3IFFhsHo3q1kQkuLydpJlLh2mdvfvk15He/Yps8xizWt/XkAJ//g+TyqgcU+8o1QBjQvKDqIzg==” saltValue=”57YXDPnVjawU5s1nGyT8fQ==” spinCount=”100000″ sheet=”1″ objects=”1″ scenarios=”1″/>

Note: “HashValue” and “salt value” will be different on your file.

Step 7: Now you need to delete the entire line starting from <sheetprotection….to =1/>.

Step 8: Finally save your .xml file. You need to follow step 4 for every .xml file and save all of them. Add these files back to your zip folder. In order to add modified .xml files back, you need to ensure that you have a file compression software program open on the system. Now you need to browse back where you have saved your modified files and save it on the zip folder using the file compression software.

Step 9: Rename your file extension back to .xlsx from zip. Finally, all your files are unprotected and you can easily open them.

Also Read: What is an XLSX file & How to open XLSX File?

Method 2: Remove Excel Password Protection Manually

If you want to remove excel password protection manually, these below mentioned steps will help you.

Step 1: Open excel from All programs menu or type Excel in the search box.

Step 2: Click File and navigate to the Open section. Click on the password protecting excel file.

Step 3: Type the password and open the file.

Step 4: Click on the “File” then “Info” then Click on Encrypt with password.

Step 5: Remove the password from the box and leave the box empty. Finally, click on the save.

Method 3: Remove Password with Excel Password Remover

There are some excel password remove programs also available online. If you want to bypass the above-mentioned method of unprotecting your excel file, you can opt for the method to remove password with excel password remover

https://www.straxx.com/

This website gives you a pro and free version of the excel password remover option. You will get complete information about how it works on this website. It is a simple and user-friendly website that helps you to remove forgotten passwords of your excel file.

Method 4: Remove the Password while saving the Excel file

In this method, you will get to know how to remove excel password while saving your excel file with “save as” feature. This method will only work if you already know the password of your excel file and want to remove it for further use. To remove, follow the steps below:

Step 1: Open password-protected Excel file and Enter the password when prompt.

Step 2: Click the “File” tab in the top-left pane then click on the “Save As” option from the list.

Step 3: A “Save As” window will open. Click on the “Tools” drop-down then choose “General options” from the list.

Step 4: In the General Options, leave the “password to open” and “password to modify” field empty then click on OK and your password will be removed.

Now you will be able to open the excel file without entering the password.

Hopefully, the above-mentioned methods will help you to remove password protection from your Excel file as well as a worksheet. However, remember that important data needs to be secured, so keep your excel files password protected.

Related posts

• Sida Loo Furo Fayl kasta ASPX (U beddelo ASPX PDF)

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel? (2022)

• Waa maxay faylka XLSX & Sida loo furo faylka XLSX?

• Sida loo beddelo midabada mawduuca dukumeentiga ee barnaamijyada Microsoft Office

• Ku sawir Tool Tab in Ribbon of Office Microsoft maqan? Ku dar sidaas!

• Sida Sawir ama Sawir loogu rogo Word

• Sida loo soo celiyo farriimaha la tirtiray ee Microsoft Office

• Sida loo beddelo goobaha File Block ee barnaamijyada Microsoft Office

• Sida loo kaydiyo faylasha Microsoft Office Dropbox ee iPadka

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

• Soo deji Grammarly bilaash ah Firefox, Chrome, Microsoft Office

• Sida loo tirtiro nasashada qaybta Microsoft Word

• Sida dib loogu dajiyo erayga sirta ah ee Koontada Microsoft

• Sida Loo Soo Kabsado Arrimaha Musuqmaasuqa Xogta ee Microsoft Outlook

• Sida Loo Abuuro Oo Loo Badbaadiyo Xaashiyaha Faafinta Excel ee Microsoft Office ee Android

• Koobiyi Paste ma shaqaynayo Windows 10? 8 siyaabood oo loo hagaajiyo!

• Sida loo damiyo Microsoft Word Spell Checker

• Sida Loo Sameeyo Margins 1 Inch gudaha Microsoft Word