ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? (https://www.excelbanter.com/excel-discussion-misc-queries/113955-excel-office-2007-b2tr-password-protecting-sheet-character-limit.html)

Office2007B2TR_Tester_91311

Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ?
 
I have used really long passwords in Excel (Office 2007 BETA).
My passwords are longer than 32 characters but not more than 64
characters.

Two issues with B2TR seem to have occurred:
1.) password length now limited?
2.) cannot paste password into 'Confirm Password' dialog?

Here's how I have been protecting Sheets (not Workbook):

With the sheet I wish to protect in front and visible,

I select 'Review'

Then I select 'Protect Sheet'

'Protect Sheet' dialog appears.

I can paste my really long password.

Click [OK].

'Confirm Password' dialog appears.

I cannot paste the long password.

Even still, if I begin to type the password, it will not let me type
beyond 15 characters.

Tell me where I am going wring here.

Can someone refer me to on-line documentation about this.

Jim Rech

Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ?
 
I reproduced the problem. It does not occur when you save in the new file
format, btw, (xlsx, etc.). I'm a beta tester so I'll ask if this has been
fixed in newer builds. I'll let you know if I get an answer.

--
Jim
"Office2007B2TR_Tester_91311"
wrote in message ...
|I have used really long passwords in Excel (Office 2007 BETA).
| My passwords are longer than 32 characters but not more than 64
| characters.
|
| Two issues with B2TR seem to have occurred:
| 1.) password length now limited?
| 2.) cannot paste password into 'Confirm Password' dialog?
|
| Here's how I have been protecting Sheets (not Workbook):
|
| With the sheet I wish to protect in front and visible,
|
| I select 'Review'
|
| Then I select 'Protect Sheet'
|
| 'Protect Sheet' dialog appears.
|
| I can paste my really long password.
|
| Click [OK].
|
| 'Confirm Password' dialog appears.
|
| I cannot paste the long password.
|
| Even still, if I begin to type the password, it will not let me type
| beyond 15 characters.
|
| Tell me where I am going wring here.
|
| Can someone refer me to on-line documentation about this.



Jim Rech

Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ?
 
Got a reply. This is not going to be fixed.

--
Jim
"Jim Rech" wrote in message
...
|I reproduced the problem. It does not occur when you save in the new file
| format, btw, (xlsx, etc.). I'm a beta tester so I'll ask if this has been
| fixed in newer builds. I'll let you know if I get an answer.
|
| --
| Jim
| "Office2007B2TR_Tester_91311"
| wrote in message ...
||I have used really long passwords in Excel (Office 2007 BETA).
|| My passwords are longer than 32 characters but not more than 64
|| characters.
||
|| Two issues with B2TR seem to have occurred:
|| 1.) password length now limited?
|| 2.) cannot paste password into 'Confirm Password' dialog?
||
|| Here's how I have been protecting Sheets (not Workbook):
||
|| With the sheet I wish to protect in front and visible,
||
|| I select 'Review'
||
|| Then I select 'Protect Sheet'
||
|| 'Protect Sheet' dialog appears.
||
|| I can paste my really long password.
||
|| Click [OK].
||
|| 'Confirm Password' dialog appears.
||
|| I cannot paste the long password.
||
|| Even still, if I begin to type the password, it will not let me type
|| beyond 15 characters.
||
|| Tell me where I am going wring here.
||
|| Can someone refer me to on-line documentation about this.
|
|




All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com