PowerPivot Field List Not Updating with New Fields


  • After adding fields in the PowerPivot window, I return to Excel. Even if the button to refresh is there and I refresh the field list, the added fields do not show or only some of the added fields show. To get all the fields to show, I have to close the worksheet and re-open it. Seems like a bug to me. I am using version 11.2.2100.60.
    Saturday, February 09, 2013 1:52 AM


All replies

  • try clicking "refresh all" from the data tab.

    Also try showing pivot table fields rather than powerpivot fields.

    hope this can help.

    Thursday, March 07, 2013 3:24 PM
  • I am having this same problem and clicking "Refresh All" on the data tab does not resolve the issue.  Only restarting Excel resolves the issue.

    I added some new columns, and they're not showing up in my field list unless I restart Excel.  This seems to happen every single time I change the data.  It's definitely a bug.

    I am using version 11.0.3000.0 on Excel 2010 64 bit.


    • Edited by seanrez Tuesday, October 08, 2013 8:09 PM added version info
    Tuesday, October 08, 2013 8:08 PM