• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

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

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?


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint