You can create custom PivotTable Styles in an Excel 2007 workbook, to fine tune the appearance of your pivot tables. If you’ve invested a lot of time in create a custom style, you might like to copy that style to a different workbook.

Unfortunately, there isn’t a built-in command that will let you copy PivotTable Styles [...]

Changes being made to the relational warehouse and cube schema in Team Foundation Server 2010 will affect existing Excel pivot tables/charts that are authored against the warehouse or cube.
To learn more, you can read the article on Sunder Raman’s Blog.

var fbShare = {size:’small’}

If there are blank cells in one of the fields in your source data, you might want to show a count of the blank cells in the pivot table. In this example there’s a Region field in the source data, and some of the records have no region name entered. In the pivot table, you’d [...]

You might have to make changes to a workbook that contains a pivot table. If someone else created that workbook, you may not be sure where to find the Excel table that was used as the pivot table’s source data. In some workbooks there can be several Excel tables, and it’s not immediately obvious which [...]

To prevent old items from being retained in an Excel 2007 pivot table, you can change an option setting, as shown in the short video below:

Right-click a cell in the pivot table
Click on PivotTable options
Click on the Data tab
In the Retain Items section, select None from the drop down list.
Click OK, then refresh the pivot [...]

Usually, when you add a field to the Values area in a pivot table, it automatically uses the Sum function. Sometimes though, a field automatically uses the Count function. You might not understand why different functions are used for two fields that contain similar data.

If there are blank cells, or non-numeric data in the field, [...]