Just to clarify, for the true result("NO") I do not want it hyperlinked and
actually want the €œcannot open€� popup to come up and for the false result in
this case displaying a €œYES€� I do want hyperlinked. Also please before
telling me it works, save and close and then try the link, as it does work
until reopened.

Thanks in advance

"silent_tiger" wrote:

Hi

I have an interesting formula that works when I create it, but after I save
and close the file it doesn't work, I have tried the formula with the
Absolute and relative hyperlinks and still end up with the same problem.

=IF('V:\GrowingUp CATI files\[9MAppointment
09-07-27.xls]3'!$E$220,IF('V:\GrowingUp CATI files\[9MAppointment
09-07-27.xls]3'!$E$280,"NO",HYPERLINK("v:\GrowingUp CATI files\9MAppointment
09-07-27.xls#'3'!B2","YES")),HYPERLINK("v:\GrowingUp CATI files\9MAppointment
09-07-27.xls#'3'!B2","YES")).

I would appreciate if someone knows how to get this to work all the time,
even if the hyperlinked file is closed.

Thanks