Ampler pastes content from Excel into PowerPoint with a live link, so the data on the slide updates when the underlying workbook changes — and you choose exactly how it’s pasted.
Quick answer: Copy the content in Excel, click Paste Object on the Ampler ribbon, and choose how to paste — unformatted data, data with a link, link only, or a picture; the Excel file must be saved to paste with a link.
How to use it
Copy from Excel, Paste Object, and choose how to paste and link.
- Copy the content from Excel (the workbook must be saved to paste with a link).
- Click Paste Object on the Ampler ribbon.
- Choose how to paste — unformatted data, data + link, link only, or a picture — and click OK.
- Manage the object later through its drop-down menu.
A linked object updates on the slide when the source workbook changes, so the numbers stay current.
Keyboard shortcut
Paste Object has no default shortcut. To assign one, open the Settings dropdown on the Ampler ribbon, choose Shortcuts, click Set shortcut on the function, and press your key combination.
Why use it
Numbers pasted as static text go stale the moment the model changes, and re-pasting them by hand is both tedious and a source of error. Pasting from Excel with a link keeps the slide tied to the workbook, so an update in the model flows through to the deck — and Ampler lets you pick the exact paste format for the job.
How consultants use it
In consulting, every number on a slide has to trace back to its source, and the model is that source of truth. Linking the slide to the workbook is how the numbers stay both current and defensible. Three conventions apply:
- One source of truth: the slide draws from the Excel model, so figures aren’t retyped and can’t silently diverge.
- Update once, flow through: a change in the model updates the linked object on the slide.
- Paste format to fit: data with a link when it must update, link only or a picture when it should be fixed.
Paste Object keeps the deck tied to the model that the numbers come from.
Tips & best practices
- Save the workbook before pasting — a link needs a saved source file.
- Use link only or a picture when the figures must stay fixed in the sent deck.
- Before sending externally, consider whether links should be broken or the data embedded.
Availability
Included in Ampler for PowerPoint and the Ampler Suite, on Windows desktop PowerPoint.
Frequently asked questions
How do you link Excel data to a PowerPoint slide?
Copy the content in Excel, click Paste Object on the Ampler ribbon, and choose data + link (or link only). The slide stays tied to the workbook and updates when it changes. The Excel file must be saved first.
How do you keep PowerPoint data updated from Excel?
Paste it as a linked object with Ampler’s Paste Object. When the source workbook changes, the linked object on the slide updates.
What paste options does Ampler’s Paste Object offer?
Unformatted data, data with a link, link only, or a picture — so you choose whether the content stays live or fixed.