When I am on my home network, I have an Excel spreadsheet that lists all the music I have added to our network library. This document is accessible by all members and needs to remain that way as we all access it multiple times a week. Unfortunately, two users can access the document and make changes. Of course who ever finishes first will end up losing their changed data as when the second saves the file, it overwrites the existing. I have no other option but to keep this file accessible to all users and not split it up.
Is there a a program or any way to configure the file to inform me that someone is currently viewing the document and making changes? I need a way for others to know that it is being accessed and edited by a particular person. Any ideas?