This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Get Excel Data Into PowerPivot
Problem: How do I get my Excel data into PowerPivot?
Getting Excel data into PowerPivot is easy. You can copy Excel data and paste it into PowerPivot. Better, convert your Excel data to a table and then link the table to PowerPivot.
First, convert your dataset to a table by selecting one cell and pressing Ctrl+T. Excel will ask you to confirm that your data has headers. Click OK. On the Table Tools Design tab, enter a new name for the table on the left side of the ribbon. This name will carry through to PowerPivot and be used in formulas later, so keep it short and easy to spell.
On the PowerPivot tab, choose Create Linked Table.
Figure 948 Define your data as a table, you can simply link to the table.
After a moment, you will see your data in the green grid of the PowerPivot window.
Figure 949 The linked table appears in PowerPivot.
Alternate Strategy: If you need to bring data from another Excel workbook, you can use a copy and paste. Copy the data in Excel. Click the PowerPivot Window icon on the PowerPivot tab. In PowerPivot, choose the Paste icon. You will be asked to give the pasted table a name.
Figure 950 You can paste your data into PowerPivot.