About this article
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.
- Link charts, graphs, and tables into PowerPoint
- Link a cell into a PowerPoint text box
- Update an Excel element in PowerPoint
- Edit the source file of a linked element
- Change the source of a linked element
- Remove the link between Excel and PowerPoint
- Open an overview of the linked elements
- Link and fit to placeholders
- Remove hyperlink formatting
Prerequisites
|
Link a chart, graph, and table into PowerPoint
- Save your Excel document.
- Copy the desired element from Excel (Ctrl+C).
- Paste it into PowerPoint (Ctrl+V).
- Click
Link
on the callout that appears on top of the copied element. - 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
- Save your Excel document.
- Copy the desired cell from Excel (Ctrl+C).
- In PowerPoint, place the cursor within the text box
- Paste the cell into PowerPoint (Ctrl+V).
- Click
Link
on the callout that appears on top of the copied element.
|
Update an Excel element in PowerPoint
- Click on the linked element in PowerPoint.
- Click on
Update
on the callout that appears on top of the linked element. - The linked element will update to the latest version of the Excel document.
|
Edit the source file of a linked element
- Click on the linked element in PowerPoint.
- Click on
Edit
on the callout that appears on top of the copied element. - The source Excel file will open and the linked element will appear as selected.
|
Change the source of a linked element
- Click on the linked element in PowerPoint.
- Open the drop-down menu on the callout that appears on top of the copied element.
- Click on
Change Source
. - The File Explorer will open.
- Select the desired version of the source file.
- Click on
Open
. - The source of the file will be change and the Excel element in PowerPoint will change accordingly.
|
Remove the link between Excel and PowerPoint
- Click on the linked element in PowerPoint.
- Open the drop-down menu on the callout that appears on top of the copied element.
- Click on
Remove Link
. - The link between the Excel document and PowerPoint will be removed.
|
Open an overview of the linked elements
- In Templafy ribbon, click on the Links icon (alternatively, click on
View All
the drop-down menu of the callout that appears when clicking on the linked element). - The Links pane opens on the right side.
- 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
Link and fit to placeholders
|
Enable Excel users to make linked charts and tables fit the size of placeholders in PowerPoint. When pasting a table into specific placeholders it will be possible to fit the table to the selected placeholder.
How to use:
- In Excel, select the table or the graph that should be linked in PowerPoint
- Copy the graph/table
- In PowerPoint, select the placeholder in which the graph/table
- Paste the graph/table using (CTRL+V) or the main
Paste
button in the Office ribbon
- Other pasting options such as right-click and paste will not work and will not display the Links call-out.
- Based in the placeholder type and the object type, click the arrow displayed next to Links and select the
Link and fit to placeholder
orLink and restore original size
option.
Remove hyperlink formatting
|
Enables users to hide hyperlink styling of linked cells in PowerPoint.
How to use:
- After pasting cells from Excel to PowerPoint using Excel Links, Click
Hide Links
button from the ribbon OR click theEye icon
in the Links overview pane - The hyperlink formatting from all linked cells will be hidden
When a textbox containing a linked cell is being edited, the hyperlink will be displayed to remind the user that the underlined text is linked to Excel
|
Related articles
Comments
0 comments
Article is closed for comments.