Apparently the filter in a pivot table in google sheets will block all updates to the pivot table when the source data (e.g. in another sheet) changes.
As described here: 
Apparently the filter in a pivot table in google sheets will block all updates to the pivot table when the source data (e.g. in another sheet) changes.
As described here: