I have a previous Excel 2013 Pivot Table with approximately 260 rows and 11 columns of data.
After my Department upgraded to Excel 2016, the Filter function stopped working. My last line of data was row 241 before the upgrade. Everything above row 241 will filter correctly. Everything after row 242 remains, regardless of category that is filtered.
I have tried to uncheck and recheck the "Filter" option, but the problem persists.
I have tried to search for Text Filters with "equals" then a category. Rows above 241 work correctly, but the newest entries that do not match stay the same.
There are no blanks in any row of the table.