1. Click a cell in the pivot table. The Options tab on the Office ribbon (top of screen) appears.
  2. Click the Options tab.
  3. Click the Change Data Source button.
  4. In the Change Pivot Table Data Source screen, update the data range and click OK.
  5. Click Refresh to refresh the data. Note: You may need to resort the data if it was sorted. It doesn't automatically resort.