If you’re interested in learning how to use Microsoft PowerPivot for Excel 2010, there’s a special price today on the ebook version of Microsoft PowerPivot for Excel 2010: Give Your Data Meaning, by Mark Russo and Alberto Ferrari. Here’s the tweet that announced the special price: #Ebook Deal of the Day: Microsoft PowerPivot for Excel [...]

In some workbooks, you might want to allow users to make changes to a pivot table, but you need to protect formulas or data in other areas of the worksheet. If you protect the worksheet and enable pivot table use, users will be able to modify the pivot table, but won’t have access to other [...]

If your pivot table spans two or more printed pages, the page, row and column headings might only print on the first page. You can set an option for the pivot table to make the page, row, and column headings appear on every sheet when you print the pivot table. This will make it easier [...]

To remove a pivot table from an Excel workbook, you can delete the worksheet that the pivot table is one. Occasionally, you might want to remove a pivot table, but you can’t just delete the worksheet because it contains other data. To remove a pivot table, and leave the other items on the sheet untouched, [...]

In Excel 2002, and later versions, when you type an equal sign, then click on a cell in a pivot table, you may see a GETPIVOTDATA formula, instead of a cell reference. In this short video, learn how to turn this feature off. For written instructions, please see Turn Off GetPivotData Formulas for Excel 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 [...]

When you create a pivot table in Excel 2007, a PivotTable Style is automatically applied. You always select a different PivotTable Style, so you’d like to change the default PivotTable Style, to save time when you create new pivot tables. Follow these steps to change the default PivotTable Style: Select a cell in the pivot [...]