To link two Excel spreadsheets, open both workbooks, click the cell that should show the value, type an equal sign, switch to the other workbook, click the source cell, and press Enter. Excel writes a formula such as =[WeeklySales.xlsx]Sheet1!$B$12.
A total in one workbook should always match a number that lives in another file, and copying it by hand every week keeps going wrong. Steps cover Excel for Microsoft 365 and Excel 2016 to 2024 on Windows, plus Excel for the web.
Source and Destination: The Two Files in a Link
Microsoft calls this a workbook link (it used to be called an external reference). The source workbook holds the original value. The destination workbook holds the formula that points to it. In the example used below, a garden center keeps daily figures in WeeklySales.xlsx, and the manager’s Summary.xlsx needs the weekly total from cell B12 of that file.
Decide which file is the source before you start. Values should be typed only there; the destination just reads them.
Link a Cell by Clicking It
- Open both workbooks.
- In Summary.xlsx (the destination), click the cell where the total should appear.
- Type =. To wrap the link in a function, type the start of it instead, such as =SUM(.
- Switch to WeeklySales.xlsx, then click the sheet tab and the cell, or drag across a range of cells.
- Press Enter. Excel returns you to the destination and shows the value.

Excel inserts an absolute reference, with dollar signs, such as $B$12. That is right for a single total. If you plan to copy the formula down a column so each row picks up the matching source row, delete the dollar signs first, or every copy will point at B12.
When you select several source cells without a function, newer Microsoft 365 builds accept the formula with Enter and spill the results as a dynamic array. In older versions, confirm it with Ctrl+Shift+Enter instead. Microsoft’s create workbook links page covers both cases.
Link With Paste Link
Paste Link is handy when you want several neighboring cells at once without building a formula.
- In the source workbook, select the cells and press Ctrl+C (or Home > Clipboard > Copy).
- Switch to the destination workbook and click the cell where the block should start.
- Choose Home > Clipboard > Paste > Paste Link.
Each pasted cell becomes its own link formula, which you can see in the formula bar when you click one.
How to Read a Link Formula
You can also type a link by hand once you know the pattern. The workbook name goes in square brackets, then the sheet name, an exclamation point, and the cell or range:
| Situation | Formula form |
|---|---|
| Source open | =[WeeklySales.xlsx]Sheet1!$B$12 |
| Source closed | =’C:\Reports\[WeeklySales.xlsx]Sheet1′!$B$12 |
| Function over a range | =SUM([WeeklySales.xlsx]Sheet1!B2:B8) |
| Defined name in the source | =SUM(WeeklySales.xlsx!WeekTotal) |
| Another sheet, same workbook | =Sheet2!B12 |
When the source is closed, Excel shows the full folder path, so the same link looks longer the next time you open the destination. That is normal. Single quotes wrap the path and sheet when a name contains spaces or special characters; Excel adds them for you when you build the link by clicking.
Link Sheets Inside the Same Workbook
If your “two spreadsheets” are really two tabs in one file, the steps are the same without switching windows: type =, click the other sheet tab, click the cell, and press Enter. The result looks like =Sheet2!B12, or =’Weekly Sales’!B12 when the sheet name has a space. These links have no security prompt and nothing to break when the file moves, which makes them the simpler choice whenever both tables can live in one workbook.
Link to a Named Range
A defined name is easier to read than a cell address, and it is less likely to point at the wrong cell after someone rearranges the source. In the source, select the cell and give it a name such as WeekTotal (Formulas > Defined Names > Define Name). Then, in the destination, type =, switch to the source, press F3, choose the name, and press Enter.
What Happens When You Open the Destination File
While both files are open, a change in the source shows up in the destination right away. When the source is closed, the destination holds the last values it saw until the links refresh.
Microsoft treats workbook links as potentially unsafe, so when you open a destination file Excel shows a security warning in the Message Bar. Click Enable Content only if you trust the source file. If you skip it, Excel keeps the most recent values and won’t refresh. You may also see a prompt with Update and Don’t Update buttons; Update pulls the latest saved values from the source.

To control this per workbook, Microsoft’s manage workbook links page describes refresh settings of Ask to refresh, Always refresh and Don’t refresh. These are saved with the workbook, so they affect everyone who opens it. There is also a personal setting at File > Options > Advanced, where clearing Ask to update automatic links stops the question on your PC. Excel still tells you about links it can’t reach.
Want the destination to recalculate on its own as data changes? That is a separate topic covered in setting an Excel spreadsheet to update automatically.
Fix, Change or Break a Link
In current Microsoft 365 builds, links are managed from the Workbook Links pane:
- Go to Data > Queries & Connections > Workbook Links.
- Use Refresh all, or the refresh option beside one workbook, to pull in new values.
- Open the More Commands (…) menu beside a source for Open workbook, Change source, Break links or Find next (which jumps to the next cell that uses the link).

The source moved or was renamed: choose Change source and browse to the file’s new location. Every formula pointing at the old file is updated together, which beats editing them one by one.
Warning before you break a link: Break links (or Break all) replaces the link formulas with their current values, and it can’t be undone. Save a backup copy of the destination first. If Excel still reports a link after you break them all, check your defined names, which can hold leftover references to the old file.
Older versions use the Edit Links dialog instead (Data > Queries & Connections > Edit Links), with Update Values, Change Source, Open Source, Break Link and Check Status. Microsoft says the Workbook Links pane replaces it in current builds, and the old command can be added back to a custom ribbon group through Customize the Ribbon if you prefer it (it cannot go in the Queries & Connections group itself).
When a Lookup Beats a Direct Link
A link points to a cell address, not to a value. If someone sorts the source list or inserts a row, B12 may now hold a different store’s figure and the destination will quietly show the wrong number. When you need “the total for the Elm Street store” rather than “whatever is in B12”, use a lookup that finds the row by its label. XLOOKUP in Excel works across workbooks the same way a link does, and VLOOKUP is the option for older versions.
If your real goal is to stack several sheets into one list, linking is the wrong tool. Microsoft’s combine data from multiple sheets page covers Consolidate, the VSTACK function and Power Query for that job.
Linking Workbooks in Excel for the Web
In the browser, both workbooks must be saved in an online location you can reach with your Microsoft 365 account, such as OneDrive or SharePoint, and the link uses the file’s full cloud address. The click method works, but Excel for the web can’t switch you back to the destination tab after you pick the source cell, so switch back yourself. Paste Link results update when you refresh the browser window.
Questions About Linking Excel Workbooks
Does the source workbook have to be open?
No. You need it open (or a known path) to create the link by clicking, but afterward the destination can read the last saved values from the closed file once you enable and refresh the links.
Can one destination pull from many source files?
Yes. Each formula can point at a different workbook, and the Workbook Links pane lists every source. Keep the sources in one shared folder so a move doesn’t break several at once. If you need one sheet as its own source file, saving a single sheet as a new workbook shows how.
Will the people I send the file to see live numbers?
Only if they can reach the source file at the same path or cloud location. Otherwise they see the last saved values, and Excel tells them it can’t update the links. For a copy that travels on its own, break the links in a duplicate file before sending it.
Build one test link between two small files first, close the source, and reopen the destination to see the prompt before you rely on it for real reports.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.