Hyperlink Range
The Hyperlink Range function takes any cells in the Apply To range that contain the HYPERLINK formula and converts them into an embedded hyperlink within the cell, removing the formula.
The HYPERLINK formula is very useful in building a dynamic hyperlink based on values in other cells on the worksheet which may be dynamically populated. However, when a workbook is published as a web page or PDF file, the hyperlink functionality from these formulas is removed. That is where this management function comes in because it converts the formulas to embedded hyperlinks which translate to the web and PDF formats.
Example
A process is set up that whenever a widget is rejected a picture is taken. In the PLC, the name of that picture is stored, and a bit is set high to indicate an issue. The customer would like a report containing the timestamp and a link to view the picture taken so their operators can see what is going on. The report should be a web page they can access from their browser.
To accomplish this, a report template is configured with a real time group to bring in the timestamp and the picture file name. Additionally, a HYPERLINK formula is configured on the sheet to link to the image file brought in. To convert that HYPERLINK formula to a hyperlink that works from a web page, a Hyperlink Range function is configured with the Apply To set to the cell with the HYPERLINK formula.