Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF formula works in Excel 2003, does not work in Excel 2007 | Excel Discussion (Misc queries) | |||
Insert Hyperlink shortcut no longer works | Links and Linking in Excel | |||
Insert Hyperlink shortcut no longer works | Links and Linking in Excel | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
how do I create a hyperlink that works more than one time | Excel Discussion (Misc queries) |