Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Sharing Workbook Corrupt Sheet Password?
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: Sharing Workbook w/password protection | Excel Discussion (Misc queries) | |||
password to open a work sheet in a workbook | Excel Programming | |||
Can't change sheet color after sharing workbook? | Excel Discussion (Misc queries) | |||
Restored XLS password protected file, but now corrupt? | Excel Programming | |||
password corrupt...help! (please) | Excel Programming |