1. Insert a pivot.
2. Select Pivot on the Tool Bar.
3. Click on Refresh Data.
4. Click on Manually.
You can now create as many pivots as you need from the same set of results. You would change the limits in your results and click on “Refresh Now” to update an individual pivot without changing the information in the other pivots.
Last updated: October 15, 2013