Copy a Custom PivotTable Style

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 [...]

Pivot Tables based on Team Foundation Server

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’}

Counting Blank Cells in Source Data

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 [...]

Locate the Source Data For a Pivot Table

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 [...]

Remove Old Items in Excel 2007 Pivot Table

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 [...]

Default Functions in a Pivot Table

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, [...]