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

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.

Practice

1. What is the main benefit of linking a Google Sheet chart to a Google Slides presentation?

easy

A. The chart data is deleted from the Sheet after linking

B. The chart becomes editable directly in Slides

C. The chart is converted to an image and cannot be updated

D. The chart updates automatically when the Sheet data changes

Solution

1. Step 1: Understand linking purpose and update behavior

   Linking keeps the chart connected to the Sheet data so it can update. When data changes in Sheets, the linked chart in Slides can refresh to show new data.

2. Final Answer:

   The chart updates automatically when the Sheet data changes -> Option D

3. Quick Check:

   Linking means auto-update [OK]

Hint: Link means updates flow from Sheets to Slides [OK]

Common Mistakes:

• Thinking chart edits happen in Slides
• Assuming chart becomes static image
• Believing data deletes after linking

2. Which menu option in Google Slides allows you to insert a linked chart from Google Sheets?

easy

A. Insert > Chart > From Sheets

B. File > Import > Chart

C. Edit > Paste Special > Linked Chart

D. View > Linked Objects > Add Chart

Solution

1. Step 1: Locate chart insertion path

   In Slides, charts from Sheets are inserted via the Insert menu. The path is Insert > Chart > From Sheets to link a chart.

2. Final Answer:

   Insert > Chart > From Sheets -> Option A

3. Quick Check:

   Insert menu has chart options [OK]

Hint: Use Insert > Chart > From Sheets to link charts [OK]

Common Mistakes:

• Looking under File or Edit menus
• Trying to paste charts without linking
• Searching in View menu for charts

3. You linked a chart from Sheets to Slides. After updating the data in Sheets, what happens when you open the Slides file?

medium

A. The chart remains unchanged and cannot be updated

B. The chart updates automatically without any prompt

C. Slides shows a prompt to update the linked chart

D. The chart is removed from Slides

Solution

1. Step 1: Understand update behavior on open

   Slides detects changes in linked Sheets data and prompts to update. User must click the prompt to refresh the chart with new data.

2. Final Answer:

   Slides shows a prompt to update the linked chart -> Option C

3. Quick Check:

   Update prompt appears on open [OK]

Hint: Look for update prompt when opening Slides [OK]

Common Mistakes:

• Expecting automatic update without prompt
• Thinking chart updates without user action
• Assuming chart disappears after data change

4. You inserted a linked table from Sheets into Slides, but the 'Update' button is missing when data changes. What is the likely cause?

medium

A. The Sheets file is not shared with Slides

B. The table was pasted as an image, not linked

C. Slides does not support linked tables

D. The Sheets data is empty

Solution

1. Step 1: Check insertion and update button

   If pasted as an image, no link exists to update data. Only linked objects show the update button in Slides.

2. Final Answer:

   The table was pasted as an image, not linked -> Option B

3. Quick Check:

   Update button missing means no link [OK]

Hint: Ensure you insert linked, not pasted images [OK]

Common Mistakes:

• Assuming sharing affects update button
• Believing Slides can't link tables
• Thinking empty data removes update button

5. You want to create a presentation that always shows the latest sales data from your Google Sheet. Which steps correctly link and update the data in Slides?

hard

A. Insert chart from Sheets, then click 'Update' in Slides when data changes

B. Copy chart as image from Sheets and paste in Slides, then replace manually

C. Export chart as PDF and insert in Slides, update by re-importing

D. Use Slides' built-in chart tool and manually enter data

Solution

1. Step 1: Insert and update linked chart

   Use Insert > Chart > From Sheets to link the chart for live updates. When Sheet data changes, click 'Update' in Slides to refresh the chart.

2. Final Answer:

   Insert chart from Sheets, then click 'Update' in Slides when data changes -> Option A

3. Quick Check:

   Link + Update = latest data shown [OK]

Hint: Link charts and use update button for fresh data [OK]

Common Mistakes:

• Pasting static images instead of linking
• Using export/import instead of linking
• Manually entering data in Slides charts