I am having a problem with pivots where if a new items comes in it is not being picked up even after a refresh. I am using a formula in Name Manager like:
and when I check range it is picking up the full range.
When I go into the pivot and filter I can see the new item but it is NOT ticked.
Is there a way to ensure that all new items that come into the pivot will be picked up and the box ticked?