I have a SQL Server table that is displayed in an Excel spreadsheet.
One of the fields is a path to a location on our network (all users have access to the network).
The path transfers over fine, but it won't open via a click on the cell in Excel. I have tried adding the "file://" prefix, but that doesn't help.
'file://' + Path AS PathName
And tried using the Hyperlink Excel keyword as such:
'=HYPERLINK("file://' + Path + '")' AS PathName
Any ideas on how I can get it to work?