What external links are and why they matter

An external link in Excel is a formula or reference that pulls data from a different workbook — one that is not the file you are currently working in. When you open a spreadsheet that contains external links, Excel either updates those links automatically or asks you whether to update them. If the source file moves, gets deleted, or changes location, those links break and your data stops updating.

Finding external links matters because broken links can silently feed you outdated numbers, and you may not notice until the damage is done. If you are inheriting a spreadsheet from someone else or preparing a file to send to another person, knowing what external links exist helps you decide whether to keep them, replace them with static values, or fix them before sharing.

Key Takeaways

  • The Edit Links dialog (Windows: Data tab, Edit Links button; Mac: File menu, Edit Links) shows every external link in your workbook at once.
  • You can break a link, update it to a new file location, or convert it to values so the spreadsheet no longer depends on another file.
  • The Find & Replace tool can search for formulas containing specific file names or the bracket syntax that marks external references.
  • External links appear in formulas as file paths in square brackets, like [OtherFile.xlsx]Sheet1!A1, and you can spot them by reading formulas cell by cell.

Using the Edit Links dialog to see all external links at once

The fastest way to find every external link in your workbook is through the Edit Links dialog. On Windows, open the Data tab in the ribbon and click the Edit Links button — it appears in the Queries & Connections group. On Mac, go to the File menu and select Edit Links. A window opens showing every external link in the workbook, the file path it points to, and whether it is set to update automatically or manually.

From this dialog you can see the status of each link — whether it is working, broken, or has not been updated yet. You can also update a single link to point to a new file location by clicking Change Source, break the link entirely by clicking Break Link, or update all links at once by clicking Update Values. Breaking a link converts all formulas that reference that external file into their current values, so the spreadsheet no longer depends on that file existing.

Finding external links by searching for file path syntax

If the Edit Links dialog is empty but you suspect external links exist, they may be hidden in formulas that are not updating. You can search for them using Find & Replace. Press Ctrl+H (Windows) or Cmd+H (Mac) to open Find & Replace, then search for the opening bracket character [ in the "Find what" field. Click Options to expand the dialog, then check "Search in formulas" so Excel looks inside formulas rather than just displayed values.

External links always use the syntax [FileName.xlsx]SheetName!CellReference, so searching for the opening bracket will find them. When Find & Replace highlights a cell, look at the formula bar to see the full reference. If it contains a file name in brackets, that is an external link. You can also search for a specific file name if you know which workbook the links point to — search for the file name in brackets, like [Budget2023.xlsx].

Reading formulas to spot external links manually

You can also find external links by reading formulas directly. Click on any cell that might contain a formula and look at the formula bar at the top of the screen. If the formula contains a file path in square brackets, it is an external link. For example, =SUM([SalesData.xlsx]Sheet1!A1:A10) pulls data from a file called SalesData.xlsx. The part in brackets is the external reference.

This method works best when you know roughly where the external links are — for instance, if you know a particular column contains summary numbers that come from another file. If you need to check an entire workbook, use Find & Replace instead, because reading every formula in a large spreadsheet is slow and straightforward to miss.

Deciding what to do with external links you find

Once you have found an external link, you have three main choices. First, you can leave it as is if the source file is stable and you want the data to update automatically whenever the source changes. Second, you can break the link and convert the formulas to their current values if you want to keep the numbers but no longer need them to update. Third, you can update the link to point to a new file location if the source file has moved.

Before you break or change a link, make sure you understand what data depends on it. If a link feeds into calculations that other sheets rely on, breaking it without replacing the values will cause those calculations to fail. The safest approach is to break the link only after confirming that the current values are correct and that no other part of the workbook depends on the link updating in the future.

Preventing external links when building new spreadsheets

If you are building a spreadsheet from scratch and want to avoid external links, copy data from other files and paste it as values rather than formulas. When you paste as values, Excel stores only the numbers or text, not the formula that fetches them from another file. You can do this by right-clicking after pasting, selecting Paste Special, and choosing Values Only.

If you do need live links to another file, keep the source file in a stable location and document where it is so anyone who uses your spreadsheet knows where the data comes from. If you are sending the spreadsheet to someone else, either break the links before sending it or include the source file and clear instructions on where to store both files so the links do not break.

Frequently Asked Questions

What happens if I open a file with broken external links?

Excel will ask whether you want to update the links. If you click No, the cells that depend on those links will show the last value they had before the link broke, which may be outdated. If you click Yes, Excel will try to find the source file and update the links. If it cannot find the file, the links remain broken.

Can I find external links that point to closed files?

Yes. The Edit Links dialog shows external links even if the source file is not open or no longer exists. This is how you discover broken links — they appear in the dialog with a status showing they cannot be updated. You can then decide whether to break the link, search for the file in a new location, or replace it with a different source.

Does Excel warn me when a file contains external links?

Excel shows a notification bar at the top of the spreadsheet asking whether to update external links when you open the file. However, if you click Disable or ignore the prompt, you may not see it again. The Edit Links dialog is the only way to be certain what external links exist in a file.

What is the difference between breaking a link and deleting a formula?

Breaking a link converts the formula to its current value, so the cell still shows a number but no longer updates. Deleting a formula removes the cell content entirely. Use Break Link if you want to keep the data but stop depending on another file. Use Delete if you want to remove the cell content.

Can I change an external link to point to a different file?

Yes. Open the Edit Links dialog, select the link you want to change, click Change Source, and navigate to the new file. Excel will update all formulas that reference the old file to reference the new one instead, as long as the sheet names and cell references still exist in the new file.