I am making a series of pivot tables, and due to large quantity of tables needed, am using a macro to create the pivot tables. When I recorded the macro, I deleted a blank row in hopes that "(blank)" wouldn't show up in the slicers (I did this manually for another table, and it worked). However, "(blank)" is showing up when I use the macro.

How do I get rid of a field in a pivot table slicer? Specifically all that say "(blank)".

For example, right now I have slicers that say

MANAGER NAME
Name 1
Name 2
Name 3
(blank)


Thanks