The Pivot Table Wizard isn’t available on the Ribbon in Excel 2007. To open the Pivot Table Wizard, you can use the keyboard shortcut — Alt + D, P — as described in the article on creating a pivot table from multiple sheets. Another option is to add the Pivot Table Wizard button to your [...]

If your pivot table has column labels, and more than one field in the Values area, you might want to centre the column labels. For example, in the pivot table shown below, there are Region headings in the Column Labels area. Below each Region label, there are headings for the Qty Sold and $ Sales [...]

In a comment on this blog, someone asked how to create two pivot tables on the same Excel worksheet. Shown below is a worksheet named Pivot_Reports, with a pivot table on it, based on the data on the Sales_East sheet. We’ll add another pivot table to the Pivot_Reports sheet, based on data on the Sales_North [...]

In some workbooks, you might want to prevent users from making any changes to a pivot table. You want them to see the pivot table, but not change it. However, users might need to make changes to data in other areas of the worksheet. If you protect the worksheet without enabling pivot table use, users [...]