at work I use an excel spreadsheet to keep track of every job we've ever done. In that spreadsheet are links (one per job) to the file that contains all of the information for that job. This spreadsheet and all of the files are stored on our server. The file itself is not a "Shared Workbook" so only one person can edit it's contents at a time. I have been encountering two problems that are most likely related...

1. Three people normally use this spreadsheet. When any computer other than mine creates the links I cannot open them. When my computer creates them everyone can open them. We can't figure out why..

2. The links will all be working correctly. Sometimes for day, sometimes for weeks. Then randomly they won't work for any of us, and we can't figure out what caused the change.

If you guys and gals could help me figure this out I would really appreciate it!