Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do you have any blank cells in the heading row? That would cause that
error message to appear.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
Pivot Table Help! 1
Excel VBA For excel 0
Consolidate Pivot Tables/Cache using Excel 2003 1
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1
pivot table calculated field 1
reference is not valid message for pivot tables based on Access query 4
pivot table loosing decimals (vba) 1

Back
Top