Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,209,491 members, 8,006,258 topics. Date: Monday, 18 November 2024 at 07:54 PM

Help: MS Excel - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Help: MS Excel (1191 Views)

Never Learnt Ms.excel Before And I Did This / Building An Hierarchical Comment System In Asp.net Mvc, Ms Sql Server, Css / How Can I Restore The Calculation Data In MS Access 2016? (2) (3) (4)

(1) (Reply) (Go Down)

Help: MS Excel by Nobody: 2:10pm On Feb 21, 2018
I forgot the password to my MS Excel file, can anyone help me retrieve this password or remove the password totally?
Re: Help: MS Excel by hupernikao: 12:06am On Feb 26, 2018
Farmercist:
I forgot the password to my MS Excel file, can anyone help me retrieve this password or remove the password totally?

Attach the file here, I can help you.
Re: Help: MS Excel by lanocfoods: 6:13pm On Mar 06, 2018
Farmercist:
I forgot the password to my MS Excel file, can anyone help me retrieve this password or remove the password totally?
Go to file and click on save as, save the file with a different name and try to open it(I mean the new one)
Re: Help: MS Excel by hupernikao: 9:46pm On Mar 06, 2018
lanocfoods:

Go to file and click on save as, save the file with a different name and try to open it(I mean the new one)

It won't remove the password. SheetProtect is a property of an Excel worksheet, thus it is retained irrespective of the file name change, location change or data manipulation.

Harder route is to save the file as .zip (I mean the file extension. xls or xlsx to zip) then open the zip (don't unzip) and follow the folders to locate the file sheet1.xml (assuming the sheet protected us sheet1). Then he should open it with a good code editor and search for the sheet protect line of code, then delete the long hash sequence in front. Afterwards click save to save changes then close zip and change extension back to xls. Open the file and the protection is gone.
Re: Help: MS Excel by hupernikao: 9:46pm On Mar 06, 2018
lanocfoods:

Go to file and click on save as, save the file with a different name and try to open it(I mean the new one)

It won't remove the password. SheetProtect is a property of an Excel worksheet, thus it is retained irrespective of the file name change, location change or data manipulation.

Harder route is to save the file as .zip (I mean the file extension. xls or xlsx to zip) then open the zip (don't unzip) and follow the folders to locate the file sheet1.xml (assuming the sheet protected is sheet1). Then he should open it with a good code editor and search for the sheet protect line of code, then delete the long hash sequence in front. Afterwards click save to save changes then close zip and change extension back to xls. Open the file and the protection is gone.

(1) (Reply)

Is It Too Late To Start Web Development At 30years Old / SOFTICU TECH HUB: Practical Training On How To Design Any Type Of Mobile App / Help Me Learn The Basics

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 18
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.