Sign in with
Sign up | Sign in
Your question

How to tell who is locking a file

Last response: in Windows 2000/NT
November 18, 2011 4:12:36 PM

I have an Excel file on a shared network drive. When it is being edited by someone it shows "locked for editing by company name" . How do i make this message show the actual user who is locking the file?

More about : locking file

November 18, 2011 6:18:19 PM

You can't, but your network administrator might be able to tell you.
November 18, 2011 8:02:34 PM

I may be wrong, but I think the user name being reported is that set up in Excel (ie. the name entered when Excel was first set up). It looks like all your copies of Excel are set up with the Company name rather than the individual user names. If you want a meaningful message you are going to have to personalize your copies of Excel.

Of course, as PhilFrisbie says, the network administrator can look at the open files on the server to see which user has them open, but I'm guessing you want the users to be able to see who has the file open when they get this message.