This Domain Is For Sell, Contact: admin@mrvsto.com
Jun 012010
 

1、Rename the file to .zip, for example, test.xlsx rename to test.zip.
2、Unzip the .zip file, then open \xl\worksheets\sheet1.xml (if sheet1 has password).
3、Delete this code: <sheetProtection password=…….. />, save.
4、Zip the folder to test.zip, the rename it to test.xlsx.
5、Enjoy




Hot:

● Use Microsoft Office 2007 like a Pro!
● Excel Expert User-Your One Stop Solution In Mastering Microsoft Excel
● 101 Secrets of a Microsoft Excel Addict
● Excel VBA Made Easy
● Doc2Txt
● Create Your Own Programming Language


  17 Responses to “Excel: Remove the Excel-Worksheet’s password”

  1. I’m sorry,
    I made the Excel file ( test.xlsx) and changed this rename this file to test.zip
    but I cannot unzip the file (test.zip)

    May I have the Detailed explanation or any hint?

  2. Workaround – dont unzip Just open zip container with 7zip or similar. Then, within the zip you may edit files and update zip container.

  3. I have tryied too. and have same error..

  4. Unfortunately, there’s no xml sheet when I unzip it. There’s a folder labeled “data spaces”, an encrypted package file, and an encryption info file. None of the files contain similar coding to your post which I can modify.

    • Hi Guys,

      for example: the filename is “test.zip”, you unziped that file, then you will find a folder name “test”. there is a file and 3 folders. modify it. then select all those content of test folder and right click of selection -> Add to archive –> archive format “zip”. then rename the zip file to .xlsx. thats it……….

      ps: Winrar required.
      Sorry for my English.

  5. Still its not working.

  6. I also tried renaming to zip & rar but I cannot open the file or un-compress it.

  7. dear sir
    i hv convert and extruct my file as you told but i am not geting any folder named “XL” here i am geting following 1 folder and 2 file.
    [6]DataSpaces
    EncryptionInfo
    EncryptedPackage
    and in first foldre i got the follwing
    DataSpaceInfo
    TransformInfo
    DataSpaceMap
    Version
    so what can i do ?

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>