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 ...
Get Pivot Table Data Crunching now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
