On Nov 19, 4:56*am, Dave Peterson wrote:
I think you'll need to add the upfront info to the =hyperlink() formula..

I would use a helper cell to hold the drive and path. *Then when/if it changes,
I could just update one cell to fix the hyperlinks.

Put:
file:////h:\wip\...that longpath that ends with a backslash\
in A1

Then you can use:

=hyperlink($a$1&a2,a2)
where a2 contains the "LotDetail.htm_lot_id(eq)3BB6N.htm" string

(But even that looks like a funny filename to me.)


Dave:

This was actually one of my earlier test cases. I tried it again, but
failed with the debug error when it has displaytext field non-null,
and isn't recognized as a hyperlink.

At this point, the conclusion is that the =HYPERLINK() formula will
work, but you have to leave the displaytext argument null. Very
annoying. No idea why this should be the case.

Thanks for your help.

-- Roy Zider