Aussie Community Helpdesk
May 25, 2012, 04:52:30 AM*

Welcome, Guest. Please login or register.

Login with username, password and session length
News: Welcome to Aussie Community Helpdesk!
Advanced search  
Pages: [1]   Go Down
  Print  
Author Topic: Help -EXCEL  (Read 1397 times)
witchy
Addicted Member
*
Offline Offline

Posts: 419



View Profile
« on: June 15, 2007, 06:41:32 PM »

Please help me,
I have accidentally password portected an Excel worksheet. Don't even remember doing it but I must have because when I try to change anything it tells me it is password protected.
I don't know what the password is!
Is there some way I can find out?
I really need to unlock the spreadsheet it has a huge amount of data in it.

Witchy
Logged
neonwizard
Management
Guru
*
Offline Offline

Posts: 5227


imfndunn


View Profile WWW
« Reply #1 on: June 15, 2007, 07:11:09 PM »

Witchy for us to tell you would be against the rules of the site because it involves cracking the password, but you can Google this for help and you should see the solution.

I would have to check with Andrew but I think I'm right.
« Last Edit: June 15, 2007, 07:17:25 PM by neonwizard » Logged

witchy
Addicted Member
*
Offline Offline

Posts: 419



View Profile
« Reply #2 on: June 15, 2007, 07:36:55 PM »

Sorry Neon,
I didn't think about that. Just thought there was some legal way of getting out of this pickle.

Witchy
Logged
neonwizard
Management
Guru
*
Offline Offline

Posts: 5227


imfndunn


View Profile WWW
« Reply #3 on: June 15, 2007, 07:38:44 PM »

Sorry witchy it sucks, it happen to me a long time ago with a word document so I know how you feel.
Logged

Jutta
Guru
*
Offline Offline

Posts: 2109



View Profile
« Reply #4 on: June 15, 2007, 07:44:17 PM »

Witchy,
 
this information is  from the "Ms.Excel 2003 Help Menu", surely Neon that is not against the Rules of the Forum to post?Huh???

 Change or remove a workbook password   

Change the password for viewing or editing a workbook file

Open the workbook.
On the File menu, click Save As.
On the Tools menu, click General Options.
In the Password to open or Password to modify box, double-click the asterisks.
Type the new password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
Important  Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

When prompted, retype the new password, and then click OK.
Click Save.
If prompted, click Yes to replace the existing workbook.
Note  If you have protected a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) with a password, you can't change the password without unsharing the workbook, which deletes the change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.).

Remove the password for viewing or editing a workbook fileOpen the workbook.
On the File menu, click Save As.
On the Tools menu, click General Options.
In the Password to open or Password to modify box (or in both boxes), double-click the asterisks and then press the DELETE key.
Click OK, and then click Save.
Click Yes to replace the existing workbook.
 
« Last Edit: June 15, 2007, 07:48:48 PM by Jutta » Logged

Everyone Smiles in the same Language!
neonwizard
Management
Guru
*
Offline Offline

Posts: 5227


imfndunn


View Profile WWW
« Reply #5 on: June 15, 2007, 07:56:43 PM »

How can the file be opened without the password? If you can open the file seem to defeat the purpose of a password.
« Last Edit: June 15, 2007, 08:00:20 PM by neonwizard » Logged

Jutta
Guru
*
Offline Offline

Posts: 2109



View Profile
« Reply #6 on: June 15, 2007, 08:13:41 PM »

Neon, I found something else in the Excel Help Menu, which sort of contradicts the Solution to undo a Password above Huh?

Witchy, hopefully your Worksheet is not Password protected, but merely "Hidden"

Password protection of worksheet and workbook elements

When you protect a worksheet or workbook to lock its elements, adding a password is optional. In this context, the password is merely intended to allow access to certain users while helping to prevent changes by other users. This level of password protection does not ensure that all sensitive data in your workbook is secure. For optimal security, you should use a password to help safeguard the workbook file itself from unauthorized access.
Note  It is very important that you remember the password that you set. Without the password, there is no way to unprotect the workbook or worksheet.
« Last Edit: June 15, 2007, 08:19:48 PM by Jutta » Logged

Everyone Smiles in the same Language!
neonwizard
Management
Guru
*
Offline Offline

Posts: 5227


imfndunn


View Profile WWW
« Reply #7 on: June 15, 2007, 08:21:59 PM »

aha two forms of protection lock down changes or full file protect.......tricky
Logged

Jutta
Guru
*
Offline Offline

Posts: 2109



View Profile
« Reply #8 on: June 15, 2007, 08:27:17 PM »

Hopefully Witchy will let us know if the Excel Help Menu Suggestion, how to undo Password protection
worked .......................or not!
If the file is just hidden, no problem to unhide!
Logged

Everyone Smiles in the same Language!
neonwizard
Management
Guru
*
Offline Offline

Posts: 5227


imfndunn


View Profile WWW
« Reply #9 on: June 15, 2007, 08:30:51 PM »

I have sent her a solution if it's that in a PM Wink
Logged

witchy
Addicted Member
*
Offline Offline

Posts: 419



View Profile
« Reply #10 on: June 16, 2007, 01:51:03 PM »

I fixed it!
Thanks Jutta, but I had tried that but it didn't work. No password asterisks.
What did work was I copy,pasted the worksheet created another name, and bingo! The new file opened and allowed editing.
I have absolutly no idea why this worked but as I don't know what I did in the first place it will probably remain a mystery.
Previous attempts at saving the file under another name using save as- only resulted in the protection going with it.
I guess I have discovered another quirk in MS.
I am just so pleased everything is working again and now I will practice double back up.
Witchy Bow Bow
Logged
Jutta
Guru
*
Offline Offline

Posts: 2109



View Profile
« Reply #11 on: June 16, 2007, 04:07:56 PM »

Thank you for letting us know Witchy, very glad you did find a Fix , but how strange that there was no Asterix to click on as stated in the 2003 Helpmenu?

Oh well, the main thing is you have achieved your Goal!
Logged

Everyone Smiles in the same Language!
Pages: [1]   Go Up
  Print  
 
Jump to:  

B l a c k - R a i n V.2 by C r i p ~ Powered by SMF 1.1.16 | SMF © 2006-2007, Simple Machines XHTML | CSS   

Page created in 0.062 seconds with 18 queries.