Before you ask. Yes, I did refresh the table and yes, I did reconfirm the source for the pivot tables.
Unfortunately due to the large volume of proprietary data, I can't post the workbook. It would take days to desensitize the data. The best I can do is pictures. I have a picture of all the rows in the table and a picture of the filter based on the first row. IPHONE X is missing.
I have a pivot table that is build off an Excel table. I set the filer values on the table using vba. In this case the table has the name of 6 models. The pivot filter shows only 5 of them. I've seen this behavior before. No matter what I do, short of creating a new pivot table, I can't get the table to acknowledge the 6th model.
It is not the last in the table. I reconfirmed the table range.
Has anyone else seen this problem? A web search has not been fruitful.
Bookmarks