Chapter 35: Introducing Power Pivot
35
FIGURE 35.18
Activate the Table Import Wizard and select Excel File.
Friendly Connection Name The Friendly Connection Name field allows you to specify
your own name for the external source. You typically enter a name that is descriptive and
easy to read.
Excel File Path Enter the full path of your target Excel workbook. You can use the Browse
button to search for and select the workbook from which you want to pull this information.
Use First Row as Column Headers In most cases, your Excel data will have column head-
ers. Be sure to select the check box next to Use First Row as Column Headers to make sure
that your column headers are recognized as headers when imported.
Once you enter all the pertinent information, click the Next button to get to the next
screen, as shown in Figure 35.19. Here you’ll see a list of all the worksheets in the cho-
sen Excel workbook. Place a check mark next to the worksheets you want to import. The
Friendly Name column allows you to enter a new name that will be used to reference the
table in Power Pivot.