this HYPERLINK code, working sometimes working, sometimes not (?)

[Grizlore]

Hello All,

I am baffled :|

The formula does what it should... soemtimes.

The formula below finds the first time a code if mentioned, and creates a hyperlink to a file with the same name, and a .pdf file extension.

=IF(C2<>"",(IF(COUNTIF($C$2:C2,C2)=1,HYPERLINK("\\drive1\share\CofPs\"& C2&".pdf","First"),"Repeat")),"")

Can anyone tell me why this formula doesn't work 100% of the time.

The exact same formula will work in one file, and not in another...

Is this something outside of Excel?

 

[Ron99]

Hi,

Please mention the drive in the formula, it might work!!

if the file is in C drive or D drive, rather than just mentioning the drive

=IF(C2<>"",(IF(COUNTIF($C$2:C2,C2)=1,HYPERLINK("c:\drive1\share\CofPs\"& C2&".pdf","First"),"Repeat")),"")

 

[Grizlore]

Ron99, This is a network drive on a server, so C's and D's aren't used

The address is correct, and it isnt a User issue, as I have the same problem... on one spreadsheet it works, on another it doesnt.

Even on the same spreadsheet... it will work sometimes, and othertimes not.


I am think it might not be the formula ?