Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Can Sharing Workbook Corrupt Sheet Password?

This is a different problem from my post on cell protection being
modified by sharing.

Anyone had experience with this? (Excel 2003, XP SP3)
At work, I protected cells, protected each sheet with a confirmed
password, saved the file then turned on workbook sharing and set the
options. When I wanted to make changes at a later date, I re-opened,
checked that there were no other users, closed the file then moved it
from the folder to work on it. I could not then unprotect the sheets
(got the dialog saying the supplied password was incorrect) and had to
use a password recovery tool to eliminate the password. I sent the
file home where there is no network so there could be no sharing
conflicts, reset the password on each worksheet, saved, shared (which
automatically saves) and again I could not unprotect the sheets. I
intended to document this step by step and post the issue here, and
wouldn't you know it, I cannot get it to fail now. Can sharing the
workbook corrupt the password I use on the worksheets?
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
Can Sharing Workbook Corrupt Sheet Password? Dave[_83_] Excel Programming 0 February 2nd 10 12:28 AM
Error: Sharing Workbook w/password protection Jeff Wollschlager Excel Discussion (Misc queries) 0 May 13th 09 04:29 PM
Can't change sheet color after sharing workbook? Mikael Lindqvist Excel Discussion (Misc queries) 0 November 20th 07 08:30 AM
Restored XLS password protected file, but now corrupt? [email protected] Excel Programming 0 March 8th 06 04:54 AM
password corrupt...help! (please) Miss Claus Excel Programming 1 November 28th 04 01:33 PM


All times are GMT +1. The time now is 03:08 PM.

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

About Us

"It's about Microsoft Excel"