Excel 2003 - Linked files

[numms]

I'm having an issue with two files in Excel which are each linked to many other documents. The first document (ManagerStats), has a listing of all the Supervisors under that Manager. I've created a link using the Supervisor's name to create a shortcut to the SupervisorStats file. The hyperlink works fine, finds the file and opens it perfectely.

The problem comes into play when the SupervisorStats file is updated with information from the linked documents ONLY WHEN THE MANAGERSTATS FILE IS OPEN. NOTE: Some of the files that the Manager and Supervisor stat cards are linked to are the same document. I'm inclined to think that this may be the root of the problem.

The SupervisorStats file works fine on it's own when the ManagerStats file is not open, but if the Manager file is open, the Supervisor file will lock.

A few points from my testing of this...

1. Neither of these files are linked to each other. There is no data passed back or forth between these two files, all data is populated from other reports.

2. If I open the SupervisorStats, then the ManagerStats, they both update fine.

3. If I open the SupervisorStats, then the ManagerStats, then a different SupervisorStats, all three update fine.

4. The only combination which causes an error is when the ManagerStats is open, then a SupervisorStats is opened.

Any thoughts on what could be causing this? I know this is a rather complex issue, and from everything I've seen defies all logic. I'll be more than happy to answer any questions which could help me reach some type of resolution on this issue.

Thanks again,