How to Link Data Between Excel Workbooks | External References in MS Excel (Guide)

Want to link data between two or more Excel workbooks so changes in one file reflect automatically in another? In this easy MS Excel tutorial (2025), I’ll show you how to create external references to pull and sync data across files.

🧠 You’ll learn:
✔️ How to link cells from one workbook to another
✔️ Create formulas that reference other workbooks
✔️ Use external links with SUM, VLOOKUP, and other formulas
✔️ Update and manage links in Excel
✔️ Fix broken links or errors
✔️ Save & reopen linked workbooks correctly

📌 Perfect for:
✅ Budget and sales tracking
✅ Cross-team data consolidation
✅ Dynamic dashboards across files

📂 Works with Excel 2016, 2019, 2021 & Office 365

🔍 Step-by-Step Covered in the Video:
1️⃣ Open both workbooks
2️⃣ Type =, then switch to the other workbook and select the cell
3️⃣ Press Enter to link the data
4️⃣ Save both files correctly
5️⃣ Learn how to manage & update links via Data / Edit Links

🔁 Linked data updates automatically when source file changes!

👍 Like 💬 Comment 🔔 Subscribe for more Excel productivity tips in 2025.

#ExcelTips2025 #LinkWorkbooks #ExternalReferenceExcel #ExcelProductivity #MicrosoftExcel #ExcelLinking #WorkbookReference #Office365Tips #ExcelFormulaTricks #DataSyncExcel

Видео How to Link Data Between Excel Workbooks | External References in MS Excel (Guide) канала ProgrammingKnowledge2