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