What linking a sheet means and when you need it

Linking a sheet means creating a formula in one Excel sheet that pulls data from another sheet — either in the same workbook or in a completely different file. When you link sheets, the data updates automatically: if the source sheet changes, the linked sheet reflects that change without you having to copy and paste anything.

You need linking when you have data spread across multiple sheets and want one place to see the combined picture. A common example: you have sales data for January, February, and March in three separate sheets, and you want a summary sheet that adds them all together. Another example: your manager maintains a master price list in one file, and you need those prices to appear in your own workbook — linking means you always see the current prices without asking for an updated file.

Linking is different from straightforward copying data. When you copy, you get a snapshot at that moment. When you link, you get a live connection that updates whenever the source changes.

Key Takeaways

  • Link to another sheet in the same workbook by typing a formula that starts with the sheet name, an exclamation point, and the cell reference — for example, =January!B5 pulls the value from cell B5 in the January sheet.
  • Link to a sheet in a different workbook by including the file path in brackets before the sheet name — for example, =[C:\Sales\2024.xlsx]Summary!B5 pulls from the Summary sheet in the 2024.xlsx file.
  • When you move or rename a linked file, Excel will ask you to locate it the next time you open the workbook; you can update the link path in the Edit Links dialog to fix the connection.
  • Linked formulas update automatically when the source data changes, but you can also press Ctrl+Shift+F9 to force an when ready refresh if the change does not appear right away.
  • If you want to break a link and keep only the values, use Paste Special with the Values option after copying the linked cells.

Linking to another sheet in the same workbook

The simplest link is between two sheets in the file you are already working in. Open the workbook with both sheets. Click on the cell where you want the linked data to appear. Type an equals sign to start a formula, then type the sheet name, an exclamation point, and the cell address you want to pull from.

For example, if you want to pull the value from cell B5 in a sheet named "January", type =January!B5 and press Enter. Excel will display the value from that cell. If the sheet name has a space in it — like "Q1 Sales" — wrap the name in single quotes: ='Q1 Sales'!B5.

You can also build the formula by clicking. Type the equals sign, then click on the sheet tab at the bottom of the screen to switch to the other sheet. Click on the cell you want to link to. Excel will automatically write the formula for you, and you can press Enter to confirm it.

Linking to a sheet in a different workbook

Linking to another file is more complex because Excel needs to know where that file lives on your computer. The formula includes the file path in square brackets, the sheet name, and the cell address.

The structure looks like this: =[C:\Users\YourName\Documents\Sales.xlsx]Summary!B5. The path goes in square brackets, followed by the sheet name and cell address. If the file path has spaces in it, the whole path stays in the brackets — you do not need extra quotes around it.

The easiest way to create this formula without typing the whole path is to open both files side by side. In your current workbook, type an equals sign. Then click on the other workbook's window to switch to it, and click on the cell you want to link to. Excel will write the full path formula for you. Press Enter to confirm.

Keep in mind that if you move the linked file to a different folder or rename it, the link will break. Excel will warn you when you open the workbook and ask you to locate the file.

Updating and fixing broken links

When the source data changes, linked cells update automatically the next time you open the workbook or when you press Ctrl+Shift+F9 to refresh. If you change data in the source sheet while both files are open, the linked cells may not update when ready — pressing Ctrl+Shift+F9 forces an when ready refresh.

If you move or rename a linked file, Excel displays a dialog when you open the workbook asking you to update the link. Click "Edit Links" in the dialog, select the broken link, and click "Change Source" to navigate to the file's new location. Excel will then restore the connection.

You can also manage links manually by going to the Data tab, clicking "Edit Links" (in newer versions of Excel, this may be under Data > Queries & Connections > Edit Links), and seeing all the external files your workbook is linked to. From here you can update paths, break links, or change which cells are being pulled.

Converting linked formulas to values

Sometimes you want to keep the data but remove the link — for example, if you are sending the file to someone else and do not want them to see or update the source file. To do this, copy the cells with linked formulas, then use Paste Special to paste only the values.

Select the cells containing the linked formulas and press Ctrl+C to copy. Right-click and choose "Paste Special", or press Ctrl+Shift+V. In the dialog, click the "Values" option and click OK. The cells will now contain only the numbers or text, not the formulas, and they will no longer update if the source changes.

Common problems and how to avoid them

The most common issue is a broken link caused by moving or renaming the source file. To avoid this, keep linked files in a stable location and tell anyone who might move them that the file is being referenced elsewhere. If you must move a file, update the link path when ready using the Edit Links dialog.

Another issue is circular references — when Sheet A links to Sheet B, and Sheet B links back to Sheet A. Excel will warn you with an error message. The solution is to redesign your sheets so data flows in one direction: one sheet is the source, and others pull from it, but nothing pulls back.

If a linked cell shows an error like #REF!, it usually means the source cell was deleted or the sheet was renamed. Check the source file to confirm the cell still exists, and update the formula if needed. You can also use Edit Links to see which cells are causing problems.

When to link versus when to use other methods

Linking works well when you have a stable source file that multiple people reference, or when you want live data without manual updates. However, if the source file moves frequently or if you are sharing the workbook with people who do not have access to the source file, linking creates problems.

For one-time data consolidation, copying and pasting may be simpler than setting up links. For very large datasets, linking can slow down your workbook because Excel recalculates all linked formulas whenever you open the file. In those cases, consider importing the data instead of linking to it.

If you need data from a database or a web source rather than another Excel file, linking is not the right tool — you would use Power Query or a data connection instead. But for pulling data between Excel files or sheets, linking is the standard approach.

Frequently Asked Questions

What happens if I open a workbook with links but the source file is not available?

Excel will display a dialog asking whether you want to update the links. If you click "Don't Update", the linked cells will show the last value they had before the file was closed, but they will not refresh. If you click "Update", Excel will search for the file and ask you to locate it if it cannot find it automatically.

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

You can reference a range in a formula — for example, =SUM(January!B5:B10) adds up cells B5 through B10 in the January sheet. You can use any Excel function with a linked range, just as you would with cells in the same sheet.

Does linking work if the source file is on a shared network drive?

Yes, but the path will be longer and include the network location. For example: =[\\ServerName\Folder\Sales.xlsx]Summary!B5. Make sure everyone who opens the file has permission to access that network location, or the link will break for them.

If I email my workbook to someone else, will the links still work?

Only if the source file is also sent and placed in the same folder structure on their computer. If the source file is not available, the links will show the last cached values but will not update. For sharing, it is usually better to convert links to values first.

Can I link to a cell in a Google Sheet or another cloud file?

Excel cannot directly link to Google Sheets or most cloud files. You would need to read the file to your computer first, or use Power Query to import the data instead of creating a link.