Thread: Formula Help
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Formula Help

Scott wrote:
I get an error messsage: "The PivotTable field name is not valid. To create
a PivotTable report, you must use data that is organized as a list with
labeled columns. If you are changing a name of a PivotTable field, you must
type a new name for the field."

The data is recorded in the list. I am trying to use data from "'Error
List'!A1:I50000" Granted, I'm not as familiar with PivotTables as I am with
other functions.




Make sure there is a valid heading in all cells in Row 1.