Spreadsheet 123 Excel 2007, 2003, XP, 2000, 97 FAQs: Pivot Tables

Basics:

Create a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Change data source for a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Refresh:

Refresh a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Automatically refresh pivot table when file is opened in Excel 2007 | Excel 2003/XP/2000/97

Refresh multiple pivot tables with a button in Excel 2003/XP/2000/97

Automatically refresh pivot table when data in a sheet changes in Excel 2003/XP/2000/97

Automatically refresh pivot table when user switches between sheets in Excel 2003/XP/2000/97

Formatting:

Remove grand totals for columns in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Remove grand totals for rows in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Change pivot table name in Excel 2007 | Excel 2003/XP/2000/97

Do not save data with table layout in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Display pivot table wizard in Excel 2003/XP/2000/97

Remove subtotals on pivot table rows in Excel 2007 | Excel 2003/XP/2000/97

Remove subtotals on pivot table columns in Excel 2007 | Excel 2003/XP/2000/97

Show Top 10 results in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Show Bottom 10 results in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Change how errors are displayed in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Change how empty cells are displayed in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Display the fields in the Data/Values Section
in multiple columns in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Display the fields in the Data/Values Section
in a single column in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Hide / Unhide:

Hide a value in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Display a hidden value in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Hide empty cells in a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Hide zero value lines within a pivot table in Excel 2007 | Excel 2003/XP/2000/97

Sorting:

Sort pivot table results in Excel 2007 | Excel 2003/XP/2000/97

Retrieving Data from Pivot Tables:

GetPivotData Example #1 in Excel 2003/XP/2000/97

GetPivotData Example #2 in Excel 2003/XP/2000/97

Miscellaneous:

Exclude rows from the pivot table based on summed totals in Excel 2003/XP/2000/97

Suggested Reading

Home | About Us | Our Services | Software | Excel Templates | Excel Tutorials | Useful Links | Site Map | Contact Us

| Terms of Conditions |

---

Unless otherwise stated, all images and text
Spreadsheet123

---