Pivot Table containing hyperlinks

[gazmoz17]

Hi,

Is there a way to create a tbale that contains a column of hyperlink fields? This field contains hyperlink to c:drive location rather than a web page?

I haven't made my web page yet however this is an extract of my data.

Typical hyperlink:

C:\ProgramData\Sage\Accounts\2021\Company.000\Transaction Attachments\Purchase Transaction 140149

The hyperlink points to a folder of supporting pdfs relating to my purchase order pivot table.

Many Thanks
Gareth

 

[severynm]

Absolutely! However, for it to work correctly you'll need to add a file extension to the end of the file path.

If you want excel to pick it up as a hyperlink automatically, you might have to type in something like file:///C:\Temp\filename.csv to the cell instead of just C:\filename.csv.