| Author |
Unlocking a protected excel spreadsheet
|
|
| Spides 2004-03-24, 11:38 am |
| I know there is a way but I can't remember how to unlock an excel spreadsheet that is password protected. Someone has locked a spreadsheet and left the company.... | |
| yanqui 2004-03-24, 12:12 pm |
| have you tried saving it as another file? Doesn't always work, but it does sometimes. Also, is it completely protected, as in you can't even open it without the password, or is it a "depends on password" protection type of sharing, or is a sheet protected, or is a range of cells protected?
There are ways around all of those. | |
| curiousgeorge 2004-03-24, 12:21 pm |
| I tested it out on my machine.
If a sheet is password protected, you can still copy and paste it onto another file.
Hope that helps. | |
| Spides 2004-03-24, 12:49 pm |
| Nope can't copy and paste onto another file, ctrl a etc doesn't work or edit select all. Also saved it under a different name but it keeps the security attributes......any other thoughts.....
The file opens but you can't edit anything......... | |
| Dr. C 2004-03-24, 12:55 pm |
| quote:
Originally posted by Spides
Nope can't copy and paste onto another file, ctrl a etc doesn't work or edit select all. Also saved it under a different name but it keeps the security attributes......any other thoughts.....
The file opens but you can't edit anything.........
Try importing it into Access, then exporting as a text file. | |
|
|
|
|
| Teck Shark 2004-03-24, 1:32 pm |
| This software does it all! You can recover your Excel password, and any other Office product for that matter!
http://www.elcomsoft.com/aoxppr.html
Personally I prefer hacking it myself or free tools, but when your employer provides you with the neccesary tools then I'm all for that. Even working on your own, this software pays for itself! As does anything from Ontrack (File Recovery or Office Recovery)! Simply outstanding tools! | |
| Spides 2004-03-25, 5:09 am |
| Tech Shark that looks great, but I went to try it and it is asking for payment already so no joy on that......yanqui that link to straxx is superb, it worked so well I gave the guy a $10 donation even though it was freeware.....worked like a dream, the guy editing the file os over the moon, he was told it would take three days to recover by the tech bods!!! Thanks again... | |
| yanqui 2004-03-25, 6:22 am |
| wow! I knew one!
Go me!
glad to help--and glad to know it worked, I'm sure I'll need it myself sometimes.
Is it astonishing how many people think they "know a lot about computeres?" I hear it all the time--"My friend knows a lot about computers." I'm still a rookie, and with what little I know I can tell them their friend don't know squat! So they "protect" things and "improve" things and "fix" things until they've woven a spiderweb around, over, within, and through their system that you have to cut through with a machete.
Was he trying to make life difficult on his departure or do you think he just forgot that someone would need that password? | |
| Spides 2004-03-25, 6:30 am |
| A bit if both with regards to the password I think, sour grapes I guess......Anyway Yanqui don't put yourself down with regards to knowledge, as I said he was told it would take three days to recover this file os he could edit it, I usually ask on here if I can't find a solution, and I couldn't find a free one, but you did.......well done and thanks again | |
| enforcer 2004-03-25, 7:23 am |
| bit late I know but here's the tool I use Ultimate Zip Cracker
NB I just use the trial version and it seems to work well for all those !Excel Quiz! sheets that do the rounds | |
| MistyRing 2004-03-25, 7:48 am |
| quote:
Originally posted by Spides
......yanqui that link to straxx is superb, it worked so well I gave the guy a $10 donation
wow i didn't think people really did that... | |
| enforcer 2004-03-25, 8:12 am |
| quote:
Originally posted by MistyRing
wow i didn't think people really did that...
Think I'll change my sig to
------------------------------------------
If you found the above post either helpful, informative or amusing, you may make a donation to my Paypal account. http://www.freenetpages.co.uk/hp/enforcer/images/paypal.gif | |
| yanqui 2004-03-25, 9:48 am |
| and your net worth next year will be the same as today.
 | |
| enforcer 2004-03-25, 10:46 am |
| quote:
Originally posted by yanqui
and your net worth next year will be the same as today.
Although you have tried to imply that I will receive no donations, in fact it does not, because any payments would just go towards any extra expenses incurred due to having the extra income.
NB forgot to include confused to the list. | |
|
|
|
|
| yanqui 2004-03-25, 11:09 am |
| The things they don't teach in school! | |
| enforcer 2004-03-25, 11:47 am |
| quote:
Originally posted by yanqui
The things they don't teach in school!
Oh but they do, if you pay attention.
PMS also stands for Property Management Systems.
Which is what the company I work for developes. | |
| azimuth40 2004-03-25, 11:48 am |
| also a research note taking software package. | |
| yanqui 2004-03-25, 12:10 pm |
| quote:
Originally posted by enforcer
Oh but they do, if you pay attention.
Pay Attention--
Oh THAT's the key!
It certainly explains a lot, doesn't it? | |
| enforcer 2004-03-25, 12:20 pm |
| quote:
Originally posted by yanqui
It certainly explains a lot, doesn't it?
what does? | |
| yanqui 2004-03-25, 12:22 pm |
| Pay Attention--
Oh THAT's the key!
(and in typical male fadshion you're not) | |
| enforcer 2004-03-25, 1:11 pm |
| quote:
Originally posted by yanqui
fadshion
Now there is a nice mix of similar words to make a new one. | |
| yanqui 2004-03-25, 1:18 pm |
| quote:
Originally posted by enforcer
Now there is a nice mix of similar words to make a new one.
Good grief, did I write that? I'm suffering from several disorders these days, everything's blooming down here and between a new keyboard and allergies and lack of sleep from the allergy medicine and frustration at my job I'm just not displaying my best stuff. Makes for an interesting day.
And I know I have to be very careful what I write anyway becuase you guys are AWFUL! | |
|
|
| yanqui 2004-03-25, 1:41 pm |
| Yeah, that pretty much uncovers it. | |
| bmilligan 2004-03-29, 1:21 pm |
| if you want, email (attachment) the sheet to me and i will unlock it for you and send it back. It'll cost you a beer sometime.
brian
security@upsilonomega.com | |
| akulkarn 2004-03-29, 9:29 pm |
| Hi there,
To unlock an excel sheet got to : - >Tools Menu :- > Protection :- > Unprotect Sheet put in the password and its all done.
I hope you r talking about a sheet here and not workbook.
Regards,
Anuj |
|
|
|
)