What will you need to do it?
Before importing any data through PowerPivot, you need to activate the PowerPivot window by simply Clicking on PowerPivot menu and then Click on Manage button under Data Model group.
After clicking on Manage button Excel will load the PowerPivot Window and it is completely separate from main Excel Window like below:
How to import data by using basic Copy-Paste?
Step 1: Select the data table which you want to import and press Ctrl+C in you Excel sheet like below image:
Step 2: Now you need to paste these data table into your PowerPivot window. To do this first you need to activate the PowerPivot window and then, click on Home menu and click again on Paste button.
Step 3: After clicking on Paste button, a dialog box will appear named Paste Preview.
Step 4: From this dialog box just type a table name (In my case I've entered seslist as table name) and check the Use first row as column headers option if you wish it too. And then click on Ok. After clicking on Ok button, PowerPivot window will run a process about pasting the new table.
Step 5: Finally the data will successfully imported like below image:
Importing data by using the basic Copy-Paste of PowerPivot Window is the most easiest way to import data. It is a faster process like copying one sheet to another sheet.
Before importing any data through PowerPivot, you need to activate the PowerPivot window by simply Clicking on PowerPivot menu and then Click on Manage button under Data Model group.
Image 1: Activating the PowerPivot window
After clicking on Manage button Excel will load the PowerPivot Window and it is completely separate from main Excel Window like below:
Image 2: PowerPivot for Excel window
How to import data by using basic Copy-Paste?
Step 1: Select the data table which you want to import and press Ctrl+C in you Excel sheet like below image:
Image 3: Copying the data table from another Excel workbook
Step 2: Now you need to paste these data table into your PowerPivot window. To do this first you need to activate the PowerPivot window and then, click on Home menu and click again on Paste button.
Step 3: After clicking on Paste button, a dialog box will appear named Paste Preview.
Image 4: Paste Preview window
Step 4: From this dialog box just type a table name (In my case I've entered seslist as table name) and check the Use first row as column headers option if you wish it too. And then click on Ok. After clicking on Ok button, PowerPivot window will run a process about pasting the new table.
Image 5: Pasting new table
Step 5: Finally the data will successfully imported like below image:
Importing data by using the basic Copy-Paste of PowerPivot Window is the most easiest way to import data. It is a faster process like copying one sheet to another sheet.