...
Article

Why Excel links break in PowerPoint (and how to make reporting resilient)

13 March 20266 min readUpdated 10 November 2026By the INSYNCR team

Why Excel links break in PowerPoint (and how to make reporting resilient)
Quick answer

Excel links in PowerPoint break because each link stores the workbook’s exact file path. When the file moves, a sheet is renamed, the file syncs through OneDrive, a security prompt is cancelled or updates are turned off, PowerPoint can’t reach the data. It keeps showing the last numbers it saw, with no warning. Here are the five causes and the fix for each.

The 5 most common causes, and how to fix each one

Cause What you see Fix
1. The workbook moved or was renamed Old numbers, or an error when you update File, Info, Edit Links to Files, Change Source, pick the file again
2. A sheet was renamed or the range moved The link updates to the wrong cells, or fails Rename the sheet back, or Change Source to the new range; use named ranges from now on
3. The file lives in OneDrive or SharePoint Works for you, fails for everyone else Link from the shared location everyone uses, then test on a colleague’s PC
4. The security prompt was cancelled Old numbers, no error Reopen the deck and click Update Links, or update from Edit Links to Files
5. Automatic Update is off Numbers only change when someone remembers Edit Links to Files, select each link, tick Automatic Update

The video above fixes a broken link from start to finish. The steps are written out below.

How to fix a broken Excel link in PowerPoint, step by step

These steps are for PowerPoint for Microsoft 365 on Windows.

  1. Save the deck. The links screen only shows for saved files.
  2. Go to File, then Info.
  3. Bottom right, under Related Documents, click Edit Links to Files.
  4. Read the path next to each link. That’s where PowerPoint is looking.
  5. Select a broken link and click Change Source. Browse to the workbook and click Open.
  6. Click Update Now and check the slide shows the right numbers.
  7. Repeat for every link. PowerPoint changes them one at a time.

If Edit Links to Files isn’t there, the deck has no linked objects. The data was pasted or embedded, so it never updated in the first place.

Cause 1: The file moved or was renamed

This is the big one. A link is a path like C:\Reports\2026\Q3 model.xlsx. Archive last quarter’s folder, rename the file to “final”, or tidy the shared drive, and that path leads nowhere.

Prevent it: agree on one folder for linked workbooks and don’t rename files once they’re linked. Make a new month’s file by saving a copy, then use Change Source to point the deck at it.

Cause 2: A sheet was renamed or rows were inserted

The link remembers the sheet name and the cell range, such as Summary!A3:D11. Rename the sheet to “Summary v2” and the link can’t find it. Insert two rows above the table and the link still reads A3:D11, so it quietly drops the last two rows.

Prevent it: name the range before you copy it (Formulas, Define Name) or turn it into an Excel table. Named ranges grow with your data.

Cause 3: OneDrive, SharePoint or Teams files

When you copy from a workbook in your synced OneDrive folder, the link can store a path that only exists on your PC. It works perfectly for you. A colleague opening the same deck has a different path, so their links fail.

Prevent it: make links from the same shared location everyone opens, and always test the deck on someone else’s computer before the first send.

Cause 4 and 5: Prompts and update settings

When a deck with links opens, PowerPoint asks whether to update them. Click Cancel and the deck shows the old values. Nothing looks wrong. And if Automatic Update is off for a link, it only refreshes when someone updates it by hand.

Prevent it: tick Automatic Update for each link in Edit Links to Files, and teach the team to click Update Links on decks they trust.

Other things that break links

  • Permissions. The person opening the deck can’t read the folder the workbook sits in.
  • Mac and Windows. Paths are written differently, so a link made on one often fails on the other.
  • Copies of copies. Someone reuses last year’s deck, and it still points at last year’s workbook.
  • Emailed decks. The recipient has the deck but not the workbook, so nothing can update.

When the model changes or the file is replaced

Two more situations cause most of the late night fixes.

Next month’s file. Many teams save a new workbook each period. With Paste Link, every link needs Change Source, one at a time.

The model changed. A column is added or a table is restructured, and links now read the wrong cells. You only find out when someone spots a wrong number.

The two videos above show how an add in handles both: point the whole deck at a new file in one step, and when the model changes, change the workbook and click Refresh once.

Is there a permanent fix?

For a deck you rebuild every month, the fix is to stop relying on Paste Link. Built in links were made for a few objects owned by one person. They weren’t made for a team report that moves through folders and inboxes.

INSYNCR is a PowerPoint add in that links slides to data through a connection in the deck, not a separate link per object. That changes four things:

  • One source switch for the whole deck. Point every chart, table and number at next month’s file in one step.
  • Relative paths. Type just the file name, keep the workbook next to the deck, and the two can move to a new folder together.
  • A clear error. If the workbook is missing, Refresh tells you straight away, instead of quietly showing old numbers.
  • One click refresh. Every linked object updates at once, or on a schedule.

It also reads SQL Server, SharePoint, Salesforce and 20 more sources, so the deck can skip the workbook in the middle. It runs on Windows with PowerPoint 2016 or later, and your data stays on your PC.

Links you repoint once, not one by one

7 day trial, full access, no credit card. Start the trial, or see the plans. The setup steps are in connecting PowerPoint to Excel.

For the built in linking steps, read how to link Excel to PowerPoint so slides update. To compare every way of getting Excel onto a slide, see how to insert Excel into PowerPoint.

Frequently asked questions

Why do my linked Excel charts show old numbers?

PowerPoint couldn’t reach the workbook, so it shows the last picture it saved. Check the path in File, Info, Edit Links to Files. Then use Change Source if the file has moved.

How do I find which file a PowerPoint link points to?

Save the deck and open File, Info, Edit Links to Files. Each link is listed with its full path.

Why do links work for me but not for my colleague?

Usually the link points at a path only you have, such as your OneDrive folder or C drive. Or your colleague can’t read the folder. Relink from a shared location you both use.

How do I stop PowerPoint asking to update links?

If the deck no longer needs live data, break the links in Edit Links to Files, and the objects keep their current values. If it does need live data, keep the prompt. It protects you from decks you don’t trust.

What does Break Link do?

It cuts the connection to the workbook and keeps the current values. You can’t undo it, so save a copy first.