Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Password Protection Bug

I am using MS Office (Pro) Excel 2003 (11.8237.8221) SP3
I create a new workbook.
I password protect the first sheet using the password "az" without the
quotation marks.
The sheet is now protected.
I unprotect the sheet and, when prompted for the password, input "Aj"
without the quotation marks.
The sheet is now unprotected.
Why does this other password work for unlocking the worksheet?
(There are other examples. For instance, "test" can be unlocked using "BBAb")

Why the heck does this work?


--
Lorem ipsum dolor sit amet
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Password Protection Bug

Hi,

This is a know limitation of the password handling routine in Excel. The
good news?, its consistant between version, the same problem occurs in 2007.
Aparently Microsoft doesn't consider sheet passwords a critical issue.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"spikefuzzy1" wrote:

I am using MS Office (Pro) Excel 2003 (11.8237.8221) SP3
I create a new workbook.
I password protect the first sheet using the password "az" without the
quotation marks.
The sheet is now protected.
I unprotect the sheet and, when prompted for the password, input "Aj"
without the quotation marks.
The sheet is now unprotected.
Why does this other password work for unlocking the worksheet?
(There are other examples. For instance, "test" can be unlocked using "BBAb")

Why the heck does this work?


--
Lorem ipsum dolor sit amet

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Password Protection Bug

Simply because the hash results are same for each pair.

spikefuzzy1 wrote:
I am using MS Office (Pro) Excel 2003 (11.8237.8221) SP3
I create a new workbook.
I password protect the first sheet using the password "az" without the
quotation marks.
The sheet is now protected.
I unprotect the sheet and, when prompted for the password, input "Aj"
without the quotation marks.
The sheet is now unprotected.
Why does this other password work for unlocking the worksheet?
(There are other examples. For instance, "test" can be unlocked using "BBAb")

Why the heck does this work?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
password protection Poonam Excel Discussion (Misc queries) 2 September 22nd 07 04:44 PM
Password protection Tia Excel Discussion (Misc queries) 2 May 1st 06 08:37 PM
Password protection Noemi Excel Discussion (Misc queries) 2 January 24th 06 06:18 AM
Password Protection sitay1 Excel Discussion (Misc queries) 1 August 26th 05 03:15 AM
Password Protection JamesD Excel Discussion (Misc queries) 1 April 7th 05 02:36 PM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"