Chapter 12. Common Pivot Table Issues and Questions

<feature><title>In This Chapter</title> </feature>

In this chapter, you get quick solutions to the most common pivot table issues. You also find the answers to the most commonly asked pivot table questions. Take some time to glance at the topics covered here. Who knows? You may find the answer to your question!

Troubleshooting Common Pivot Table Issues

I keep getting the error “The PivotTable field name is not valid.”

Problem

When you try to create a pivot table, you get the following error message:

The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with ...

Get Pivot Table Data Crunching for Microsoft® Office Excel® 2007 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.