Picture links

Picture Links are pictures that can be inserted into a workbook that provide the same functionality as the XL3Link formula.

To insert a picture link, select Insert Formula > XL3PictureLink.

Select the image to display in the picture link. You can search from the provided icon set, or load or paste your own image.

Select the cell where the user will be taken when the image is clicked on. This can be the same sheet if the picture link controls something on this sheet or a different sheet to let the user move around the report.

If you enable Submit Changes on Web and the report has been published, any editable cells or Delayed Slicers are submitted when you select the picture. It acts the same as the Submit toolbar button on the web.

You can provide a list of cells to update with either a value or the contents of another cell. This can be used to drive a selection or copy ranges of values between worksheets or cells on the same sheet.

You can use a picture to trigger toolbar buttons. To do this, the picture must link to a cell with the trigger text XL3Toolbar:ButtonName, for example:

To edit an existing Picture Link, hold the Shift key when selecting and the standard Picture Link form is displayed.

To link to another web report from a picture link, first write ‌an XL3WebReportLink that doesn't have a 'link text' value, for example, =XL3WebReportLink("/Testing/Book2.wbsql", , 0).

The picture link then needs to link to the cell containing this formula and select the option Use address from link to cell.

To use a camera object as the source for an image, first insert the Picture Link selecting a temporary picture. Then right-click on the picture to highlight it and then type the source range for the image in the formula bar, that is, Sheet2!a1:f10 would change the picture link to show the contents of the range. It can then be resized and re-positioned as required.

To find the name of the picture link right-click the link and copy the contents of the Excel Name Box. This box is next to the Formula Bar. It'll normally begin with @PL.