Forum Discussion

JP-Ronse's avatar
JP-Ronse
Helper II
8 years ago

convert back to hyperlink

Hi,   I ran a query on an Access database and one of the fields is an hyperlink field. The hyperlink is a link to a document/file on a server/sharepoint.   Loaded into Excel, the "hyperlinks" are...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi JP-Ronse,

 

If I understand you correctly, you should be able set Data Categories for that field to 'Web URL' in PowerPivot to show it as  a clickable hyperlink in Excel Power View. For more details about how to Set Data Categories for fields in PowerPivot, you can refer to this article. :smileyhappy:

 

ExcelData-37

 

 

Regards