Pivot: When you delete the data in the filtered column, the filter reverts selects (blank)

I have a pivot table against an Excel table where one of the filters selects data based on that field not being blank. The problem happens when starting fresh with the source table, the data in the filtered field is deleted in that column. When the table is refreshed, this forces the pivot table filter to select the only option left, which is (blank).

Is there any way to set the filtered option to always select anything except (blank) and have it remain even when the table is refreshed and there's no data in the filtered column? I use a button and VBA to expose the refresh option to users not familiar with pivot tables.

As usual....

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I was able to locate a solution on another forum regarding the removal of "phantom" entries. That, and the use of On Error Resume Next was also a real part of the solution that was beguiling me.