[Technology] Excel - Removing a password from a protected sheet

[Paulie Gualtieri]

All,

In true NSC style, I’m here asking whether anyone knows of a simple way of removing the password protection from an Excel sheet that is protected

We’ve had someone leave and not hand over this info and cannot get hold of them now

From memory I’ve been able to do this after trawling various Excel online forums but just wondered on the off chance if anyone can confirm?

N.B I’ve tried turning it on and off again

Thanks

 

[Tom Hark Preston Park]

Don't know it this works or not, but maybe worth trying with a copy of the original file

 

[RandyWanger]

Is the sheet password locked so you can't access it without a password or is the data within the sheet locked?

You could brute force the first, and/or use a VBA script for the 2nd.

 

[GingerBeerMan]

I've tried before, I came to find it was A LOT more secure than you'd imagine. Best of luck.

 

[beorhthelm]

I've tried before, I came to find it was A LOT more secure than you'd imagine. Best of luck.

this, i'm afraid. iirc it can be done at some time/cost of expertise.

 

[Paulie Gualtieri]

Don't know it this works or not, but maybe worth trying with a copy of the original file

View attachment 188740

Thanks

Worked a treat!

Same principals here

Unprotect Excel Sheet Without Password (2 Easy Ways)

It's a common scenario to protect an Excel sheet with a password, only to find yourself in the frustrating situation of forgetting the password.

spreadsheetplanet.com

 

[Paulie Gualtieri]

Is the sheet password locked so you can't access it without a password or is the data within the sheet locked?

You could brute force the first, and/or use a VBA script for the 2nd.

Sheet was accessible but content protected - now resolved

Thanks

 

[Paulie Gualtieri]

I've tried before, I came to find it was A LOT more secure than you'd imagine. Best of luck.

Sorted - see above

 

[maffew]

In case you need to do workbooks too, straightforward