0
0
Google Sheetsspreadsheet~5 mins

Linking Sheets with Slides in Google Sheets - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
This feature helps you connect your Google Sheets data to Google Slides. It lets you show your spreadsheet numbers or charts in a slide presentation. When your sheet changes, you can update the slides easily without copying everything again.
When you want to show sales numbers from a sheet in a presentation and keep them updated.
When you create a monthly report in Sheets and want to share it as slides with your team.
When you have charts in Sheets that you want to display in Slides without recreating them.
When you want to save time by linking data instead of copying and pasting repeatedly.
When you want your presentation to reflect the latest data automatically after updates.
Steps
Step 1: Open
- Google Sheets file with your data
Your spreadsheet with data or charts is visible
Step 2: Select
- the cells or chart you want to link
The selected data or chart is highlighted
Step 3: Copy
- the selected cells or chart (Ctrl+C or Command+C)
The data or chart is copied to clipboard
Step 4: Open
- Google Slides presentation where you want to add the data
Your slide deck is open and ready for editing
Step 5: Paste
- the copied data or chart into the slide (Ctrl+V or Command+V)
The data or chart appears on the slide with a link icon
💡 If a dialog appears, choose 'Link to spreadsheet' to keep it connected
Step 6: Click
- the 'Update' button on the linked object when your sheet changes
The slide updates to show the latest data from the sheet
Before vs After
Before
Slide shows old sales numbers copied from the sheet last month
After
Slide shows updated sales numbers after clicking the Update button, matching the current sheet data
Settings Reference
Link to spreadsheet
📍 Paste dialog in Google Slides after pasting data or chart
Keeps the slide connected to the sheet data for easy updates
Default: Link to spreadsheet
Update button
📍 On the linked chart or table in Google Slides
Refreshes the slide content to match the latest sheet data
Default: Click to update
Common Mistakes
Pasting data without choosing 'Link to spreadsheet'
The slide will not update when the sheet changes, so data becomes outdated
Always select 'Link to spreadsheet' when pasting to keep data connected
Not clicking the Update button after sheet changes
The slide still shows old data even though the sheet is updated
Click the Update button on the linked object in Slides to refresh the data
Summary
Linking Sheets with Slides lets you show live data or charts in presentations.
You copy from Sheets and paste into Slides choosing 'Link to spreadsheet' to keep them connected.
Remember to click Update in Slides to refresh data after changes in Sheets.