Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
I have a workbook (1 spreadsheet) that is password protected. When I try to
open the workbook, I am promted for a password. I enter it and the workbook opens without any problems. The problem starts when I try to change the password. I tried to change the password by going to Tools, Protection, Protect Workbook. At this point I am promted for a password. When I try to enter the same password that I used to open the workbook, it does not recognize it. -- Val |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
Hi,
You need to goto, Tools, Options, Security. You should find the password there that allows you to open the workbook! "Val" wrote: I have a workbook (1 spreadsheet) that is password protected. When I try to open the workbook, I am promted for a password. I enter it and the workbook opens without any problems. The problem starts when I try to change the password. I tried to change the password by going to Tools, Protection, Protect Workbook. At this point I am promted for a password. When I try to enter the same password that I used to open the workbook, it does not recognize it. -- Val |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
I can open the workbook with the password that I know. When I go to Tools,
Options, Security, I see encrypted password but I can not copy it. What I am not able to do is to change the password. -- Val "fluffymoore" wrote: Hi, You need to goto, Tools, Options, Security. You should find the password there that allows you to open the workbook! "Val" wrote: I have a workbook (1 spreadsheet) that is password protected. When I try to open the workbook, I am promted for a password. I enter it and the workbook opens without any problems. The problem starts when I try to change the password. I tried to change the password by going to Tools, Protection, Protect Workbook. At this point I am promted for a password. When I try to enter the same password that I used to open the workbook, it does not recognize it. -- Val |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
To Change the password in the security box:
Highlight the encryption and overtype with the password you want it to be and hit enter; It will then prompt you to retype your password. TADA!! "Val" wrote: I can open the workbook with the password that I know. When I go to Tools, Options, Security, I see encrypted password but I can not copy it. What I am not able to do is to change the password. -- Val "fluffymoore" wrote: Hi, You need to goto, Tools, Options, Security. You should find the password there that allows you to open the workbook! "Val" wrote: I have a workbook (1 spreadsheet) that is password protected. When I try to open the workbook, I am promted for a password. I enter it and the workbook opens without any problems. The problem starts when I try to change the password. I tried to change the password by going to Tools, Protection, Protect Workbook. At this point I am promted for a password. When I try to enter the same password that I used to open the workbook, it does not recognize it. -- Val |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
Ok. What about the way I was trying to do it? What is that functionality for?
-- Val "fluffymoore" wrote: To Change the password in the security box: Highlight the encryption and overtype with the password you want it to be and hit enter; It will then prompt you to retype your password. TADA!! "Val" wrote: I can open the workbook with the password that I know. When I go to Tools, Options, Security, I see encrypted password but I can not copy it. What I am not able to do is to change the password. -- Val "fluffymoore" wrote: Hi, You need to goto, Tools, Options, Security. You should find the password there that allows you to open the workbook! "Val" wrote: I have a workbook (1 spreadsheet) that is password protected. When I try to open the workbook, I am promted for a password. I enter it and the workbook opens without any problems. The problem starts when I try to change the password. I tried to change the password by going to Tools, Protection, Protect Workbook. At this point I am promted for a password. When I try to enter the same password that I used to open the workbook, it does not recognize it. -- Val |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
Val
There are several types of protection. 1. Password to open the file. Can be set at FileSave AsToolsGeneral Options. 2. Password on a protected worksheet. This is set at ToolsProtectionProtect Sheet. Many functions can be disabled using this type of protection. 3. Workbook Protection password. This is set at ToolsProtectionProtect Workbook. This protects the workbook from having sheets deleted and other functions disabled. 4. VBA Project password to prevent viewers from looking at code modules. NOTE: except for File to Open protection and VBA project passwords, most forms of Excel protection are very weak and passwords can be easily cracked. Gord Dibben MS Excel MVP On Sat, 11 Nov 2006 09:02:01 -0800, Val wrote: Ok. What about the way I was trying to do it? What is that functionality for? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing password in Excel workbook
That way is to protect the sheet (tab)!!
"Val" wrote: Ok. What about the way I was trying to do it? What is that functionality for? -- Val "fluffymoore" wrote: To Change the password in the security box: Highlight the encryption and overtype with the password you want it to be and hit enter; It will then prompt you to retype your password. TADA!! "Val" wrote: I can open the workbook with the password that I know. When I go to Tools, Options, Security, I see encrypted password but I can not copy it. What I am not able to do is to change the password. -- Val "fluffymoore" wrote: Hi, You need to goto, Tools, Options, Security. You should find the password there that allows you to open the workbook! "Val" wrote: I have a workbook (1 spreadsheet) that is password protected. When I try to open the workbook, I am promted for a password. I enter it and the workbook opens without any problems. The problem starts when I try to change the password. I tried to change the password by going to Tools, Protection, Protect Workbook. At this point I am promted for a password. When I try to enter the same password that I used to open the workbook, it does not recognize it. -- Val |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Protected EXCEL worksheets to update linked data | New Users to Excel | |||
my password quit working in an excel workbook, help! | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
I forgot my password for an excel workbook | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel |