Hi Guys, hoping you can help because I'm going out of my mind here. I have a pivot which is pulling a file path field through, and of course it doesn't come through as a hyperlink. Every example of converting text to hyperlink that I can find seems to assume that my path start with http. It doesn't. It starts with \\fmu. Can someone PLEASE help me
Out because I actually have no idea what I'm writing. I just copy it and hope for the best. My pivot is PivotTable1, in sheet 2 (named FIRE) and the field that had the now Plai text that I need to be a hyperlink is (unsurprisingly) called Hyperlink.

I have hit alt-F11, and double clicked on sheet 2 ..... And now I'm saying my prayers.

Please can a boffin help??