Excel 2003 – who has shared document open?

15 pts.
Tags:
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?
ASKED: February 4, 2009  7:50 PM
UPDATED: February 5, 2009  5:16 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Moker
    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????
    15 pointsBadges:
    report
  • Moker
    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.
    0 pointsBadges:
    report
  • wenjue
    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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following