Populate a PowerPoint Shape

When you want to populate and link data to a PowerPoint Shape, make sure the shape is selected. In the Workbook Pane, select the data range you need in the PowerPoint Shape, right-click the mouse and choose 'Populate the selected Shape'.


If the workbook is open in Excel, please click 'Populate and Link' in the OfficeReports ribbon tab in PowerPoint:


The Shape will be 'linked' to the data range, so when the data in the range changes, we can update the PowerPoint Shape(Refresh).

When you click a 'linked' PowerPoint Shape, the 'Link Pane' will appear on the right side.


Text in multiple cells

In case you have selected multiple cells, OfficeReports will concatenate the contents from the different cells. OfficeReports will add a space character between texts from different cells on the same row, and OfficeReports will add a new line between texts from cells in different rows. Here an example:

Linked to a (Text)shape we get:

The Shape will be 'linked' to the data range, and now you can edit the 'link' properties in the Link Pane appearing at the right side.