Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-31 The Table Import Wizard for Excel files.
You need to provide the file path of the file containing the data to select an Excel file. An
important check box is the Use First Row As Column Headers. If your table contains column
names in the first row (as is the case in the example), you need to select this check box so
that PowerPivot automatically detects the column names of the table you are about to
load. If you now click on Next, the wizard opens the Excel file, searches for worksheets in
it, and allows you to choose which one to load, as you see in Figure 5-32.