Get External Data: Link
There are several options when you Import Data. You can choose from the following:
Table
PivotTable Report
PivotChart
Only Create Connection
Where do you want to put the data?
Existing worksheet
New worksheet
What Else Do You See? This data can be added to a PowerPivot Data Model
when you import it.
3.
Try it: Import Data
Select
PivotChart.
Select Existing worksheet.
Check: Add this data to the Data Model.
Click OK.
Keep
going...
Very Important! Look at the Properties:
If you select multiple Tables Microsoft Excel will Import the relationships between tables.
