Linking Sheets with Slides in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a monthly sales report that automatically updates in a Google Slides presentation whenever the sales data changes in Google Sheets.

📊 Data: You have a Google Sheets file with monthly sales data for different products. The data includes Product Name, Units Sold, and Total Sales for each month.

🎯 Deliverable: Create a Google Sheets report with sales data and link it to a Google Slides presentation so that the slides update automatically when the sheet data changes.

Sample Data

Product Name	Units Sold	Total Sales ($)
Notebook	120	1800
Pen	300	900
Backpack	75	3750
Calculator	50	2500
Desk Lamp	40	1600
Chair	30	4500
Desk	20	6000
Whiteboard	15	2250

1

Step 1: Open your Google Sheets file containing the sales data.

No formula needed.

Expected Result

You see the sales data table with Product Name, Units Sold, and Total Sales.

2

Step 2: Select the range of cells containing the sales data including headers (A1:C9).

No formula needed.

Expected Result

The sales data range is highlighted.

3

Step 3: Copy the selected range (Ctrl+C or Cmd+C).

No formula needed.

Expected Result

The sales data is copied to clipboard.

4

Step 4: Open your Google Slides presentation where you want to insert the sales report.

No formula needed.

Expected Result

Google Slides presentation is open and ready.

5

Step 5: Go to the slide where you want to add the sales data table and paste it (Ctrl+V or Cmd+V).

No formula needed.

Expected Result

A dialog appears asking if you want to link the table to the spreadsheet.

6

Step 6: In the dialog, choose 'Link to spreadsheet' and click 'Paste'.

No formula needed.

Expected Result

The sales data table appears on the slide and is linked to the Google Sheets data.

7

Step 7: To update the slide when the sheet data changes, click the 'Update' button on the linked table in Slides.

No formula needed.

Expected Result

The table on the slide updates to reflect the latest data from Google Sheets.

8

Step 8: Test the link by changing a value in the Google Sheets sales data (e.g., change Units Sold for 'Pen' from 300 to 350).

No formula needed.

Expected Result

The sheet data changes and the linked table in Slides shows an 'Update' button.

9

Step 9: Go back to Google Slides and click the 'Update' button on the linked table to refresh the data.

No formula needed.

Expected Result

The table updates to show Units Sold for 'Pen' as 350.

Final Result

-----------------------------------------
|           Monthly Sales Report         |
|---------------------------------------|
| Product Name | Units Sold | Total $   |
|---------------------------------------|
| Notebook     | 120        | 1800      |
| Pen          | 350        | 900       |
| Backpack     | 75         | 3750      |
| Calculator   | 50         | 2500      |
| Desk Lamp    | 40         | 1600      |
| Chair        | 30         | 4500      |
| Desk         | 20         | 6000      |
| Whiteboard   | 15         | 2250      |
-----------------------------------------

✓The sales data table in Google Slides is linked to Google Sheets and updates automatically.

✓Changing data in Sheets triggers an update prompt in Slides to keep the report current.

✓This method saves time by avoiding manual copying and pasting for monthly reports.

Bonus Challenge

Create a chart in Google Sheets based on the sales data and link that chart to Google Slides so it updates automatically.

Show Hint

Use Insert > Chart in Google Sheets, then copy the chart and paste it into Google Slides choosing 'Link to spreadsheet'.

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