At any time, you can click Refresh to update the data for the Pivot Tables in your workbook.
Filtering enables in-depth analysis of large amounts of data in a Pivot Table report.
There are different ways to filter Pivot Table items.
You can use report filters to quickly display a subset of data, such as a product line, a time span, or a geographic region.
For easy access, report filters that you add are conveniently placed above the Pivot Table report.
In addition to or instead of using report filters, you can apply label, value, or date filters to filter by specific text-based labels, specific values, or a specific date and time frame that you want to analyze.
You can also apply filters that instantly show the top or bottom 10 values, or that meet the criteria that you specify.If needed, you can specify filter options to determine what filters display or hide.And when you no longer need a filter applied, you can remove it.In Excel 2010, you can also use slicers to filter Pivot Table data.For more information about slicers, see Use slicers to filter Pivot Table data.Filtered data displays only the subset of data that meet the criteria that you specify and hides data that you do not want displayed.