Normally, a long pivot table prints to the bottom of a page, then continues on the next page. The page break occurs naturally, not at a specific position in the pivot table. You can control the page breaks, by changing the pivot table settings. The Sample Layout In this example, the pivot table has two [...]

When you add a numeric field to the Values area of a pivot table, it usually appears as a Sum. For example, in the pivot table shown below, the Units field became Sum of Units. Occasionally, when you add a numeric field to the Values area, it shows the Count, instead of the Sum. In [...]

If you add new products to your pivot table source data, and refresh the pivot table, the new products will appear in the drop down lists. Sometimes though, the new items appear at the end of the list, instead of in alphabetical order. This problem can occur if you have manually rearranged the items in [...]

If you accidentally delete the Excel 2003 worksheet that has the source data for your pivot table, you may be able to use the pivot table’s Drill to Details feature to re-create it. Extract the Pivot Table Data To re-create the source data in Excel 2003, follow these steps to use the Drill to Details [...]