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

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

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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