What an external link is and why Excel flags it

An external link in Excel is a formula or reference that pulls data from a different workbook — one that is not currently open. When you open a file containing external links, Excel usually shows a security warning asking whether you want to update those links. The warning exists because external links can break if the source file moves, gets deleted, or changes structure.

External links appear most often when someone copies a formula from one workbook into another, or when a spreadsheet references a shared file on a network drive. They look like this in the formula bar: =[C:\Users\Documents\Sales_Data.xlsx]Sheet1!A1 or ='\\server\shared\Budget.xlsx'!B5. The file path in square brackets is what makes it external.

Finding these links matters because they can silently break your calculations if the source file moves or if you share the spreadsheet with someone who does not have access to that file path. Excel will not recalculate the values, leaving you with stale data you might not notice.

Key Takeaways

  • External links appear in the Edit Links dialog, which you reach through the Data tab on the ribbon — this is the fastest way to see all of them at once.
  • You can also search the spreadsheet manually by using Find & Replace to search for the opening bracket character [ that marks external link syntax.
  • Breaking a link removes the formula connection but keeps the last calculated value in place, so your numbers stay visible even after the source file is gone.
  • Converting an external link to a static value (not a formula) is useful when you want to lock in a number and stop depending on another file.

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. Open your spreadsheet, then click the Data tab on the ribbon at the top. Look for a button labeled Edit Links — it usually sits near the right side of the ribbon, sometimes grouped with other data tools. If you do not see it, your workbook contains no external links.

When you click Edit Links, a window opens showing every external link in the file. Each row lists the source file path, the type of link, and the last update time. From here you can see exactly which files your spreadsheet depends on. If a file path shows a location that no longer exists or a file you no longer have access to, that link is broken and needs attention.

The dialog gives you three options for each link: Update Values (recalculate using the current source file), Change Source (point the link to a different file), or Break Link (remove the connection and keep only the last value). Most of the time, if a source file has moved or been deleted, you will want to break the link rather than hunt for the file.

Searching for external links using Find & Replace

If the Edit Links button does not appear or you want to see the actual formulas containing external references, you can search for them manually. Press Ctrl+H to open Find & Replace. In the Find field, type a single opening bracket: [. Leave the Replace field empty and click Find All.

Excel will highlight every cell containing an external link reference. This method shows you not just that a link exists, but which cell contains it and what the formula looks like. You can then click on each result to jump to that cell and see the full formula in the formula bar at the top.

This approach takes longer if you have many links, but it gives you more control and lets you see the exact syntax. It is also useful if you suspect a link exists but the Edit Links dialog is not showing it for some reason.

Breaking an external link to remove the file dependency

To break a link, open the Edit Links dialog again (Data tab, then Edit Links). Select the link you want to remove and click the Break Link button. Excel will ask you to confirm — click OK. The link is now severed, and the cell will keep whatever value was last calculated, but it will no longer update if the source file changes.

Breaking a link is safe. Your numbers do not disappear — they just become static values instead of formulas. If the cell showed 1,500 before you broke the link, it will still show 1,500 afterward. The difference is that if someone updates the source file, your spreadsheet will not reflect those changes anymore.

Breaking links is the right choice when you are sharing a file with others and do not want them to need access to files on your computer, or when the source file no longer exists and you want to stop seeing error messages.

Converting an external link to a value without breaking it

Sometimes you want to keep the current number but remove the formula dependency without formally breaking the link. You can do this by copying the cell, then using Paste Special to paste only the value back into the same cell. Select the cell containing the external link, press Ctrl+C to copy it, then press Ctrl+Shift+V to open Paste Special.

In the Paste Special dialog, click the Values option (or Values Only depending on your Excel version) and click OK. The formula is now gone and replaced with just the number. This approach is cleaner than breaking the link because it removes the external reference entirely rather than leaving a broken link behind.

Preventing external links when copying formulas between files

External links often appear by accident when someone copies a formula from one workbook and pastes it into another. To avoid this, use Paste Special instead of regular paste. Copy the cell as normal with Ctrl+C, then in the destination workbook press Ctrl+Shift+V and choose Formulas (not Values). This pastes the formula structure without the file reference.

If the formula references cells in the source workbook, you will need to manually adjust those references to point to cells in your current workbook instead. It takes a few extra seconds but prevents the external link from being created in the first place.

Another prevention method: before copying, check whether the formula you are copying contains cell references from a different sheet or workbook. If it does, rewrite the formula to reference only cells in the current file, or plan to convert it to a value after pasting.

What happens when an external link source file is missing

If you open a spreadsheet that contains external links and the source file is no longer available, Excel will show a security warning at the top of the window. You can choose to update the links (which will fail because the file is missing) or not update them. If you choose not to update, the cells will display the last known value, which may be outdated.

The Edit Links dialog will still show the missing file path, and you will see a status of "Source not found" or similar. From here you can break the link to clean up the file, or you can click Change Source to point it to a new location if you have moved the file.

If you do not know where the source file is and do not need the data anymore, breaking the link is the simplest solution. Your spreadsheet will continue to work with the last calculated values in place.

Frequently Asked Questions

Can I see external links without opening the Edit Links dialog?

Yes, by using Find & Replace to search for the [ character. This shows you the exact cells and formulas containing external references. The Edit Links dialog is faster if you just want a list, but Find & Replace is better if you want to see the actual syntax and location of each link.

What is the difference between breaking a link and converting to a value?

Breaking a link leaves the external reference in place but disconnected, while converting to a value removes the formula entirely and replaces it with just the number. Converting to a value is cleaner because it fully removes the dependency. Breaking a link is faster if you have many links to remove at once.

Will my numbers change if I break an external link?

No. The cell keeps whatever value was last calculated before you broke the link. Breaking a link only stops future updates from the source file — it does not erase or change the current number.

Why does Excel ask about updating links when I open a file?

Excel is asking whether you want it to recalculate formulas that depend on another file. If you click Update, it tries to open the source file and refresh the values. If you click Do Not Update, it uses the last known values. The warning exists because external links can be a security risk if the source file comes from an untrusted location.

Can I fix a broken external link if I find the source file later?

Yes. Open the Edit Links dialog, select the broken link, click Change Source, and navigate to the file. Excel will reconnect the link and recalculate the values. You can also manually rewrite the formula to point to the correct file path if you prefer.