Missing Tables in PP Field List

[GDRIII]

I have a fairly hefty data model that is missing half a dozen tables in a few of the PowerPivot Field Lists.

For example, when I turn on the field list for one model in the workbook, all 21 tables are listed but, when I turn on the Field List for another model within the same workbook, only 16 are showing.

I have disabled and enabled PP from the Add Ins window without any results.

Anyone experience this or have any ideas on how to fix.

Working with PP Version 11.0.3000.0 in Excel2010

 

[PentaGalCXO]

I have seen this behavior on occasion. I can generally fix the issue by forcing the pivot to do a schema refresh. Lets say for the pivot that shows 16 tables... one of the tables shown is DateDim. Go to DateDim in PowerPivot and create a simple measure like Test:=1. Then go to the pivot table. Most often the pivot recognizes a data model change and it will re-read the schema & the 21 tables should appear in the field list (under "All"). You can then delete the Test measure. Hope that works for you too...

 

[GDRIII]

I'll try that next time. This time I just rebuilt from a fresh Pivot.