Try this formula:

=HYPERLINK("\\Pwreports\PWREPORTS\2010\"&BH6&"\"&A U6&"_NIBRS Incident
Report.pdf","Open PDF")

Hope this helps.

Pete

On Apr 9, 1:53*am, Shawn wrote:
I have this

\\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf

I can make the hyper link work once, ( flashes real fast and disappears)

I need change two things *the 197 and 2001000005
The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is
the case number and is located in cell au6 *but when i change it to the
cells in which the info is it doesn't work no more *

The link refers to a drive in which the ofc's report is located , its
under year\ofc badge number\case number underscoreNIBRS Incident
Report.pdf