ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unlocking a Shared Workbook (https://www.excelbanter.com/excel-worksheet-functions/147870-unlocking-shared-workbook.html)

TOMB

Unlocking a Shared Workbook
 
First, I now know not to use shared workbooks....

I have a shared workbook which is reporting as locked. I am the only
reported user. Is there a way to unlock the file?

NOTES:
File was created as a shared workbook. 164k size
It currently does not appear to be shared.
The file does have macros.

Each time the file is opened, it reports that it is locked and save changes
do a 'save as'. The newly created file is locked also.

If I, as the only reported user under 'Share Workbook', try to change it to
shared again, the file size explodes to well over 100 meg before I stop.

Thanks
- - TB - -



All times are GMT +1. The time now is 05:14 PM.

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