hyperlink

  • hi all,


    I have a workbook with a hyperlink to another workbook.
    Some cells from workbook2 are linked into workbook1 (eg =[Book2]Sheet1!$A$3). But sometimes when I open workbook2 with the hyperlink in workbook1 excel doesn't recognize workbook2. When this happens I can open workbook2 by using edit links -> open source and then everything is working fine. What can I do about the unpredictable behaviour of excel?


    I'm working with excel 2000
    OS windows 2000 pro


    Thanks in advance,
    Fluppe