To add filters in the top of a pivot table, you can follow these steps:
1. Click anywhere inside the pivot table to select it.
2. Go to the "PivotTable Analyze" or "Options" tab on the Excel ribbon.
3. In the "Filter" group, click on the "Insert Slicer" button.
4. A dialog box will appear with a list of fields from your pivot table. Check the boxes next to the fields you want to add as filters.
5. Click on "OK" to insert the slicers.
6. The slicers will appear in a separate window on your worksheet. You can drag and resize them to place them at the top of your pivot table.
7. Use the slicers to filter the data in your pivot table by selecting the values you want to include or exclude.
I hope this helps! Let me know if you have any other questions.
I'd lay odds that the dropdown arrows have been removed by vba. I'll try to look into this further but your easiest option at the moment is to recreate the pivot table from scratch as I did: