I have a workbook that links information from about 6 other workbooks. The
other workbooks are in a read-only area from another department. The linked
information is simple text only cells.

Everything has worked fine for years, except on rare occassions. Once in
awhile the links to one of the workbooks won't work unless I open the source
workbook. This normally happens to me Sunday night and it disappears
sometime Monday. This time it happened over the weekend but now it's
Wednesday and I still have the problem.

Since this normally only happens on the weekend, I have always suspected
that it was due to a user leaving a workbook in some unknown state. I would
guess that they started a save but didn't finish it and left for the weekend.

I don't have acces to the individuals in the other deptartment so I can't
verify it that way. I could probably build a test on my own, but I was
wondering if anybody has seen this problem before. I assume different states
exist for an Excel workbook, is there a simple way to check?