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