Question: what does it mean when it says the pivot table name is not valid?
Answer: The pivot table error, "field name is not valid", usually appears because one or more of the heading cells in the source data is blank. ... In the Create PivotTable dialog box, check the Table/Range selection to make sure you haven't selected blank columns beside the data table.