Category Archives: Excel Pivot Table

Pivot Table Tips on Contextures

Thank you for following my pivot table tips, here on the Excel Pivot Tables Blog. I appreciate it! There are many more tips and tutorials on my Contextures website, and I’ve just finished setting up a Pivot Table index, so … Continue reading

Posted in Excel Pivot Table | 1 Comment

PivotPower Premium Update 201407

If you’ve bought a copy of my PivotPower Premium add-in, I sent out an update email last week, so you can download the latest version. There are a few new features, that I hope you will find useful. A big … Continue reading

Posted in Excel Pivot Table | 1 Comment

Link to Pivot Table Creates Absolute Reference

Last week, I did a Pivot Table presentation, and someone asked why you get an absolute reference, if you try to link to a pivot table cell. For example, in the screen shot below, I typed an equal sign in … Continue reading

Posted in Excel Pivot Table | 5 Comments

Find the Source Data for Your Pivot Table

After you create a pivot table, you might add new data, or change the existing data. When you refresh the pivot table, it might not show all the new records, or pick up the changes. To find the problem, you … Continue reading

Posted in Excel Pivot Table | 1 Comment

Duplicate Items Appear in Pivot Table

When you create a pivot table it groups the items from your data, and calculates a total for each group. In the screen shot below, you can see the total sales for each category, in each city in the West … Continue reading

Posted in Excel Pivot Table | 6 Comments

Create a Pivot Table in Excel 2013

There is a new feature in Excel 2013, that makes it even easier to get started with pivot tables. Just select a cell in your source data table, and on the Ribbon’s Insert tab, click Recommended PivotTables. A window opens, … Continue reading

Posted in Excel Pivot Table | Leave a comment

Quickly Move a Large Pivot Table

Sometimes you have to move a pivot table, after you’ve created it. That’s not too difficult if the pivot table is small – just select all the cells, cut them, and paste in a new location. With a very large … Continue reading

Posted in Excel Pivot Table | Leave a comment

Create Custom Ribbon Tabs for Workbooks

If you’re creating workbooks with pivot table reports, you might have macros in those files, to make it easier to work with the pivot tables, or to navigate through the workbook sheets. Instead of creating buttons on the worksheets, to … Continue reading

Posted in Excel Pivot Table | Leave a comment

Use Dates in GetPivotData Formula

With a GetPivotData formula, you can pull data from a pivot table. For example, how many file folders were sold: The formula works well with text fields, but you might get errors if you create a formula using dates. In … Continue reading

Posted in Excel Pivot Table | Leave a comment

PivotPower Premium Excel Add-in

There is a PivotPower add-in that’s available on my Contextures website, which helps with your pivot table tasks. It automates some of the features that aren’t built in to an Excel pivot table, and makes some of the buried Excel … Continue reading

Posted in Excel Pivot Table | Leave a comment