Linking sheets means one sheet pulls live data from another

When you link Excel sheets, you create a formula in one sheet that reads data from a different sheet in the same workbook or even from a different file entirely. The linked sheet updates automatically when the source data changes — you do not have to copy and paste the same numbers over and over. This is useful when you have a master sheet that multiple people edit, or when you want to build summary sheets that pull from detailed working sheets without duplicating the data.

The simplest link is within the same workbook: you type a formula that points to a cell or range in another sheet. A more complex link pulls from a completely separate Excel file on your computer or network, which is useful when different departments maintain their own files but need to feed data into a central report.

Key Takeaways

  • A basic link within the same workbook uses the sheet name and cell reference in a formula, like =Sheet2!A1 or =SummaryData!B5:B10.
  • Links to cells in other files require the full file path in brackets, and the source file must stay in the same location or the link breaks.
  • When you open a workbook with external links, Excel asks whether to update the links — choose "Update" to pull the latest data from the source file.
  • If a link breaks because a file moved or was deleted, you can edit or remove the link through the Edit Links dialog without losing your formulas.

Linking to another sheet in the same workbook

Open the workbook and click the cell where you want the linked data to appear. Type an equals sign to start a formula, then type the sheet name followed by an exclamation mark and the cell reference. For example, if you want to pull the value from cell A1 in a sheet called "Sales Data", type =Sales Data!A1. If the sheet name has a space, Excel requires single quotes around it: ='Sales Data'!A1.

Press Enter and the cell now displays whatever value is in that source cell. If someone changes the number in Sales Data!A1, your linked cell updates when ready. You can also link to a range instead of a single cell — type =Sheet2!A1:A10 to pull an entire column of data, though this works best when you are copying the formula down or across to fill multiple cells.

The fastest way to create a link without typing is to start the formula with an equals sign, then click the sheet tab at the bottom of the screen, click the cell you want to link to, and press Enter. Excel builds the formula for you.

Linking to data in a different Excel file

Click the cell where you want the linked data. Type an equals sign, then the full file path in square brackets, followed by the sheet name and cell reference. The format looks like this: =[C:\Users\YourName\Documents\SalesReport.xlsx]Sheet1!A1. The file path goes in square brackets, and if the sheet name has spaces, use single quotes around it: =[C:\Users\YourName\Documents\SalesReport.xlsx]'Sales Data'!A1.

The source file does not have to be open, but it must exist at that exact location. If you move the file to a different folder or rename it, the link breaks and Excel shows an error. For this reason, external links work best when files stay in a shared network folder that does not change, or when you keep both files in the same project folder on your computer.

You can also use the Paste Link feature if both files are already open. Copy the cells you want from the source file, then in your destination file go to Edit menu, choose Paste Special, and select the Paste Link button. Excel creates the external link formula automatically.

What happens when you open a file with external links

When you open a workbook that contains links to other files, Excel displays a security prompt asking whether to update the links. Click Update if you want the linked cells to pull the latest data from the source files. Click Don't Update if you want to keep the old values temporarily — this is useful if the source file is not available or if you are working offline.

If you click Don't Update, the linked cells show the last value they had before you closed the file. The moment you click Update, Excel opens the source files in the background, reads the current data, and refreshes your linked cells. This happens silently — you do not see the source files open on your screen.

If a source file has moved or been deleted, Excel shows an error in the linked cells and asks you to locate the file. You can browse to the new location and Excel updates the link path. If the file no longer exists, you have the option to break the link, which converts the linked formulas to static values so the cells no longer try to update.

Editing or removing links

To see all the links in your workbook, go to the Data menu and select Edit Links (in older versions of Excel, this may be under the Edit menu). A dialog box shows every external file your workbook is linked to. From here you can update a specific link, change the source file location, or break the link entirely.

Click a link in the list and select Change Source if the file moved to a new location. Browse to the new file and click Open — Excel updates the link path for all formulas that reference that file. Select Break Link if you no longer want the cells to update from that source. Breaking a link converts all the formulas to their current values, so the cells become static numbers that no longer change.

If you want to remove a link but keep the formulas, you have to manually edit each formula. Click the cell, look at the formula bar at the top, and change the external reference to a regular cell reference within your current workbook, or type a static value instead.

Common problems and how to fix them

The most common issue is a broken link caused by a file that moved or was deleted. You see #REF! error in the linked cells. Open the Edit Links dialog, select the broken link, and either browse to the new file location or break the link. If you break it, the cells show the last value they had before the link broke.

Another issue is that links do not update when you expect them to. If the source file is open in another program or on a network drive that is temporarily unavailable, Excel cannot refresh the link. Close the source file, make sure it is saved, and then open your workbook again and choose Update when prompted.

If you are sharing a workbook with others and the file paths are different on each person's computer, external links break for everyone except the person who created them. The solution is to keep both files in the same folder, use relative paths if your version of Excel supports them, or use internal links within a single workbook instead.

When to use links instead of other methods

Links are best when you have a source of truth — one file or sheet that multiple people or reports depend on. If the sales team maintains a master sales file and three different departments need to pull summary numbers from it, links mean each department sees the latest data without asking for updated files.

Do not use links if the source file changes location frequently, if you need to email the workbook to someone else, or if the source file is on someone's personal computer that might not be available. In those cases, copy and paste values instead, or consolidate everything into a single workbook with multiple sheets.

Links also slow down your workbook slightly because Excel has to check the source files every time you open the document. If you have dozens of external links, consider consolidating the data into one file instead.

Frequently Asked Questions

Can I link to a specific range of cells instead of just one cell?

Yes. Use the same format but include the range: =Sheet2!A1:A10 or =[C:\path\file.xlsx]Sheet1!B5:B15. When you paste this formula into multiple cells, it adjusts the range automatically, similar to how a regular formula works.

What if the source file is on a network drive that is not always connected?

The link works when the network drive is available, but when it is not, Excel shows an error. You can still open the workbook — it just displays the last cached value until the network is available again and you update the links.

Does the source file have to stay open for the link to work?

No. Excel reads the source file when you open your workbook or when you manually refresh the links. The source file can be closed the rest of the time. However, if the file is open in another program, Excel may not be able to update until you close it there.

Can I link to a specific named range instead of typing cell references?

Yes. If the source sheet has a named range, you can reference it directly: =Sheet2!SalesTotal or =[C:\path\file.xlsx]Sheet1!QuarterlyRevenue. Named ranges make formulas easier to read and more flexible if the data moves to a different cell.

What is the difference between a link and a VLOOKUP formula?

A link pulls data from a specific cell or range. A VLOOKUP searches for a value in a table and returns a matching result from another column. Use a link when you know exactly which cell contains the data you need. Use VLOOKUP when you need to find data based on a lookup value, like finding a price based on a product code.