How to Link an Excel Chart or Table to PowerPoint

When you link Excel to PowerPoint, a chart or table on a slide stays connected to the workbook, so you update the numbers once in Excel and the slide follows. You copy in Excel and paste in PowerPoint with a "link" option: Link Data for charts, Paste link for tables. This guide shows both, how to update and fix links, and how to set up your workbook so monthly slides take minutes.

Link, embed or paste as a picture?#

You have three ways to move Excel content to a slide, and only one stays connected:

Linking keeps a pointer to the workbook file. Embedding stores a copy of the data inside the presentation. A picture is just an image of the cells or chart. For a report you rebuild every month, link. For a deck you email once, embed or paste as a picture.

How to link an Excel chart to PowerPoint#

Charts link through PowerPoint's paste options:

1. Save the workbook first. A link needs a saved file to point to.
2. In Excel, click the chart's border and copy it (Ctrl+C; Mac: ⌘C).
3. In PowerPoint, go to the slide and click Home > Paste (the arrow under the button).
4. Choose Use Destination Theme & Link Data to match the presentation's colours and fonts, or Keep Source Formatting & Link Data to keep the chart exactly as it looks in Excel.

The chart is now a PowerPoint chart whose data comes from the workbook. When the Excel numbers change, select the chart in PowerPoint and click Chart Design > Refresh Data. Chart Design > Edit Data opens the linked workbook.

New to charts? See Excel charts basics for building and formatting them before you link.

How to link an Excel table to PowerPoint#

Ranges of cells link through Paste Special:

1. Select the range in Excel, such as A1:C6, and copy it.
2. In PowerPoint, click Home > Paste > Paste Special. On Windows you can press Ctrl+Alt+V; on a Mac, use Edit > Paste Special (⌃⌘V).
3. Choose Paste link.
4. In the As list, choose Microsoft Excel Worksheet Object and click OK.

The table appears as an object on the slide. Double-click it to open the source workbook. Resize it from the corners, holding Shift to keep its proportions, so text doesn't stretch.

Another route is Insert > Object > Create from file, then browse to the workbook and tick Link. This links the workbook's active sheet as it was last saved, which is less precise than copying a chosen range.

Paste link in Excel itself works differently: it creates formulas such as =Sheet1!B2. The guide to Paste Special values explains that version.

How to update, change or break links#

PowerPoint updates links when you open the presentation, after a security prompt, or when you ask it to:

• Update one object: right-click it and choose Update Link.
• Manage all links (Windows): go to File > Info, then Edit Links to Files under Related Documents. From there you can Update Now, Change Source to point at a moved or renamed workbook, set Automatic or Manual updating, or Break Link.
• Break a link: the object stays on the slide but becomes a fixed copy. Do this before sending a final deck, so recipients don't see link prompts.

If a chart or table won't update, check these in order: the workbook was moved or renamed, the link is set to Manual, the workbook wasn't saved after the change, or the object was pasted without a link option.

How to prepare your Excel file for linking#

Linked slides work best when each slide has its own small, stable range in the workbook. Set up a sheet called Slides with one summary block per slide:

• Build summaries with formulas, not by hand. A list of regions from =SORT(UNIQUE(A2:A500)) with =SUMIFS(...) next to it updates when new data arrives. The lesson on pivot-style summaries with formulas walks through this pattern.
• Keep each block a fixed size. A linked range is a set of cells. If your list grows by a row, the new row may fall outside the linked area. Leave room or keep a fixed number of rows, such as a top 5.
• Format in Excel first. Bold the headers and set currency and percentages before you link; on Windows Ctrl+B, Ctrl+Shift+$ and Ctrl+Shift+% do it in seconds. The formatting shortcuts lesson practises them.
• Write ready-made headlines. A cell such as ="Revenue: "&TEXT(SUM(B2:B5),"$#,##0") returns Revenue: $48,300 and can be linked as a one-line title that updates itself.

The KPI summary guide and the sales dashboard guide show summary layouts that suit linked slides well.

Sharing linked presentations safely#

Links point to a file location, so plan where both files live:

1. Store the workbook and presentation together in a shared folder, such as OneDrive or SharePoint, that everyone who updates the deck can open.
2. Don't rename or move the workbook after linking. If you must, use Change Source to repair the links.
3. Send a final copy with links broken, or saved as a PDF, to people outside the team. They see the last values without prompts.
4. Check the numbers before presenting. Open both files, update the links and compare a few totals.

If you print the source tables as well, the guide to Excel print setup helps you fit them neatly on a page.

Practise it#

Linked slides are only as good as the summary behind them. Practise building a pivot-style summary with formulas, then practise the formatting shortcuts for bold, currency and percent: you type each step and it checks it instantly. The exercise on this page builds a slide headline that updates itself.