Skip to content
View in the app

A better way to browse. Learn more.

BenLotus

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Unlock/remove protected sheets in excel

Featured Replies

091113_0445_AdvancedExc2.png.2d4009f6f57a6a37d5314f705c444c26.pngaHR0cDovL3d3dy5sYXB0b3BtYWcuY29tL2ltYWdlcy93cC9wdXJjaC1hcGkvaW5jb250ZW50LzIwMTUvMTEvdG9wLWV4Y2Vs.png.750024fd3b61e2df506e515200069b87.png

You dont know or you Forgot the password of a protected sheet in Excel?? Worry no more, just follow this steps :) 

EASY STEP BY STEP ON HOW TO UNLOCK/REMOVE PROTECTION:

[hide]

1. make sure the "hide extension" in file folder options is uncheck.
2. change the file extension of the excel file you want to unlock to .zip
3. extract the "zip file" to a specific folder
4. go to xl>worksheet
5. open each XML Document files named as "sheet#" via notepad
6. delete code <protection> till </autofilter>
7. save (Ctrl+S)
8. select all files, right click, select send to>compressed zipped folder
9. change the file name back to ".xlsx"
10. Open unlocked file and ENJOY! 

[/hide]

1.JPG.d77320fd834deb243a864c8065edc581.JPG

CTTO

  • Author
15 hours ago, ZC-Eternity said:

Salamat po. Meron akong lumang file na excel. sana gumana

13 hours ago, Wined said:

Try ko to, thanks po...

Sige lang po :D Walang anuman po, magbigay lang po kayo ng feedback kung gumana po ba o hindi :) Salamat!

kailangan ko ito !! salamat..

pre yung step 4 medyo di ko masundan.

Edited by majorbaluga

  • 4 months later...
On 8/29/2018 at 11:00 PM, Makaduda said:

091113_0445_AdvancedExc2.png.2d4009f6f57a6a37d5314f705c444c26.pngaHR0cDovL3d3dy5sYXB0b3BtYWcuY29tL2ltYWdlcy93cC9wdXJjaC1hcGkvaW5jb250ZW50LzIwMTUvMTEvdG9wLWV4Y2Vs.png.750024fd3b61e2df506e515200069b87.png

You dont know or you Forgot the password of a protected sheet in Excel?? Worry no more, just follow this steps :) 

EASY STEP BY STEP ON HOW TO UNLOCK/REMOVE PROTECTION:

 

Hidden Content
You'll Be Able To See The Hidden Content Once You Reply To This Topic

 

1.JPG.d77320fd834deb243a864c8065edc581.JPG

CTTO

I'll try this one

sir/mam

problema ko sa excel pagmarami na formula ayaw na magbukas ng file.

sana matulungan nyo ako...

salamat in advance. :D

Edited by MIC0404

  • 8 months later...
  • 5 weeks later...
On 24/01/2019 at 4:39 AM, bieh04 said:

I'll try this one

Must try this to

  • 1 month later...
  • 4 months later...
  • 2 weeks later...

For future reference, thank you for this!

  • 2 months later...
  • 1 month later...

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.