How to use Links?

About ProductivityPlus Links

Links is a feature in ProductivityPlus that lets users import and link an element (chart, table, graph or cell) from a Microsoft Excel file into PowerPoint. This link creates a path for updates to the element to flow from the original Excel file to PowerPoint. 

Prerequisites 

How to use Links?

Link charts, graphs, and tables into PowerPoint

1. Save your Excel document.
2. Copy the desired element from Excel (Ctrl+C).
3. Paste it into PowerPoint (Ctrl+V).
4. Click Link on the callout that appears on top of the copied element.
5. The Excel design will be applied to the PowerPoint element and a link will be created between the two elements.

Link a cell into a PowerPoint text box

1. Save your Excel document.
2. Copy the desired cell from Excel (Ctrl+C).
3. In PowerPoint, place the cursor within the text box
4. Paste the cell into PowerPoint (Ctrl+V).
5. Click Link on the callout that appears on top of the copied element.

Update an Excel element in PowerPoint

1. Click on the linked element in PowerPoint.
2. Click on Update on the callout that appears on top of the linked element.
3. The linked element will update to the latest version of the Excel document.

Edit the source file of a linked element

1. Click on the linked element in PowerPoint.
2. Click on Edit on the callout that appears on top of the copied element.
3. The source Excel file will open and the linked element will appear as selected.

Change the source of a linked element

1. Click on the linked element in PowerPoint.
2. Open the drop-down menu on the callout that appears on top of the copied element.
3. Click on Change Source.
4. The File Explorer will open.
5. Select the desired version of the source file.
6. Click on Open.
7. The source of the file will be change and the Excel element in PowerPoint will change accordingly.  

Remove the link between Excel and PowerPoint

1. Click on the linked element in PowerPoint.
2. Open the drop-down menu on the callout that appears on top of the copied element.
3. Click on Remove Link.
4. The link between the Excel document and PowerPoint will be removed.

Open an overview of the linked elements

1. In Templafy ribbon, click on the Links icon (alternatively, click on "View All" in the drop-down menu of the callout that appears when clicking on the linked element).
2. The Links pane opens on the right side.
3. The overview provides information about each linked element, their source file, and the last update.

Through the Links pane, you will be able to perform actions on the linked elements and access two different views summarizing them:

• By slides (default view) 
  • Navigate through the linked elements through the presentation
  • Update, or remove the links on a presentation level
  • Update, or remove the links on a slide level
  • Update, edit, change the source, and remove the link on a single linked element level
• By file
  • Navigate through the linked elements through the presentation 
  • Update, edit, change the source, and remove the links on an Excel file level
  • Update, edit, change the source, and remove the link on a single linked element level

Related articles