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

Locating and maintaining links

From the course: Excel 2016 Essential Training

Start my 1-month free trial

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…

Contents