ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locked Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/156980-locked-worksheet.html)

EC

Locked Worksheet
 
I need to get into a worksheet at work and save data into this workseet so I
can up;oad it into my data base. however, someone has it locked and they
have gone home for the day and are not reachable. How do I "kick" this
person out of the worksheet.? I cannot sanr it as a different name b/c I
need the file to be named the same name it is currently.

Thank you for all help!
ec

Tevuna

Locked Worksheet
 
Conficting file names are names that are share
1. Name
2. Path
3. File type (Same as name, because extension is different)

So, If you can't settle on 1, settle on 2 or 3
Change directory or file type (.xls to .xlsx, or to .csv)


"EC" wrote:

I need to get into a worksheet at work and save data into this workseet so I
can up;oad it into my data base. however, someone has it locked and they
have gone home for the day and are not reachable. How do I "kick" this
person out of the worksheet.? I cannot sanr it as a different name b/c I
need the file to be named the same name it is currently.

Thank you for all help!
ec



All times are GMT +1. The time now is 04:47 PM.

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