Excel 2019 Bible

(singke) #1

Chapter 35: Introducing Power Pivot


35


FIGURE 35.14


Choose to select from a list of tables and views.


The Table Import Wizard reads the database and shows you a list of all available tables and
views (see Figure 35.15). The tables will have an icon that looks like a grid, while views will
have an icon that looks like a box on top of another box.


FIGURE 35.15


The Table Import Wizard will display a list of tables and views.


The idea is to place a check next to the tables and views that 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.

Free download pdf