Create and Update PowerPivot table

Creating PowerPivot tables

To create a PowerPivot data source, one option is:

• 1. Copy the data into an Excel worksheet

  2. Select all data on the worksheet

  3. Click on the PowerPivot tab, and click "Add to Data Model"

  4. A "Create Table" dialog opens. You probably want to click "My table has headers" before clicking OK.

  5. The PowerPivot window will open with the data now in PowerPivot.

  6. One option now is to select the Home tab, then the PivotTable drop down, and select "Four Charts". Select "New Worksheet" and you will have a place in a new worksheet next to your data to create PivotTable charts.

Note that your original data now sits in a table object on the original worksheet.

Updating PowerPivot data

When updating PowerPivot data that was created using the above method, the trick here is to update the original data in the table object without deleting the table object.

• 1. Select the data (but not the headers) in the table object and delete

  2. Paste the new data into the table object

  3. Resize the table object if you pasted fewer rows than originally existed

  4. On the PowerPivot tab, select Manage. Select the Linked Table tab and click the Update All button