From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Locating and maintaining links

Locating and maintaining links - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Locating and maintaining links

“

If you work with files that have formulas that get data from other workbooks, those are called links. And you need to know where those links are and how to find them. We need to have two files open in this movie, 09-05-EmployeeTable as well as, I'm pressing Ctrl+Tab, 09-05-RegionalSales. Right now, there are no linkage formulas. How do we know that? First of all, in Regional Sales, if we go to the DATA tab, the term Edit Links is grayed out and we cannot select it. Therefore, there are no formulas in this workbook that get data from other workbooks. Let's press Ctrl+Tab and go to the other workbook. Are there any formulas here or on the DATA tab? Edit Links here is grayed out as well. So let's create a linkage formula between the two. In cell J8 here, we want the Couches' total. Equal or press Ctrl+Tab, go to the other workbook and we're going to get from each of the four sheets here, the Grand Total for Couches. It's in cell B8 so we'll simply click there, click Plus then do the same…

Contents