Pivot Tables

A

Andrew Seto

Has anyone encountered the issue below?

Upon "PivotTable" refresh, an error message occurs "The Pivot Table Field
Name is not valid. To create a Pivot Tbale report, you must use the data
that is organized as a list with the labeled columns. If you are changing
the name of the Pivot Table field, you must type a new name for the field.

Basically, the Pivot Table feature stops working at this point.

Andrew
 
D

Debra Dalgleish

Do you have any blank cells in the heading row? That would cause that
error message to appear.
 
Top