Hi guys,
I have a pivot table that draws data from a column dynamically. I say dynamically because all the data that is drawn is being constantly updated by some formulas. The problem is when I draw data from these columns pivot table counts the empty cells (with formula but with use of a in function they are blank) as data. Hence I get a blank item on my slicers which I could not figure out how to remove. Please note that the blank item I get on the slicers are not the kind that can be removed from slicer settings.
I am afraid I cannot upload the whole workbook as it is too large and since all sheets are linked to each other by formulas and VBA I cannot simplify it for a sample workbook.
I hope I was able to explain my issue clearly.
Thank you in advance!
Bookmarks