• 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,

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!