Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel file but lock account
I open one excel file in office that if one person open it, then the other
people want to open this file will see a window to tell this guy choose "read only" and so on. So I want to ask how to cancell this lock account. Or can I retrieve this file from the previous time when I opened? Thanks any one to reply my question! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel file but lock account
I don't think that you CAN cancel this - the file is locked for "read-write"
by the other user. 1) If you don't want other users to be able to "read-write", password protect it. 2) If you would prefer that users who only want to "inspect" data don't lock the file then set option "read only recommended". 3) Make **** sure that everybody who potentially will use the file has their personal details recorded in their Excel settings. This is not such a problem these days, but we used to have terrible problems working out who had locked a shared file because the default username on our system was "administrator". You had NO idea who the real culprit was. "David" wrote: I open one excel file in office that if one person open it, then the other people want to open this file will see a window to tell this guy choose "read only" and so on. So I want to ask how to cancell this lock account. Or can I retrieve this file from the previous time when I opened? Thanks any one to reply my question! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
Excel fails to lock file across VPN? | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |