Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The PivotTable field name is not valid (error)
Hey, wonder what I might do here. Using excel 2007 to link to a sharepoint
"list". I then "pivot" this list for a variety of reports. However, when I then, say, the next day, choose Data, Fresh, and then go back to the pivot table and right click on it to refresh, and see change, I get an error: "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 the name of the PivotTable field, you must type a new name for the field." And of course, I am not seeing the refreshed information in the pivot table. Any idea what is going on here? What can I do to keep the Pivot Table "locked" on the data set, even if I refresh it? Thanks! PatK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table "Field Name is not valid" error | Excel Discussion (Misc queries) | |||
PivotTable Grand Total Error using Calculated Field | Excel Worksheet Functions | |||
PivotTable field name is not valid - cannot create | Excel Discussion (Misc queries) | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
The pivottable field name is not valid | Excel Discussion (Misc queries) |