Learning Objectives

  • Link cells between worksheets
  • Create formulas referencing other workbooks
  • Manage external links
  • Update and break links
  • Use 3D references for multiple sheets

Step-by-Step Guide

  • Same workbook reference format: =Sheet2!B5
  • Rename sheets clearly to avoid broken formulas
  1. Open both files.
  2. In destination file, type = and select source cell.
  3. Excel creates external path reference automatically.
  • Use Data → Edit Links (update source, change source, open source)
  • Track dependency when sharing files
  • Update links on opening if source changed
  • Break links before archival submission if required

5) Use 3D References

  • Across multiple sheets with same structure: =SUM(Jan:Dec!B2)

Risk Management

  • Avoid moving source files frequently
  • Keep project folder structure stable
  • Document which workbook is “master” source

Practice Task

Create 3 monthly sheets and 1 summary sheet:

  • Link monthly totals into summary
  • Use one external workbook reference
  • Demonstrate link update and controlled link break

📚 Practice: Unit 3 Practical Assignment