Shared Workbook
I went into a workbook that I had (Protect and share workbook) protected to
do some modifications, when I selected unprotect workbook it didnt ask for my password and seemed to unlock the book for editing. But this was not the case; it stayed as a shared protected document. Why does this happen and how do I fix it? I also had each sheet protected and the whole workbook protected before sharing the file, I have no access to undo this either. |
Shared Workbook
Found that someone still had the file opened by selecting (Share Workbook)
under the Tools dropdown. "Gila" wrote: I went into a workbook that I had (Protect and share workbook) protected to do some modifications, when I selected unprotect workbook it didnt ask for my password and seemed to unlock the book for editing. But this was not the case; it stayed as a shared protected document. Why does this happen and how do I fix it? I also had each sheet protected and the whole workbook protected before sharing the file, I have no access to undo this either. |
Shared Workbook
Apparently i spoke to soon... this is driving me crazy...
i had a working copy that had no protection, so i selected the (Protect and Share) option under toolsprotection. Then selected unshare and its still showing shared. Know i have no access to the copy either : ( "Gila" wrote: Found that someone still had the file opened by selecting (Share Workbook) under the Tools dropdown. "Gila" wrote: I went into a workbook that I had (Protect and share workbook) protected to do some modifications, when I selected unprotect workbook it didnt ask for my password and seemed to unlock the book for editing. But this was not the case; it stayed as a shared protected document. Why does this happen and how do I fix it? I also had each sheet protected and the whole workbook protected before sharing the file, I have no access to undo this either. |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com