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.
try clicking "refresh all" from the data tab.
Also try showing pivot table fields rather than powerpivot fields.
hope this can help.
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