How to spot a cell that links to another file

An external link in Excel is a formula or reference that pulls data from a file outside the spreadsheet you're looking at. The easiest way to find one is to look for a cell with a formula that starts with a bracket — like =[C:\Users\Documents\Sales.xlsx]Sheet1!A1 — or a formula that references another workbook by name. When you open a spreadsheet with external links, Excel usually shows a yellow notification bar asking whether you want to update the links; that bar itself is a sign that external links exist in the file.

If you don't see that notification bar, the links may have been broken or the file may have been saved without updating them. You can still find them by searching through the formulas themselves or by using Excel's built-in link manager, which shows you every external reference in the spreadsheet at once.

Key Takeaways

  • External links appear in formulas as references to other Excel files, usually shown in brackets with a file path or workbook name.
  • Excel displays a yellow notification bar when you open a file with external links, asking whether to update them.
  • The Edit Links dialog (found under Data or Queries & Connections, depending on your Excel version) shows all external links in one place.
  • A broken external link will show an error like #REF! in the cell, meaning the file it points to no longer exists or has moved.
  • You can replace an external link with a static value, delete it, or update it to point to a new file location.

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

The fastest way to find every external link in your spreadsheet is to open the Edit Links dialog. In Excel for Windows, go to the Data tab on the ribbon, then look for a button called Edit Links (in some versions it may be under Queries & Connections or labeled Links). Click it, and a window will open showing every external link in the file — the file path, the status of each link, and when it was last updated.

In Excel for Mac, the path is slightly different: go to Data, then Edit Links. If you don't see an Edit Links button, it means your spreadsheet has no external links, or they have already been removed.

The dialog shows you the source file name, the type of link (usually "Excel Worksheet"), and whether the link is working or broken. If a link is broken, the status column will say "Error" or "Source not found." From this dialog you can update a link to point to a new file, break the link and replace it with values, or delete it entirely.

Searching for formulas that contain external file references

If the Edit Links dialog is empty but you suspect external links exist, you can search for them manually using Find & Replace. Press Ctrl+H (Windows) or Cmd+H (Mac) to open Find & Replace, then search for the opening bracket character [. This will find any cell containing a formula that references another file, since external links always use brackets around the file path.

When you find a cell with a bracket, click on it to see the full formula in the formula bar at the top of the screen. The formula will show you the exact file it's pulling from and which cell or range it's referencing. Write down the file path or take a screenshot so you know which external files your spreadsheet depends on.

You can also use Find & Replace to search for specific file names if you know which external file you're looking for. For example, if you know the spreadsheet links to a file called "Budget.xlsx", search for "Budget" and Excel will highlight every cell that references it.

Understanding what #REF! errors tell you about broken links

When a cell displays #REF! as its value, it usually means the external link it depends on is broken. This happens when the file it was supposed to link to has been moved, deleted, or renamed. The formula itself is still there — you can see it in the formula bar — but Excel cannot find the file to pull data from, so it shows an error instead.

To fix a #REF! error, you have three options: update the link to point to the file's new location (if you know where it moved), replace the formula with a static value (if you no longer need the link to update automatically), or delete the formula entirely. Open the Edit Links dialog to see which file is missing, then decide whether you need that data or can work without it.

The difference between a link and a value in a cell

A cell containing a link will always have a formula — you'll see an equals sign at the start when you click on it. A cell containing only a value (a number, date, or text) will not have a formula. If you see = in the formula bar, the cell is pulling data from somewhere else. If you don't see an equals sign, the cell contains only what you see on screen.

External links are always formulas, so if you're looking for them, focus on cells that start with =. Static values — numbers you typed in yourself — are not links and won't change if an external file is updated or moved.

When to break or update an external link

Break an external link if the file it points to no longer exists and you don't need the data to update anymore. You can replace the link with a static value — Excel will ask if you want to convert the formula to its current value, which freezes the number in place. This is useful if you've already copied the data you need and don't want the spreadsheet to depend on another file.

Update a link if the external file has moved to a new location but you still need it to update automatically. Open the Edit Links dialog, select the link you want to fix, click Change Source, and navigate to the file's new location. Excel will then update all formulas that reference that file.

Leave a link alone if the external file is still in its original location and you want the data to stay current. Every time you open the spreadsheet, Excel will ask whether to update the links — answering "Yes" will pull the latest data from the external file.

Why external links can slow down your spreadsheet

A spreadsheet with many external links takes longer to open because Excel has to locate and read each external file before it can display the data. If the external files are on a network drive or cloud storage, the delay can be noticeable. If an external file is on a computer that's turned off or a network that's unavailable, Excel may freeze while trying to find it.

If you notice your spreadsheet opening slowly, check the Edit Links dialog to see how many external links it contains. If there are many, consider whether you actually need all of them. Removing links you no longer use will speed up the file and make it less dependent on other files being available.

Frequently Asked Questions

What does the yellow notification bar mean when I open Excel?

The yellow bar is Excel telling you the file contains external links and asking whether you want to update them. Click "Enable" or "Update" to pull the latest data from the external files, or click "Don't Update" to keep the old values. You can open the file either way — updating just refreshes the data.

Can I find external links if they're hidden in named ranges or tables?

Yes. External links can be embedded in named ranges, tables, or even chart data sources. The Edit Links dialog will still show them because it searches the entire file, not just visible cells. If you find a link in the dialog but can't locate it by searching cells, it's likely in a named range or chart.

What happens if I delete an external link without replacing it with a value?

The cell will show a #REF! error because the formula no longer has a source to pull from. If you want to keep the last value that was in the cell, use "Break Link" instead of deleting the formula — this converts the formula to a static value before removing the link.

Can external links point to Google Sheets or other non-Excel files?

Excel can link to other Excel files and to some text or CSV files, but not directly to Google Sheets or other cloud-based spreadsheets. If you need data from Google Sheets, you'll have to read it as an Excel file first, then create the link to that downloaded file.

How do I know if an external link is still working?

Open the Edit Links dialog and look at the status column. If it says "OK" or shows a date, the link is working. If it says "Error" or "Source not found," the file is missing or the path is broken. You can also click on a cell with an external link and press F9 to recalculate — if it updates without error, the link works.