No errors in Hyperlink formula but nothing happens

[peter_reed]

Hello

Can anyone see why this hyperlink formula won't work - it doesn't show any errors, it shows the correct friendly name result from the other workbook, but when clicked literally nothing happens... no error messages, nothing... anyone have any ideas?

This is the formula
=HYPERLINK("\\LS420D465\Share\Templates\PURCHASEORDERTEMEPLATE\PURCHASEORDERTEMPLATE37.xlsm",'\\LS420D465\Share\Templates\PURCHASE ORDER TEMEPLATE\PURCHASE ORDER TEMPLATE37.xlsm'!Client_Name)

Look forward to hearing from you.
Peter

 

[igold]

Hi,

To be honest, I have never inserted a hyperlink into a cell without using the Hyperlink Wizard that is a choice when you right-click a cell. That being said I just now tried to create a Hyperlink in a cell using the HYPERLINK function as I assumed you did.

My results to reach a file named "DisplayNodes.xlsm" with the path of G:\Files\Excel VBA\DisplayNodes.xlsm yielded this formula which works correctly for me:

=HYPERLINK("file:///G:\Files\Excel VBA\DisplayNodes.xlsm","DisplayNodes")

I hope this helps

 

[abssorb]

PURCHASEORDERTEMEPLATE

Could it be as simple as a typo?

 

[igold]

@abssorb

That was a good catch, I tested it with the formula I had provided and even with a typo the hyperlink generated an error that the file could not be found.