Pivot Table not showing values as editable after moving dates into rows...

[pete234]

I can't say when it happened but I think it was after I moved period data to rows.
When I look in field chooser columns, it just says values with nothing listed.
Across the top of my pivot are headers for values, but the values in the field chooser is blank.
If I check the the powerp sheets in the powerp pivot for the values, nothing is checked.
If I click the headers for the values I can right click and click Value Settings but I can't edit them.
The workbook still seems to function I just don't know why it's doing this.
Why wouldn't the values for values be shown in the field chooser or checked?

 

[masplin]

I'm guessing your tried closing the wrokbook and reopening. I quite often get ghost entries in the field chooser when I remove them and gets sorted by refresh or a close/open. Does the ghost header have anything you can right click on and then seelct remove?

Mike