Category Archives: Excel Pivot Table

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 | 5 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

Student Budget With Pivot Tables: Spreadsheet Day 2011

Happy Spreadsheet Day! We celebrate on October 17th, because this is the date that VisiCalc was first released to customers, in 1979. This year’s theme is Spreadsheets for Students, and what better way to help students, than show them a … Continue reading

Posted in Excel Pivot Table | 2 Comments

Excel Pivot Table for Financial Data

Last week, you saw a technique for changing monthly data into a better layout, when creating an Excel pivot table. We used a multiple consolidation ranges pivot table to change this 13-column table into a 3-column data source. Today we’ll … Continue reading

Posted in Excel Pivot Table | 2 Comments