Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default 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.
|
|


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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Office Excel 2007 for SQL Server Analysis Services eysiperez Excel Discussion (Misc queries) 1 November 27th 06 04:50 PM
Sum up columns in different sheet with error check zeyneddine Excel Discussion (Misc queries) 13 July 10th 06 01:21 PM
Standard Balance Sheet format in Microsoft Office Excel 2003(2) heberling Excel Worksheet Functions 4 July 27th 05 06:58 PM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM


All times are GMT +1. The time now is 07:51 PM.

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

About Us

"It's about Microsoft Excel"