Search TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
Home
Video Tutorials
Free Macros
Keyboard Shortcuts
Forum
Contact
Main Menu
  • Home
  • Video Tutorials
    • Arrays
    • Charts & Graphs
    • Financial Functions &
    • Models
    • Formatting
    • Formulas
    • Data Analysis Tools
    • Import / Export / Link
    • Lists & Forms
    • Macros
    • Printing
    • Security
    • Tips & Tricks
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
Tips
Create your first Formula
Create your first Chart or Graph
Password protect your Workbook
Hide Rows, Columns, and Tabs
Using Conditional Formatting
Tutorials: Import, Export, & Link Data

Linking Cells to Multiple Excel Files(Workbooks)

Here, you will learn how to link data from one workbook to another workbook. You will link a cell in excel file (workbook) A to excel file B. You will also learn how to update and break the links.

Note:  The two excel files provided here might need to be re-linked when you download them. This is only because the file references are based on where they were located when they were created, and this may be different than where they reside on your computer.

Topics Covered
     Link Multiple Excel Files and        Workbooks
     Link cells to other excel files
     Update, Break, and Change Links
   Difficulty:         Easy
   Video:               Yes
   Spreadsheet:     Yes     1   2
Got a Question? Ask it Here in the Forum.
Most Recent Tutorials
Nov. 25
Group and Ungroup Cells in Excel (Easily Hide and Unhide Data)
Absolute and Relative Cell References & INDIRECT() Function
Sep. 20
Bond Pricing and Valuation
Calculate the Future Value of a Retirement or Savings Plan
Calculate the Net Present Value of Future Cash Flows
Build a Loan/Mortgage Payment Calculator
Calculate Interest and Principal Payments on a Loan
Sep. 10
FIND() LEN() Functions - Extract Text from Cells - Intermediate
FIND() LEN() Functions - Extract Text from Cells - (2 Parts) - ADVANCED
VLOOKUP() Between Separate Worksheets and Workbooks
Contact | Privacy Policy | Disclaimer
Copyright© 2008 TeachExcel.com