How to Link a Sheet in Excel: Connecting Data Across Worksheets and Workbooks
Linking sheets in Excel is one of those skills that quietly transforms how you work with data. Instead of copying and pasting the same numbers across multiple tabs or files, you create a live connection — change the source, and the linked cell updates automatically. Here's how it works, what affects it, and where your own setup matters most.
What Does "Linking a Sheet" Actually Mean?
In Excel, linking means referencing a cell or range from one worksheet inside another worksheet or workbook. The cell that contains the link displays the value from the source, but the data lives in the original location. This is different from copying — a link stays connected; a copy doesn't.
There are two main types of links:
- Internal links — connecting cells between sheets within the same workbook
- External links — connecting cells between two separate Excel files (workbooks)
Both use the same core formula logic, just with slightly different syntax.
How to Link Between Sheets in the Same Workbook
This is the most common scenario. Say you have a summary sheet and several department sheets — you want totals from each department to feed into the summary automatically.
Basic syntax:
=SheetName!CellReference Example: To pull the value from cell B2 on a sheet called "Sales":
=Sales!B2 If your sheet name contains spaces, wrap it in single quotes:
='Q1 Sales'!B2 To create this link without typing:
- Click the cell where you want the linked value to appear
- Type
= - Click the tab of the source sheet
- Click the source cell
- Press Enter
Excel writes the formula for you. This point-and-click method is faster and reduces typos — especially when sheet names are long or complex.
How to Link Between Separate Workbooks
External links follow a similar pattern but include the workbook filename and file path.
Basic syntax:
=[WorkbookName.xlsx]SheetName!CellReference Example:
=[Budget2024.xlsx]Expenses!C5 When the source workbook is closed, Excel expands this to include the full file path:
='C:UsersYourNameDocuments[Budget2024.xlsx]Expenses'!C5 This full-path version is what Excel stores internally. If the source file moves or is renamed, the link breaks — which is one of the most common pain points with external links.
Linking a Range, Not Just One Cell
You're not limited to single cells. You can link an entire range and use it in a formula:
=SUM(Sales!B2:B10) Or pull a range into another sheet using array behavior (especially in Excel 365, where dynamic arrays let a single formula spill results across multiple cells automatically).
Key Variables That Affect How Linking Works 🔗
Linking in Excel isn't one-size-fits-all. Several factors shape how reliable and practical your links will be:
| Variable | Why It Matters |
|---|---|
| Excel version | Excel 365 supports dynamic arrays and spill ranges; older versions don't |
| File format | .xlsx vs .xlsb vs .xls affects compatibility with some link features |
| File location | Local vs. network drive vs. SharePoint/OneDrive changes how paths resolve |
| Source file status | Open vs. closed workbooks behave differently with external links |
| Named ranges | Using named ranges instead of cell addresses makes links more resilient to row/column insertions |
What Can Go Wrong — and Why
Broken links are the most common issue. They happen when:
- A source file is renamed, moved, or deleted
- A sheet tab is renamed after the link is created
- The workbook is shared with someone who doesn't have access to the linked file path
Excel flags broken links with a #REF! error. You can manage and update them via Data → Edit Links (or Queries & Connections in newer versions), where you can see all external references, update their source paths, or break them entirely.
Circular references are another issue — when a linked cell eventually points back to itself, either directly or through a chain. Excel will warn you and can calculate them iteratively if you enable that setting, but it's usually a signal to rethink the structure.
Internal vs. External Links: A Practical Comparison
| Feature | Internal (Same Workbook) | External (Separate Workbooks) |
|---|---|---|
| Updates automatically | ✅ Always | ✅ When source is open; prompts when closed |
| Risk of breaking | Low | Higher — path/name changes break links |
| Performance impact | Minimal | Can slow large workbooks with many external refs |
| Portability | High | Low — sharing requires sharing all linked files |
| Best for | Dashboards, summaries, multi-tab models | Cross-team data, separate reporting files |
Named Ranges Make Links More Robust
Instead of linking to =Sales!B2, you can define a named range (via Formulas → Define Name) and reference it by name:
=TotalSalesQ1 Named ranges survive row insertions and are easier to audit. If the data moves within the source sheet, the name follows it — the link doesn't break.
When You're on SharePoint or OneDrive ☁️
Cloud-hosted workbooks introduce additional considerations. Links between files stored on SharePoint or OneDrive can behave differently depending on whether you're using Excel for the web, the desktop app, or a mix of both. Co-authoring and sync states can affect whether linked data refreshes as expected. Some organizations also restrict external link updates through security or IT policy settings.
The Part That Depends on Your Setup
How linking fits into your workflow depends on factors only you can evaluate — how many people share the files, where those files live, which version of Excel everyone is using, and how often the source data changes. A simple two-sheet summary in a single workbook is almost always straightforward. A network of linked workbooks shared across a team introduces variables around file access, update timing, and broken-path risk that look very different depending on your environment.