Home > IT Answers > Microsoft Windows > Excel 2003 – who has shared document open?
Moker
15 pts.
 Excel 2003 – who has shared document open?
Excel 2003, Microsoft Excel
If person #1 is editting a workbook and person #2 tries to open it, person #2 will be notified that the document is in use and asked if they want to open it 'read only'. Is there a way to identify 'who' has the document open?

Software/Hardware used:
ASKED: February 4, 2009  7:50 PM
UPDATED: February 5, 2009  5:16 PM
RELATED QUESTIONS
Answer Wiki:
I know of one way and there may be others... 1. Go to the machine that is sharing the document and right click the my computer Icon and go to manage. (or connect and manage the computer sharing the file from your machine.) 2. Click on shared Folders 3. Click on Open Files 4. Find the file in question and you should be able to see the user name of the person that has the file open You can close that connection to the file from here if needed. I have seen this many times and this always works. Good luck.
Last Wiki Answer Submitted:  February 4, 2009  9:15 pm  by  Colin Smith   845 pts.
All Answer Wiki Contributors:  Colin Smith   845 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for the suggestion. I tried this and it didn’t work for me. I didn’t see any files when I clicked on open files. Do you have any other suggestions? I noticed that the ‘notify’ message is different depending on who has the document open. When my co-worker has the document open, it does not specify her name. When my boss has the document open, the notify message includes his name indicating he has the document open. Is that because he is the ‘owner’ of the document. Maybe this is some sort of excel option????

Moker
 15 pts.
 

I have not seen or heard of any Excel options for the way the message is displayed. Do they have the same version of Excel? When you are in the manage mmc if you click on shared folders and click on shares do you see the share that the file is sitting on? If so then you should be able to click on sessions and see all connection that are made to any share on that machine. If you see connections then when you click on the open files you should see a list of files that are being accessed by the users that you saw in the sessions folder. If someone has the file open then you should be able to see it in that view. I hope that helps. just make sure that you are Managing the machine that has actual file that is being shared out on it. This should work. Good Luck.

Colin Smith
 0 pts.
 
  1. Set the user name to identify your work in the shared workbook: on the Tools menu, click Options, click the General tab, and then type your user name in the User name box.
wenjue
 10 pts.