Mark, it sounds like a network connection problem. Try selecting View,
Links, select the link that is not refreshing and do an update values.

If that doesn't work, try selecting the link and then doing a change source,
and just respecify the file.

If that solves, you may want to copy the network files to the same folder on
your PC and change your workbook to point at them. Obviously you would need
to copy the files each time....

Bob Flanagan
Macro Systems

http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Mark S" <Mark wrote in message
...
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?