How to Link Excel Charts to PowerPoint Without Re-Pasting

The pain every finance team knows

It is month-end. The model is refreshed. And now someone on the team opens the 60-slide board deck and starts the ritual: copy the revenue chart in Excel, switch to PowerPoint, delete the old one, paste the new one, nudge it back into position, fix the font size the paste broke, move on to the next chart. Repeat 30 or 40 times.

This is not a productivity problem in the abstract. It is the single largest source of last-minute errors in most FP&A reporting packs. A chart from last month's model slips through. A table gets pasted into the wrong slide. A number is right in the spreadsheet but stale in the deck the board actually reads.

The root cause is simple: the chart in your deck is a dead copy. It has no idea where it came from or whether the source has changed.

The native Office approach: paste-special as a linked object

Microsoft Office does offer a built-in way to link a chart. In Excel, copy the chart, switch to PowerPoint, and use Paste Special > Paste Link to insert it as a linked OLE object. In theory, the chart stays connected to the workbook. In practice, this method has well-known limitations:

• Fragile file paths. The link stores an absolute path to the Excel file. Move the workbook to a different folder, rename it, or open the deck on another machine, and the link breaks silently.
• Manual refresh. Linked OLE objects do not update automatically when you change the model. You have to right-click each object and choose "Update Link" — one at a time.
• Formatting surprises. The pasted object often renders at a different size or with shifted fonts, especially if the source workbook's theme differs from the deck's.
• No visibility into link health. There is no dashboard that shows you which links are current, which are stale, and which are broken. You find out when someone in the board meeting notices.

For a deck with two or three charts, paste-special works. For a 40-chart reporting pack that ships every month, it becomes a liability.

A different approach: linked shapes with Navifia

Navifia is a pair of VSTO add-ins for Excel and PowerPoint, built specifically for finance teams that maintain recurring decks. Its approach to linking works differently from OLE objects.

Instead of embedding an OLE reference, Navifia inserts the chart (or table, or range) as a native PowerPoint shape — an image that carries metadata about its source. That metadata is stored inside the PowerPoint file itself, not as an external file-path dependency. The shape looks and behaves like any other shape in your deck: you can resize it, position it, and layer it normally.

Step-by-step: linking a chart

1. Select in Excel. Click the chart (or select the range / table) you want to send to the deck.
2. Export to PowerPoint. On the Navifia ribbon in Excel, click Export to PPT. Choose the open presentation and the target slide. Navifia inserts the selection as a linked shape.
3. Position once. Move and resize the shape on the slide. Use Fit to Slide to size it to your template's column width before it leaves Excel, so it lands at the right dimensions.
4. Work normally. Edit the model throughout the month. The shape on the slide does not change yet — it holds the version from when you exported it.
5. Push Updates. When you are ready, click Push Updates from the Navifia ribbon in Excel. Every linked shape across every open deck refreshes in one pass, pulling the current state from the source ranges and charts.

That fifth step is the key difference. Instead of updating one chart at a time, you update everything at once. Links resolve by workbook file name: if you rename or move the file, reopen the matching workbook (or use Excel Links) so the shape can refresh again.

Keeping track of what is linked

In PowerPoint, Navifia's Excel Links pane shows every linked shape in the deck with its status: OK, Stale, or Source missing. Before the pack goes out, you can scan the list and know exactly which shapes are up to date — no guessing, no right-clicking each one individually.

What about tables and single numbers?

Charts are the most obvious use case, but the same workflow handles Excel tables and ranges. You can also link a single cell value as styled text on a slide — useful for KPI callouts like "Revenue: $1,240M" that need to update with the model. The value refreshes with Push Updates just like a chart would.

Limitations to know about

Linked shapes solve the re-pasting problem, but the linking itself has a few edges worth knowing before you rely on it for a real deck:

• Refresh is a click, not real-time. A linked shape doesn't watch the workbook continuously — it updates when you hit Update on the shape (or Push Updates from Excel). Edit the model all you want; the slide only changes when you tell it to.
• Table refresh is slower than a chart or picture. A linked table reapplies Excel's formatting — fills, fonts, borders, merged cells — cell by cell, since Excel has no bulk API for reading that. A small table is instant; a large one (past roughly 75 rows or 20 columns) is noticeably slower and shows a warning before it proceeds.
• A linked picture or chart inside a PowerPoint group needs the group broken first. Update can't reach into a group to replace a picture or chart shape — ungroup, then update. A linked text value is the exception: it updates in place even inside a group.

Which approach should you use?

If you link two charts into a one-off presentation, paste-special is fine. It is built in, it is free, and the limitations do not matter much at small scale.

If you maintain a recurring reporting pack with dozens of linked objects that update every close — the monthly board deck, the quarterly investor pack, the weekly ops review — the native approach starts to cost real time and real risk. That is the workflow Navifia was designed for.