Friday, November 23, 2012 2:15 AM
I used PowerPivot to create a pivottable and was able to add various fields without any problem, using the PowerPivot field list.
I then copied the worksheet because I wanted a second pivot table with different fields. I removed the value fields from this pivot table and began adding different fields again without a problem. However, when I went back to the first pivot table, the Values area was now empty, and I can no longer add the same value fields to the pivot table - when I try, I get the message "The field you are moving cannot be placed in that PivotTable area." I can't even add them to a new pivot table, created from within the PowerPivot window.
I suspect this is because I am trying to add the fields using the PivotTable field list instead of the PowerPivot field list, but the option to show the PowerPivot field list is greyed out.
I have tried refreshing the pivot tables, closing and re-opening the file, deleting the pivot tables and re-creating them - no matter what I do, I can't seem to enable the PowerPivot field list, and I can't add the fields that I was previously able to add.
Can anyone help with this?
Friday, November 23, 2012 6:33 AMThe problem seemed to resolve itself - after re-opening the file for the nth time, suddenly the PowerPivot field list button was enabled and I could re-add the fields. No idea why.
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, November 27, 2012 1:55 PM
Tuesday, November 27, 2012 1:55 PMModerator