PowerPivot field list greyed out after copying worksheet

Question

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?

Answer 1

The 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.

Answer 2

Hi hotbread.,

I'm glad to hear that you issue has been solved. I'm try to reproduce this issue on my test environment. However, everything is work fine. Please let me know if this issue recurs.

I will close this issue. Thanks for your support.

Regards,

---

Elvis Long
TechNet Community Support