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. 

Pre-requisites 

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.

Note: updating a cell will only be possible through the Excel overview.

Open the source file of a linked element

1. Click on the linked element in PowerPoint.
2. Click on "Open" 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.

Note: opening the source file of a cell will only be possible through the Excel overview.

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.  

 Note: changing the source file of a cell will only be possible through the Excel overview.

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.

Note: removing the link for a cell will only be possible through the Excel overview.

Open an overview of the linked elements

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

Updating elements

• Update all: will update all Excel elements in the presentation
• Update slide: will update all Excel elements on the slide
• Update: will update the selected Excel element

Opening the source file 

With the overview, you can also open the source file of a specific linked Excel element by selecting "Open Source" from the drop-down menu within the pane.

Changing the source

With the overview, you can also change the source files of your Excel elements. 

• In the slide view: you will be able to change the Excel source of a single item
• In the file view: you will be able to change the source file of several items

Removing the link

With the overview, you can also remove the link between the Excel document and PowerPoint by selecting "Remove link" from the drop-down menu within the pane. The link can be removed for : 

• All Excel elements in the presentation
• All Excel elements on the slide
• The selected Excel element