Hi,

As I can not see your code, I am taking my best guesses here.

You may get this error because

1. If netowrk drive is not available
2. if network drive is mapped using a different letter
3. Name of the worksheet is changed

More details can be found at
http://support.microsoft.com/kb/327006

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"DP7" wrote:

I have a macro that does 4 Vlookups automatically. Everything is stored on
the network. My problem is that from time to time the links in this worksheet
will tell me "error source not found." However i know that the spreadsheet it
is linking to have not been chanced and not been moved. The MACROS are stored
in the personal workbook. If anyone can help me with this problem i would be
very happy as it seems very "Twilight zone" like