📽️ Lesson 6.3: Version History, Linking Excel Charts & Embedding

Version History — Your Safety Net

Here's a quiet truth about creative work: you experiment more boldly when you know you can't lose anything. Every reckless-but-brilliant idea you've talked yourself out of — "what if I redesigned the whole deck in this new theme?" — got shelved because starting over felt too risky. Version History removes that fear entirely. When your deck lives on OneDrive, PowerPoint quietly saves snapshots of it over time, and you can browse those snapshots and roll back to any of them. The worst case for a bold experiment stops being "I ruined my deck" and becomes "I clicked Restore." That changes how you work.

This is also the safety net under everything in Module 6. Sharing a deck, letting people co-edit, accepting a flurry of changes during a live session — all of it is far less nerve-wracking when you know the deck's past is recoverable. If a collaborator accidentally deletes three slides, or a co-authoring session gets messy, you don't panic; you open the timeline and step back to before the mishap. Version History is what makes fearless collaboration actually fearless.

The prerequisite, once more, is the cloud. Version History requires the deck to be on OneDrive (or SharePoint for work/school accounts). A file sitting on your local drive has no such timeline — another concrete reason the very first step of this whole module, saving to OneDrive, pays off again and again. On the web the deck is already there; on desktop, it's on OneDrive with AutoSave on, exactly as we set up in Lesson 6.1.

Browsing, Naming & Restoring Versions

Open the timeline from File > Info > Version History (on the web, at the time of writing, it's also reachable by clicking the file name in the top bar and choosing Version History; menus shift, so if you don't see it there, look under File > Info). A pane opens listing dated, time-stamped versions — usually with who made the changes. Selecting a version opens it in a read-only preview so you can inspect it without disturbing your current deck. This is the crucial comfort: looking is completely safe. You can browse the whole history and change nothing.

Restoring a version

When you've found a version you want back, click Restore. PowerPoint makes that older version the current one — and, importantly, it does so non-destructively: the version you were just on doesn't vanish, it simply becomes another entry in the history. So even a restore is reversible; if you restore and then change your mind, restore forward again. There is no cliff edge here. This is the mechanism that lets you undo a collaborator's accidental deletion, recover a slide you cut yesterday and now want back, or return to "the good version from before I over-tinkered."

Naming important versions (Microsoft 365)

A long timeline of "10:42 AM, 10:51 AM, 11:03 AM…" is hard to navigate when you need a specific milestone. On many Microsoft 365 setups you can give a version a name — a human label like "Draft sent to manager" or "Approved for the board." Named versions stand out in the list, so the moments that matter are easy to find months later. This is a paid-tier nicety; on a free personal account you still get the automatic timestamped history, which is the essential part. If you can't name versions, a simple workaround is to note key milestones in your Learning Journal or a comment.

Read the dotted arrow as the reassurance it is: restoring never throws anything away — the version you left becomes just another point on the timeline you can return to. That's why Version History earns the word "fearless." Nothing you do here is a one-way door.

Three Ways to Bring in an Excel Chart

Now the Office-family superpower. Presentations constantly need charts, and charts constantly come from Excel — where the data actually lives. Because PowerPoint and Excel are siblings, moving a chart between them is smooth, but how you do it matters enormously. There are three methods, and they behave very differently once the data changes later. Getting this distinction right is the whole point of this section.

Paste-link — the live connection

A paste-link puts the chart on your slide but keeps its data in the Excel file, with a live link between them. Update the numbers in Excel, and the chart on your slide updates to match. This is the dream for any recurring deck — a monthly report, a dashboard, a KPI slide — where the story stays the same but the figures move. You maintain the data in one place (Excel, where it belongs) and the presentation reflects it automatically.

Embed — self-contained

An embedded chart carries a copy of its data inside the deck. There's no external link, so the deck is fully self-contained — hand someone the .pptx and the chart travels with all its data, no Excel file needed. The trade-off: it won't auto-update from your master spreadsheet; to change it you double-click and edit the embedded copy. Embedding is right when portability matters more than live updates.

Paste as picture — frozen

Pasting as a picture drops in a flat image. It can never update and can never be edited as a chart — but it's rock-solid: it looks identical everywhere, on any device, with zero risk of a broken link or a shifted layout. Use it for a final snapshot where the number is settled and you want it to stay exactly as it is, forever.

Paste-Linking a Live Excel Chart

Let's do the star technique step by step. This is easiest and most reliable in the desktop apps (Excel and PowerPoint on Windows or Mac) — we'll be honest about the web in the next section — so the steps below assume the desktop app.

1. In Excel, select the chart you want (click its border so the whole chart is selected) and copy it with Ctrl+C (⌘+C on a Mac).
2. In PowerPoint, go to the target slide and open the paste options — the Home > Paste drop-down arrow, or the little Paste Options button that appears after a normal paste.
3. Choose a "link" paste. The paste-options gallery shows small icons; the two you want are the "Use Destination Theme & Link Data" and "Keep Source Formatting & Link Data" options — both create a live-linked, native chart (more on which to pick in a moment). (Paste Special > Paste link also links, but it inserts the chart as a linked Excel object that doesn't pick up your theme and edits differently — the Paste Options icons are the better everyday choice.)
4. Confirm the link. The chart appears on your slide, now tied to the Excel file. Test it: change a number in the Excel workbook, save, and watch the slide's chart update to match.

Keeping the link healthy

A linked chart depends on PowerPoint being able to find the Excel file, so two habits keep links from breaking:

• Keep both files on OneDrive (ideally in the same folder). Cloud paths are stable and travel with you; a link to a file on your C: drive breaks the moment the deck opens on another computer.
• Refresh when needed. If a chart doesn't show the latest numbers, right-click it and choose Update Link (or use File > Info > Edit Links to Files to manage all links at once). Links usually update on open, but a manual refresh guarantees it.

Formatting, Web Limits & the Office Advantage

Keep source vs use destination formatting

When you paste a chart, PowerPoint asks — via those paste-options icons — whether to keep the chart's source look (its Excel styling) or adopt your destination theme (your deck's colors and fonts). For a polished, consistent deck, use the destination theme nearly every time: the chart then inherits your deck's palette and typography and looks like it belongs, exactly the "design once via the theme" philosophy this whole course is built on. Keep source formatting only when the chart's own styling is deliberate and must be preserved. Either choice can still link the data — the formatting question and the linking question are separate dials, and the paste gallery lets you combine them.

The Office-family advantage

Step back and appreciate what this is: a chart that lives in Excel and updates itself on a PowerPoint slide, with no copy-paste dance every month. That tight, native link between the spreadsheet and the presentation is a genuine PowerPoint-plus-Excel win — the kind of thing that comes from both apps being the same family, sharing the same file formats and the same account. It's a concrete, honest advantage over stitching together tools from different vendors, and it's exactly why so many data-heavy workplaces standardize on Office. Google's Sheets-to-Slides linking exists and is improving, but the Excel-to-PowerPoint pairing is deep, mature, and hard to beat for serious data work.

Embedding & Exporting Your Deck

Linking pulls Excel into your deck. The flip side is pushing your deck out into the wider world — onto a web page, a learning platform, or a system that wants a file rather than a live link. A few honest paths:

• Publish / embed to the web — a deck on OneDrive can generate an embed snippet so it plays inside a web page or blog, or a shareable view link (this is the Lesson 6.1 sharing machinery reused for a wider audience). Availability and exact wording vary by account, but the idea is a read-only, live view others can watch without PowerPoint.
• Export to PDF — File > Export (on the web, File > Download As > Download as PDF, as Lesson 8.2 shows) makes a universal, frozen, un-editable document — ideal for handouts and for anyone without PowerPoint.
• Export to video — File > Export > Create a Video turns the deck into a self-playing MP4 for platforms that host video (strongest on the desktop app, as covered back in Lesson 5.3).
• Save the .pptx — the native file others can open, edit, and re-present in PowerPoint or import into Slides.

The through-line: match the export to the audience. People who'll edit want the .pptx; people who'll only read want a PDF; people who'll watch passively want a video or an embedded player; people browsing a web page want an embed. And whenever a deck contains a paste-linked chart, remember the trade-off from earlier — a PDF or video bakes in the numbers as they stand at export time, which is often exactly what you want for a snapshot handout.

🎯 Project: Link a Chart & Check History

Two goals in one project: bring a chart into your deck the smart way, and confirm your safety net is real by opening Version History. Do the paste-link on the desktop app if you can; if you're web-only, embed a chart or paste one as a picture instead — the point is to practice the decision and see the history timeline.

Ask yourself: will these numbers change,
and do I want the slide to follow?

  YES, keep it live      ->  Paste Options > Use Destination
                             Theme & Link Data (desktop)
  Deck must stand alone  ->  Embed  (data copy travels in the .pptx)
  Number is final        ->  Paste as Picture (frozen image)

Web-only today?
  Live-link AUTHORING is a desktop strength.
  On the web, EMBED or paste a PICTURE instead --
  the web will still DISPLAY a link made on desktop.

Keep source vs destination formatting?
  Use DESTINATION theme almost always -- the chart
  then matches your deck (design once, via the theme).

Best Practices for Versions & Linked Data

✅ Do's

• Experiment boldly, knowing you can restore. Version History means the worst case is one click of Restore, not a ruined deck.
• Paste-link when numbers will change; use the destination theme. The chart updates itself and looks like it belongs in your deck.
• Keep the deck and its linked Excel file together on OneDrive. Stable cloud paths keep links from breaking.

❌ Don'ts

• Don't rely on Version History as a permanent archive. Retention has limits — download a dated copy for anything you must keep for years.
• Don't paste-link a chart into a deck that must stand alone. If the Excel file won't travel with it, embed instead, or the link breaks.
• Don't expect to author live links on the web. That's a desktop strength — on the web, embed or paste a picture.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

Your deck now has a time machine and a live data feed. You can roll back any mistake, name the milestones that matter, pull real numbers from Excel that update themselves, and push the finished deck out in whatever format its audience needs. That completes Module 6: your presentation is now shareable, reviewable, co-authorable, versioned, data-connected, and exportable — a genuinely professional, team-ready artifact.

❓ Common Questions at This Stage

🔭 Looking Ahead

That wraps up Module 6 and the entire foundation of this course — you can now build, design, animate, deliver, share, and connect a deck. In the next lesson — Lesson 7.1: Project — A Pitch Deck — the training wheels come off. You'll put everything together to build a complete, polished pitch deck from scratch: message, structure, design, and delivery, all in one real project. It's where all these skills finally click into a single confident whole.

✅ Before the Next Lesson

• Confirm you can open Version History and understand how to preview and restore
• Have a chart (linked, embedded, or a picture) sitting in your deck so you've practiced the choice
• Skim your Deck Plan from Lesson 1.1 — the projects ahead build on it
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• PowerPoint Help & Learning (Microsoft Support)
• Office — link or embed data across apps (Microsoft Support)
• OneDrive Help — version history & restoring files