Filter on Blanks not working

[sknight22]

Hello,

I have a pivot of info (as below). I have a master copy which i save every week by week number and dump in data from an external source. I want to filter "Time Into Loading" and "Time Finished Loading" so that it filters out and blank cells, however when new data is entered into the data source I have to re filter to include the new dates/times.

Is there a way to make the filter always include everything except for blanks?

Hope someone can assist.

Stephen

[TABLE="width: 810"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Day of the week[/TD]
[TD]Allocated Time[/TD]
[TD]Load Ref[/TD]
[TD]Time Into Loading[/TD]
[TD]Time Finished Loading[/TD]
[TD]Loading Time[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 07:00[/TD]
[TD]72700[/TD]
[TD]12/03/2018 07:39[/TD]
[TD]12/03/2018 08:58[/TD]
[TD]01:19:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 07:00[/TD]
[TD]72691[/TD]
[TD]09/03/2018 17:49[/TD]
[TD]12/03/2018 08:57[/TD]
[TD]15:08:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 08:00[/TD]
[TD]72678[/TD]
[TD]12/03/2018 08:27[/TD]
[TD]12/03/2018 10:09[/TD]
[TD]01:42:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 09:00[/TD]
[TD]72979[/TD]
[TD]12/03/2018 12:13[/TD]
[TD]12/03/2018 13:49[/TD]
[TD]01:36:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 10:00[/TD]
[TD]72845[/TD]
[TD]12/03/2018 09:48[/TD]
[TD]12/03/2018 13:50[/TD]
[TD]04:02:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 11:00[/TD]
[TD]72643[/TD]
[TD]12/03/2018 13:32[/TD]
[TD]12/03/2018 14:49[/TD]
[TD]01:17:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 11:00[/TD]
[TD]72644[/TD]
[TD]12/03/2018 13:33[/TD]
[TD]12/03/2018 14:44[/TD]
[TD]01:11:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 12:00[/TD]
[TD]73032[/TD]
[TD]12/03/2018 12:23[/TD]
[TD]12/03/2018 13:13[/TD]
[TD]00:50:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 12:00[/TD]
[TD]72645[/TD]
[TD]12/03/2018 13:33[/TD]
[TD]12/03/2018 15:43[/TD]
[TD]02:10:00[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]12/03/2018 13:00[/TD]
[TD]72959[/TD]
[TD]12/03/2018 14:11[/TD]
[TD]12/03/2018 15:42[/TD]
[TD]01:31:00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Mary90]

You'll have to refresh the filter when new data are added
Does it work when you select the table, Choose the "Data" list on the ribbon and then click "Reapply" on the "Sort & Filter" section?

If it does, you can record a macro to automate that part, which you can just run each time after you've added new data.

 

[sknight22]

Thank you for quick response. I have looked and the reapply option is greyed out