Yes. In Excel for Microsoft 365, you can link one workbook to another with an external-reference formula, so a cell in the destination workbook displays a value from the source workbook. For a quick link, type =, select the source cell in the other workbook, and press Enter; Excel creates the reference for you.
What It Means to Link Two Workbooks
People often use spreadsheet to mean either an Excel file or a worksheet tab. A workbook is the file, such as Sales.xlsx; a worksheet is one of its tabs, such as January. A link between two workbooks connects a cell or range in one file to information in another. It is different from copying and pasting a value, because a formula link can display an updated source value when Excel recalculates or updates the connection.
A basic external reference points to a workbook, a sheet, and a cell. If the source workbook is open while you create the reference, Excel usually inserts a formula in this form:
Assuming Sales.xlsx is open, its January sheet has 1,250 in B2, and you are entering a link in a destination cell, use ='[Sales.xlsx]January'!$B$2. The destination displays 1,250. If the source value changes to 1,400 and the link updates, the destination can show 1,400.
The dollar signs make the cell reference absolute: copying the formula elsewhere will keep it pointed at B2. Excel may add a folder path to the reference when the source workbook is closed. The exact text can vary with the workbook’s location and name, so it is usually easiest to let Excel create the reference rather than typing a long path by hand.
How to Create a Link Between Excel Files
For a simple one-cell link in Excel for Microsoft 365 on Windows, open both workbooks and follow these steps:
- In the destination workbook, select the cell where you want the linked value to appear.
- Type
=to begin a formula, then switch to the source workbook and select the cell you want to reference. - Press Enter. Excel returns to the destination workbook and completes the external-reference formula.
- Save both workbooks. Keeping them in a stable folder makes the connection easier to maintain.
You can also type the reference directly if you know the source workbook, worksheet, and cell. Sheet names or file names containing spaces are handled by Excel’s quotation marks in the reference; selecting a cell is less error-prone. To link a cell on a different worksheet in the same workbook, use the same selection method. That creates a worksheet reference, not a link between files.
On Mac, the formula-building process is much the same: start a formula in the destination, select the source cell, and confirm it. Ribbon placement and link-management commands can vary by Excel build. In Excel for the web, workbook-link capabilities may differ from the Windows desktop app, so use desktop Excel if you cannot find a management command or need to repair a link.
Linking a Range or Calculating Across Workbooks
A link does not have to show just one cell. You can use a formula to calculate using a range in another workbook. For example, suppose the source workbook is Sales.xlsx, the January sheet contains monthly sales in B2:B13, and the destination should show their total. The formula is:
With monthly sales in Sales.xlsx on January!B2:B13, enter =SUM('[Sales.xlsx]January'!$B$2:$B$13). If those twelve cells contain 100, 200, 150, 120, 180, 90, 110, 130, 140, 160, 170, and 150, the result is 1,700.
Ranges are useful for totals and other summaries, but large, complicated networks of linked formulas can become difficult to audit. If you need to bring in a table and reshape or combine it, Power Query may be a better fit. Power Query is available from Data > Get Data in Excel for Microsoft 365 on Windows. It imports and transforms data through a refreshable query; it is not the same as a cell formula that recalculates one referenced cell.
When Linked Values Update
An external reference is not a promise of instant, real-time synchronization. If both workbooks are open, a change in the source can flow through as Excel recalculates the destination. If the source file is closed, Excel may use the saved value and ask whether to update links when you open the destination. Whether and when updates happen depends on link settings, calculation, file access, and whether you allow the update.
When a prompt appears, consider whether you trust the source and expect it to have changed before choosing to update. To review available controls in Excel for Microsoft 365 on Windows, open the destination and look for Data > Workbook Links. The pane can show linked sources and, where supported, options such as updating or changing a source. Some Excel builds or older workbooks may show different link-management commands. Avoid assuming that saving the destination alone refreshes every external value.
For routine reporting, decide who owns the source file and when the destination should be refreshed. A monthly report might be updated after the source owner finalizes the sales workbook, rather than every time someone opens the report. That simple agreement helps prevent users from treating an old saved value as a current figure.
Moving Files and Fixing Broken Links
Links can fail when Excel cannot find the source workbook. Common causes include renaming or moving the source file, changing a folder structure, deleting a worksheet, or opening the destination on a computer that cannot access the original location. A formula may still be visible even when its source is unavailable, but Excel cannot retrieve a current value from a missing file.
Start troubleshooting by opening Data > Workbook Links in the destination workbook and checking which source is reported. If the source was moved, use the available change-source option to point Excel to the correct file. If the source is on a shared drive, verify that the drive or network location is available and that you have permission to read it. If a worksheet was renamed or deleted, restore it or revise the reference to point to the intended sheet.
For a workbook shared with colleagues, a link to a path on your personal computer is fragile: other people may not have that folder. Store related workbooks in an agreed shared location, keep their names and folder structure stable, and test the destination from another user’s account or device when appropriate. Cloud storage can make shared files easier to access, but it does not eliminate permissions or link-management issues.
Security and Reliability Considerations
External links can reveal that a workbook depends on another file and can retrieve information from it. Treat update prompts as a trust decision: update only when you recognize the source and expect the data. In a workplace, follow the organization’s rules for sharing sensitive information and approved storage. A destination workbook may contain formulas that expose values from a source to anyone who can open the destination, even if they cannot access the source file themselves.
Linked workbooks also depend on two files remaining available and understandable. For important reports, label the source and refresh date, retain appropriate backups, and check key totals after updating. A formula link can reduce manual retyping, but it does not verify that the source data is correct or that the reference points to the right cell. Restricting edits to the source layout can reduce accidental breakage.
Choosing Between Formulas, Power Query, and Copying
The right method depends on what you want the destination workbook to do:
- Use an external-reference formula when a few cells or calculated results should follow particular cells in another workbook.
- Use Power Query when you need to import a table, clean or reshape it, combine files, or repeat a structured refresh. Review the query’s source and refresh behavior before relying on it.
- Copy and paste values when the destination should be a one-time snapshot that will not change with the source. Record when the snapshot was taken if that matters to readers.
- Keep the information in one workbook when the files are always edited and reviewed together. Fewer external dependencies can make a workbook easier to share and maintain.
It is a common misconception that linking two files makes them behave like one continuously synchronized document. A formula link passes a value through a workbook reference; it does not automatically merge the files, resolve conflicting edits, or guarantee that every viewer sees an up-to-the-second result. For simultaneous team editing, use an appropriate shared-workbook workflow and understand how its permissions and version history work.
Frequently Asked Questions
Can Excel automatically update one spreadsheet from another?
Yes, an external-reference formula can display a source value and update when Excel recalculates or refreshes the link. It is not necessarily instant: the source must be available, and update prompts or settings may affect when Excel retrieves the latest value.
Do both Excel files need to be open?
No. Excel can keep a link to a closed workbook, but it may rely on the last saved value or request permission to update the link when you open the destination. Having both files open is convenient when creating a reference and checking that it points to the right place.
Can I link two Excel workbooks stored in different folders?
Yes. The reference can include the source workbook’s location. However, moving or renaming the source may break the connection, so shared files are more reliable when stored in a stable location accessible to everyone who uses the destination.
How do I find links in an Excel workbook?
In Excel for Microsoft 365 on Windows, check Data > Workbook Links for recognized workbook connections. You can also inspect formulas in cells that appear linked; an external reference includes a workbook name in square brackets. Older or differently configured files may require a different link-management command.
Can I link an entire spreadsheet with one formula?
A formula usually references a particular cell or range, not an entire workbook as a live, automatically merged object. For importing and refreshing a full table, use Power Query or another suitable data-import method, then verify the source, transformation steps, and refresh results.
Related
- Can Power Automate Refresh Excel Power Query?
- Align Images in Excel: Steps, Options, and Common Fixes
- Can Excel Compare Means With a T-Test? Steps and Choices
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Copy and Paste in Excel While Keeping FormattingTo copy cells in Excel for Microsoft 365 on Windows and keep their formatting, select them, press Ctrl+C,…
- Excel Date Selector: Add a Calendar or Validate DatesExcel for Microsoft 365 on Windows does not include a built-in calendar date selector for ordinary worksheet cells.…
- Google Sheets Inventory Template: Build a Simple TrackerYes. You can make a practical Google Sheets inventory template with columns for each item, its location, quantities…
- Box and Whisker Plot Creator in ExcelExcel has a built-in box and whisker plot creator: in Excel for Microsoft 365 on Windows, arrange each…
- Center Text in Excel: Keyboard Shortcut and How to Use ItTo center text horizontally in Excel for Microsoft 365 on Windows, select the cell or cells and press…
- Snowflake CSV vs CSV for Excel: Which Should You Choose?Snowflake CSV is the standard comma-separated export, while CSV for Excel is a Snowflake download option intended to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.