Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-32 Selection of worksheets to load from an Excel file.
Important Only worksheets are imported from an external Excel workbook. If there are tables
defined in an Excel file, they are not considered. For this reason, it is better to have just one
table for each worksheet and no other data in the same worksheet. This version of PowerPivot
cannot detect single tables in an external workbook.
After you select the table to import, the wizard loads data into PowerPivot and makes it
available for you to perform any kind of computation. Obviously, you can use the Preview &
Filter button to have a look at the data before the data loads, and you can apply filtering, if
you like, as you have already learned to do with relational tables.