From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Locating and maintaining links
From the course: Excel 2016 Essential Training
Locating and maintaining links
- In this movie we need to have two files open. 09-05 EmployeeTable, and as I press ctrl + tab, 09-05 RegionalSales. When you write formulas that gather data from different workbooks, you can go to the Data tab and see if those exist by choosing an option called "Edit Links". But if it's greyed out, there are no links. However, this can be a little confusing. Links are actually two-way. They've got a source file, they've got a destination file, so to speak. I'm going to go to the other workbook with ctrl + tab, EmployeesTable. We're going to write a formula here that gets data from the other workbook. Equal, and how do we get to the other workbook? By way of ctrl + tab, or the View tab in the ribbon menu system, switch windows, we'll go over to the RegionalSales file. And click on this cell right here, that's the couch's total, and enter. We've got a linkage formula here that's getting data from the other workbook. On the Data tab here, I'm gonna press ctrl + z to undo that last…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.