Updates a Picture or Pictures to an image on the internet.
This allows you to display a Picture based on a parameter in Excel. For example, if a Store parameter drives a report, you could use this to display a picture of the store.
This function is primarily for use in reports published to the web where images update automatically. In Excel, you can force a refresh of the images by using the Anaplan XL > Extra > Refresh Dynamic Pictures menu option. This'll only retrieve a new picture if the formula has been run in the current session and has a different URL from the last run.
Syntax
XL3DynamicPicture(PictureName, Url [, Resize])
Parameters
| Parameter | Description |
| PictureName | Alt Text > Alternative text (or the Alt Text > Description in Excel 2010 and higher) of the Picture to update. If several Pictures have the same name they will all be updated. |
| Url | Web address of the image to use, in the form http://www.example.com/logo.jpg. |
| Resize | Resize the picture to its natural size so that it is not stretched. Default is false. |
Example
You can set up a named image by inserting a picture using the standard Excel menu option.
Right-click the picture and select properties and the Alt Text tab. Type the description within the Alternative text box, or in the Alt Text > Description box.
Finally, set up a formula, for example:
=XL3DynamicPicture("MyLogo"; "http://www.example.com/logo.jpg")
The URL parameter is fixed, but it could be set to reference another cell or concatenated text.
Scheduling/PDF
For dynamic pictures in reports that'll be scheduled or downloaded as PDFs/Workbooks, the URL will need to be for a server accessible from the AnaplanXL Web server and doesn't require any authentication. You can use an internet site URL if the server has internet access. If the server isn't connected to the Internet, you can use a local server set up to let Anonymous access it.
