What linking an Excel sheet means and when to use it
Linking in Excel means creating a formula in one sheet or workbook that pulls data from another sheet or workbook. Instead of copying and pasting the same numbers over and over, you write a formula that says "go get the value from that other location." When the original data changes, the linked formula updates automatically.
You use linking when you have data in one place that multiple sheets or workbooks need to reference — like a master price list that ten different project sheets pull from, or quarterly numbers in one workbook that a summary workbook needs to display. Linking keeps everything in sync without manual updates.
The alternative is copying data, which breaks the connection. If you copy a number from Sheet A to Sheet B and then Sheet A changes, Sheet B still shows the old number. A link maintains that connection.
Key Takeaways
- A link is a formula that references data in another sheet or workbook, and it updates automatically when the source data changes.
- To link within the same workbook, use a formula like =Sheet2!A1 to reference a cell in another sheet.
- To link between workbooks, use a formula like =[Book2.xlsx]Sheet1!A1, and both files must be in the same folder or the path must be absolute.
- When you move or rename a linked workbook, Excel breaks the link unless you update the file path in the formula.
- Use the Links dialog (Data tab, Edit Links) to manage, update, or break links between workbooks.
Linking to another sheet in the same workbook
The simplest link is between two sheets in one workbook. Click the cell where you want the linked data to appear. Type an equals sign, then click the sheet tab of the source sheet, then click the cell you want to reference. Excel writes the formula for you.
For example, if you want cell B3 in Sheet1 to show the value from cell A5 in Sheet2, click B3 in Sheet1, type =, click the Sheet2 tab, click A5, then press Enter. Excel creates the formula =Sheet2!A5. The exclamation mark separates the sheet name from the cell reference.
If your sheet name has spaces or special characters, Excel adds single quotes around it. A sheet named "Q4 Results" becomes ='Q4 Results'!A5. You can also type the formula directly instead of clicking — both methods work.
Linking between two separate workbooks
Linking between workbooks is more complex because Excel needs to know where the other file is. The safest approach is to keep both workbooks in the same folder, then use the same clicking method: open both files, click the cell in the destination workbook where you want the link, type =, switch to the source workbook, click the cell you want, then press Enter.
Excel writes a formula like =[SourceBook.xlsx]Sheet1!A1. The square brackets hold the filename, the sheet name comes after the closing bracket, and the cell reference comes last. When both files are in the same folder, Excel stores a relative path, which means the link still works if you move both files together to a new folder.
If the files are in different folders, you can still create the link, but you must use an absolute path — the full folder location. A formula might look like ='C:\Users\YourName\Documents\[SourceBook.xlsx]Sheet1!A1'. If you later move the source file, this link breaks and you must update the path manually.
What happens when you move or rename a linked workbook
If you rename or move a workbook that other files link to, Excel cannot find it and the link breaks. The cell shows #REF! error instead of the data. You have two choices: move the source file back to its original location, or update the link formula with the new path.
To update a broken link, go to the Data tab and click Edit Links (in older Excel versions, this is under Data > Links). The Links dialog shows all links in the current workbook. Select the broken link and click Change Source, then navigate to the file's new location and click it. Excel updates all formulas that reference that file.
If you delete the source workbook entirely, the link cannot be repaired. You must either restore the file or replace the linked formulas with static values (copy the cells, then use Paste Special > Values to replace the formulas with their current results).
Managing links with the Edit Links dialog
The Edit Links dialog (Data tab > Edit Links) shows every external link in your workbook — every reference to another file. Each link shows the filename, the sheet it references, and whether it is working or broken.
From this dialog you can update a link (refresh it to pull the latest data from the source), change the source (point it to a different file), or break the link (convert the formulas to static values so they no longer reference the external file). Breaking a link is useful when you want to send a workbook to someone else without requiring them to have the source file.
You can also set whether links update automatically when you open the workbook or only when you manually refresh them. By default, Excel asks you each time you open a file with external links. Click Enable to update them, or Don't Enable to keep the old values.
Linking to a range of cells instead of a single cell
You can link to a range of cells the same way you link to a single cell. Click the destination cell, type =, click the source sheet or workbook, then click and drag to select the range you want. Excel creates a formula that references the entire range.
For example, =Sheet2!A1:A10 links to cells A1 through A10 in Sheet2. If you paste this formula into multiple cells, it adjusts the reference for each row — the same way a normal formula does. This is useful when you want to pull an entire table or list from another sheet and have it update automatically.
When links slow down your workbook or cause problems
External links — links to other workbooks — can slow down your file if there are many of them or if the source files are large. Every time you open the workbook, Excel tries to update all external links, which takes time. If the source files are on a network drive or cloud storage, the delay can be noticeable.
Links also create a dependency: if someone opens your file without the source files present, the links break and show errors. If you plan to share a workbook with others, consider whether they will have access to the source files. If not, convert the links to values using the Edit Links dialog.
Internal links — links between sheets in the same workbook — do not have these problems. They are fast and portable because the data stays in one file.
Frequently Asked Questions
Can I link to a specific named range instead of a cell address?
Yes. If the source sheet has a named range (created via the Name Box or Formulas tab), you can reference it by name. For example, =Sheet2!PriceList links to a named range called PriceList in Sheet2. This makes formulas easier to read and more flexible if the range moves.
What does #REF! error mean in a linked cell?
It means the link is broken — Excel cannot find the source cell or workbook. Check whether the source file has been moved, renamed, or deleted. Use Edit Links to update the path or break the link and replace it with a static value.
Can I link to a cell in a workbook that is not open?
Yes. You can type the formula directly with the full file path, or open both workbooks and use the clicking method. Excel stores the link even if the source file is closed. When you open the destination file later, Excel will try to update the link from the closed source file.
How do I convert a linked formula to a static value?
Select the cells with linked formulas, copy them, then use Paste Special (Ctrl+Shift+V) and choose Values. This replaces the formulas with their current results. The link is broken, but the data remains.
Can I link to a cell in a Google Sheet or other cloud file?
Excel cannot directly link to Google Sheets. You can download the Google Sheet as an Excel file and link to that, but the link will not update when the Google Sheet changes. For live updates, you would need to use Power Query or other data import tools instead.