Excel links connect cells, sheets, and files so your data stays connected
A link in Excel is a formula that points to another cell, another sheet in the same file, or a completely different file. When you click the link, Excel takes you there. When the data at the other end changes, the link can update automatically. This matters because it lets you build spreadsheets that reference each other without copying the same number into ten different places.
Excel gives you three main types of links to create: links to other cells in the same sheet, links to cells in different sheets, links to cells in other files, and links to websites. Each one uses a slightly different syntax, but they all start the same way — with an equals sign and a cell reference.
Key Takeaways
- A link to another cell in the same sheet starts with = followed by the cell address, like =A1 or =B5.
- A link to a different sheet uses the sheet name followed by an exclamation point and the cell, like =Sheet2!A1.
- A link to another file includes the full file path in square brackets, like =[C:\Documents\Budget.xlsx]Sheet1!A1.
- The HYPERLINK function creates clickable links to websites or files that open when you click them, separate from cell references.
Linking to cells in the same sheet
The simplest link points to another cell on the same sheet. Click the cell where you want the link to appear, type an equals sign, then type or click the cell you want to reference. If you type =A1 in cell B1, cell B1 will now display whatever is in cell A1. If A1 changes, B1 updates automatically.
You can also select the cell instead of typing its address. Click the cell where you want the link, type =, then click the cell you want to reference. Excel fills in the address for you. Press Enter when you are done, and the link is created.
This type of link is useful when you have a summary row or column that pulls numbers from elsewhere on the sheet. For example, if you have monthly sales figures scattered across columns A through L, you can create a total row that links to each month's cell and adds them together using a SUM formula.
Linking to cells in a different sheet
To link to a cell in another sheet within the same file, use the sheet name followed by an exclamation point and the cell address. If you want to link to cell A1 in a sheet named "Sales Data", type =Sales Data!A1. If the sheet name has a space in it, put the name in single quotes: ='Sales Data'!A1.
You can also build this link by clicking. Type =, then click the sheet tab at the bottom of the screen to switch to that sheet, then click the cell you want. Excel automatically fills in the sheet name and cell address in the correct format.
This approach works well when you have multiple sheets that feed into a summary sheet. Your main dashboard can pull totals from individual department sheets, and when each department updates their numbers, the summary updates too.
Linking to cells in a different file
A link to another Excel file includes the file path in square brackets, followed by the sheet name and cell address. The format looks like this: =[C:\Documents\Budget.xlsx]Sheet1!A1. On a Mac, use forward slashes instead of backslashes: =[/Users/name/Documents/Budget.xlsx]Sheet1!A1.
The file path must be exact. If you move the file to a different folder or rename it, the link breaks. Excel will ask if you want to update the link when you open the file — click "Update" to refresh the connection, or "Don't Update" if the file has moved and you need to fix the path first.
This type of link is common when different people maintain different files that need to talk to each other. A manager might have a summary file that pulls data from budget files maintained by each department. As long as all files stay in the same location, the links keep working.
Creating clickable hyperlinks with the HYPERLINK function
The HYPERLINK function creates a clickable link that opens a website, email address, or file when you click it. The syntax is =HYPERLINK(address, display_text). The address is where the link goes, and the display_text is what appears in the cell.
To link to a website, type =HYPERLINK("https://www.example.com", "Click here"). The cell will show "Click here" in blue underlined text, and clicking it opens the website. To link to an email address, use =HYPERLINK("mailto:name@example.com", "Send email"). To link to a file on your computer, use =HYPERLINK("C:\Documents\Report.pdf", "Open report").
HYPERLINK is different from a cell reference link. It does not pull data from the other location — it just opens it. Use HYPERLINK when you want to navigate somewhere, and use a cell reference link when you want to display data from somewhere else.
Fixing broken links and updating file paths
When you move or rename a file that other spreadsheets link to, those links break. Excel shows an error like #REF! in the cell. To fix it, go to the Data menu and look for "Edit Links" or "Links" (the exact name varies by Excel version). A dialog box shows all the links in your file and whether they are working.
Select the broken link and click "Change Source" to navigate to the file's new location. Excel updates the path in all cells that use that link. If you have moved the file permanently, this is faster than retyping every link by hand.
To avoid broken links in the first place, keep linked files in a stable folder structure. If you know other people's spreadsheets link to your file, tell them before you move it, or move it to a location you plan to keep it in long-term.
When to use links instead of copying data
A link is better than copying and pasting when the data changes regularly and you need the most current version everywhere. If you copy a number from one sheet to another, you have to remember to update it manually. A link updates automatically, so you only maintain the data in one place.
Links are also useful when multiple people work on the same project. One person can maintain a master file with the real data, and other people can build their own files that pull from it. Everyone sees the same numbers, and there is no confusion about which version is correct.
However, links can slow down your file if you have hundreds of them pointing to other files. If you are sharing a file with someone who does not have access to the linked files, the links will break on their computer. In those cases, copying the data or saving a version with values only might be better.
Frequently Asked Questions
What is the difference between a link and a formula?
A link is a type of formula. Any formula that starts with = is technically a link — it references something else and displays the result. The term "link" usually refers to formulas that reference cells or files, while "formula" often means calculations like SUM or AVERAGE. In practice, people use the terms interchangeably.
Can I make a link that opens a file instead of showing data?
Yes, use the HYPERLINK function. =HYPERLINK("C:\Documents\Report.pdf", "Open") creates a clickable link that opens the file. This is different from a cell reference link, which displays data from another location.
Why does my link show #REF! error?
The file or cell the link points to no longer exists or has moved. Check that the file is still in the location the link expects, that the sheet name is spelled correctly, and that the cell address is right. Use Edit Links from the Data menu to update the file path if it has moved.
Can I link to a Google Sheet from Excel?
Not directly through a cell reference link. Excel cannot read Google Sheets the way it reads other Excel files. You can read the Google Sheet as an Excel file and link to that, or use HYPERLINK to open the Google Sheet in your browser, but the data will not update automatically between the two.
Do links work if I email the file to someone else?
Links to other files only work if the person receiving the email also has those files in the same location on their computer. Links to cells within the same file always work. If you are sharing a file with someone, either include all linked files or convert the links to values so the data stays put.