Hyperlink within hyperlink
It would be great if the Worksheet can be programmed as having Hyperlink within Hyperlink, eg;
I have 2x spreadsheet, 1 is the one I steer meeting to the board and other spreadsheet is used by our projects team to update on progress, which has Hyperlink to the supporting documents for the projects. I would like my spreadsheet be able to hyperlink and go straight to the supporting documents.
Is it possible??
David Taylor commented
If i understand this correctly, you want Power Query to grab a hyperlink from your source data and then to activate upon "Close & Load"? If so, I could really use this feature too as I'm trying to this too. When I "Close & Load," PQ loads a de-activate hyperlink as if it's just text that when you click on it, doesn't take you anywhere. I'd like PQ to add a "Hyperlink" data type.