ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can Sharing Workbook Corrupt Sheet Password? (https://www.excelbanter.com/excel-programming/439080-can-sharing-workbook-corrupt-sheet-password.html)

Dave[_83_]

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?


All times are GMT +1. The time now is 06:01 PM.

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