You can change the underlying data, and refresh the Pivot Table report simply by clicking the Refresh button. This is wonderful for recurring reports since it means that once you have your Pivot Table report set up just right, you can simply change the underlying data and click refresh.
This video is immediately available with an Excel Fans subscription