Hyperlinks in PowerPoint presentations can be great when you have presentations with links to other documents, presentations, external files or websites. On a slide, you can give some minimal information and invite people to click for a more detailed information. Often this other document is a PDF file, another PowerPoint presentation or a page on a website. With DataPoint you can keep your presentations up-to-date and even maintain the hyperlinks from an Excel file or database in real-time for the latest information. This DataPoint technology is great when you create catalogs or brochures with information that regularly changes. We will show you how to use dynamic hyperlinks in PowerPoint with DataPoint.
Start with a normal PowerPoint presentation. Replace the picture on the laptop, with an image and hyperlink from my data source.
DataPoint can get its information from various data sources like databases, XML files, RSS feeds or, like here in this sample, from an Excel datasheet. The datasheet looks like this:
First action is to use DataPoint to establish a link to our Excel data. A data connection pointing to the Excel file and a query pointing to our range on our datasheet. If needed, you can take a larger range to capture more data, later on when needed.
At the picture properties, select the data connection and set the column to the Excel column that contains the hyperlink.
We have more data records in our Excel file and we want to create a brochure with all our products. Click DataPoint and then the Scrolling button.
Check the Enabled option and leave the step size to 1. If needed, you can change the step time. This time shows a slide for this number of seconds, before the slideshow advances automatically to the next data record. Hit OK to Close.
It’s time to create our products brochure. This process will automatically create a new presentation, one slide per product that we have in our Excel data. All images will have another product image and a different product url for more information. Click the Snapshot button.
After a few seconds, a new presentation is opened with the latest up-to-date information on the slides. Ready to visit your customers with your new products brochure!
You can use DataPoint technology to create dynamic hyperlinks on text boxes, tables and the same in this article, on images.