Hyperlink formula works, and then doesn't work
 

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

Hyperlink formula works, and then doesn't work
 

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

Hyperlink formula works, and then doesn't work
 

any help? PLEASE....

"silent_tiger" wrote:

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