Link Excel to Excel: How to Connect Workbooks and Cells

How-to basics · Updated November 21, 2026

To link cells in Excel, enter a reference such as =Sheet2!A1 in the destination cell; to link to another workbook, open both files, type =, select the source cell, and press Enter. The destination then displays the source cell’s value and can update when that source changes.

What an Excel link does

An Excel link is a formula that refers to a cell or range somewhere else. The referenced cell is the source; the cell containing the formula is the destination. Unlike copying and pasting a value, a formula link keeps the destination connected to the source, so you do not have to repeat the copy whenever the underlying number changes.

There are two common kinds of cell links: a reference between worksheets in one workbook, and an external reference between separate workbook files. In both cases, the destination usually shows the source cell’s current value, while the formula bar shows the reference formula. A link does not automatically make the destination a full copy of the source sheet’s formatting, layout, or formulas.

For example, a summary workbook might show a monthly total kept in a department workbook. The summary can read that cell through a formula, while the department file remains the place where the original figure is maintained. This is useful for reports, budgets, trackers, and other workbooks that share selected data.

Link cells on worksheets in the same workbook

For worksheets in one file, select the destination cell and enter a sheet reference. If the source worksheet is named Sheet2 and the source value is in A1, the formula is =Sheet2!A1. If the worksheet name contains a space, put the name in single quotation marks. With a worksheet named Annual Plan and the source in B4, use ='Annual Plan'!B4.

The reference returns whatever value is in the source cell. For instance, if Annual Plan!B4 contains 1250, the destination displays 1250. To build a link without typing the reference manually:

  1. Select the destination cell and type =.
  2. Click the worksheet tab that contains the source cell.
  3. Select the source cell, then press Enter.

Excel writes the reference for you. You can also type it directly into the formula bar or a cell. To lock the reference before copying the formula to other cells, use dollar signs, as in ='Annual Plan'!$B$4. An absolute reference remains pointed at B4 when the formula is filled elsewhere. A relative reference such as =Sheet2!A1 may shift to another row or column when copied.

Link to a cell in another workbook

When the source is in a different Excel file, an external reference identifies both the workbook and the worksheet. The simplest way to create it in Excel for Microsoft 365 on Windows is to open the source and destination workbooks, select a destination cell, type =, switch to the source workbook, select the source cell, and press Enter. Excel creates the external reference, including the workbook name and location it needs.

For example, if a source cell is B2 on the January worksheet in Sales.xlsx, the formula may appear in a shortened form as ='[Sales.xlsx]January'!B2. The actual reference Excel creates can include a folder path, especially when files are saved in different locations or the source workbook is closed. If B2 contains 1250, the destination displays 1250. The formula remains a link, not an independent copy of that number.

Keep both files saved in a stable location and use Excel to create the reference rather than guessing the full path. A link can still refer to its source after you close the source workbook, but Excel may need to locate that file to refresh the value. If a source file is moved, renamed, or deleted outside Excel, the destination can show a broken-link error or keep an older saved value until you repair the connection.

Use Paste Link instead of typing a formula

Paste Link is a convenient way to link selected cells, especially when creating several references. Copy the source cell or range, select the destination in the same or another workbook, then choose Home > Paste > Paste Special > Paste Link. Depending on the Excel window and the Paste menu layout, Paste Link may appear in the Paste Special options. Excel inserts formulas that refer to the copied source cells.

For a range, make sure the destination area has enough space and is arranged as intended. Paste Link creates a set of cell references; it does not create a live mirror of every feature on the original sheet. For example, it will not make later changes to the source sheet’s column widths or page layout automatically appear in the destination. Check the results after pasting, particularly if the destination range already contains data.

On Windows, Ctrl+C copies the selection and Ctrl+V opens the normal paste action; the Paste Special dialog can also be opened with Ctrl+Alt+V. The Mac uses Command+C and Command+V for copying and pasting. Menu names and dialog presentation can differ slightly on Mac, so use the Paste menu’s link option rather than relying on a Windows-only dialog shortcut.

Choose the right kind of connection

Not every situation calls for a formula link. Decide whether you need a live relationship, a one-time snapshot, or simply a clickable route to another file. These choices behave differently and are not interchangeable:

  • Cell reference: Best when a destination should display a specific source value and reflect later changes when the link updates.
  • Paste Link: Useful for creating references to one cell or a selected block without building each formula by hand.
  • Copy and paste values: Best for a frozen snapshot. It removes the connection, so future source changes will not flow through.
  • Hyperlink: Best when the goal is to open another workbook or a location in it, not to show the source cell’s value as linked data.

A frequent misunderstanding is that linking a cell links an entire workbook or keeps two files perfectly synchronized. A normal cell reference links only the cells included in its formulas. It does not make edits to the destination write back to the source; the relationship is usually one-way, from source to destination. To send changes back, you would need to edit the source directly or create a separate connection in the other direction.

Update links and understand recalculation

When a linked workbook opens, Excel may ask whether to update links to outside files. If you trust the source and want current values, choose the update option; if you do not recognize the source or did not expect the connection, do not approve it until you verify where the link points. The prompt exists because external content can change and because Excel should not silently fetch data from an unfamiliar file.

To inspect external workbook connections in Excel for Microsoft 365 on Windows, use Data > Workbook Links when that command is available for the workbook. It lets you review linked workbooks and actions such as updating or changing a source. Some older workbook formats or Excel builds may show link management in a different place, such as through the Edit Links command. If the source workbook is open and a source cell changes, the linked formula normally recalculates according to the workbook’s calculation settings.

Saving both files after changes makes the relationship easier to manage. A destination workbook can retain the last calculated value even when the source is unavailable, but that displayed value may be out of date. Treat a displayed number as current only after confirming the link points to the intended source and has been updated. Excel for the web can open and edit many workbooks, but external-link management and refresh behavior may differ from desktop Excel; use the desktop app when you need to diagnose or repair a complex external link.

Common link problems and fixes

If a linked value does not appear or update as expected, check the formula and its source before rebuilding the workbook. Common causes include a moved file, a changed worksheet name, an incorrect cell reference, a security prompt that was declined, or a source value that has not been saved. These checks often identify the issue:

  • Old value: Confirm you updated the workbook link and that the source file contains the latest saved value. Also check whether calculation is set to Manual under Formulas > Calculation Options.
  • Broken reference: Use the workbook link controls to locate or change the source file. If the source was renamed or moved, browse to its current location when prompted.
  • Unexpected formula: Select the destination cell and inspect the formula bar. Check the workbook name, worksheet name, and cell address against the source.
  • Wrong result after filling down: Check whether references need dollar signs to keep a row, column, or cell fixed.
  • Link prompt or blocked update: Verify the source workbook and its location before approving updates. Do not enable updates from an unknown file merely to remove the prompt.

For an internal reference, moving or renaming a worksheet through Excel generally allows Excel to adjust references it knows about. External file changes made outside the workbook are more likely to leave a path Excel cannot resolve. Avoid making manual edits to a long external-reference formula unless you understand the path syntax; using the link-management controls or recreating the reference is often safer.

Keep linked workbooks reliable and safe

External links are useful but add dependencies. If a monthly report depends on several staff files, the report may be difficult to refresh when files are renamed, moved, or access permissions change. Put related workbooks in a stable shared folder, use clear file names, and tell collaborators which files supply the data. When sharing a workbook, include the source files or confirm that recipients can access their shared location.

Before sending a workbook outside your team, review its links. A file can contain external references that are not obvious from the visible sheet, and a recipient may see a prompt or stale values if the source is inaccessible. If they only need a final report and do not need updates, consider saving a separate copy with linked formulas replaced by values. Keep the connected original if you still need to maintain the live report.

Do not confuse link safety with whether a formula is correct. A trusted file can still contain incorrect figures, and an unfamiliar source can be unsafe even if the formula looks ordinary. Verify the workbook’s origin, review the source values, and share only the data the recipient needs. If a link is no longer required, remove it deliberately or replace the formula with its current value after preserving any needed original copy.

Alternatives for larger or recurring data transfers

Cell references are a good fit for a few values or a compact summary, but a large recurring import may be easier to manage with Power Query. In Excel for Microsoft 365 on Windows, Power Query tools are available from Data > Get Data; the exact connector depends on where the source data is stored. A query can load and refresh a table of data, rather than requiring a separate cell formula for every item. It is a data-import workflow, not a two-way live link: edits to the loaded output do not automatically update the source file.

For a static handoff, paste values instead of formulas. For a document that should open another file, insert a hyperlink instead of displaying linked data. For a small set of changing figures, formulas are usually simpler. Choose based on whether you need refreshable data, a fixed copy, or navigation; using the simplest method that meets the need reduces broken connections and confusion later.

Frequently Asked Questions

How do I link one Excel sheet to another?
Select the destination cell, type =, select the source worksheet and cell, then press Enter. Excel creates a reference such as =Sheet2!A1. Use single quotation marks around a sheet name that contains spaces.

Can I link two Excel files so changes update automatically?
Yes. Create an external cell reference by opening both workbooks, typing = in the destination, selecting the source cell, and pressing Enter. Updates depend on the source being accessible and the link being refreshed; a destination value is not guaranteed to be current if the source is unavailable.

How do I link a range of cells without writing each formula?
Copy the source range, select the destination, and choose Home > Paste > Paste Special > Paste Link. Check the pasted formulas and destination layout to make sure the references point to the intended cells.

Why is my Excel link not updating?
Check that the source file still exists at the linked location, that you approved an update if Excel prompted you, and that the source changes were saved. Also review Formulas > Calculation Options to see whether calculation is set to Manual.

What is the difference between an Excel link and a hyperlink?
A cell link displays data from a source cell through a formula. A hyperlink is a clickable link that opens a file, web page, or workbook location. Use a formula for connected values and a hyperlink for navigation.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.