Appendix A. Solutions to Common Questions and Issues with Pivot Tables

This appendix covers solutions to the following questions and issues:

  • What does "The PivotTable field name is not valid" mean?

  • When I refresh my pivot table, my data disappears.

  • When I try to group a field, I get an error message.

  • Why can't I group my month fields into quarters?

  • My pivot table is showing the same data item twice.

  • Why are deleted data items still showing up in the page field?

  • When I type a formula referencing a pivot table, I cannot copy the formula down.

  • How can I sort data items in a unique order that is not ascending or descending?

  • How do I turn my pivot table into hard data?

  • Is there an easy way to fill the empty cells left by row fields?

  • Is there an easy way to fill the empty cells left by row fields in multiple columns?

  • How do I add a rank number field to my pivot table?

  • Why does my pivot chart exclude months for certain data items?

  • Can I create a pivot chart on the same sheet as my pivot table?

  • How can I turn my pivot table report into an interactive web page?

    Pivot Table Data Crunching
    Pivot Table Data Crunching for Microsoft Office Excel 2007
    ISBN: 0789736012
    EAN: 2147483647
    Year: 2003
    Pages: 140 © 2008-2017.
    If you may any questions please contact us: