Auto refresh PIVOT tables

Hi.

In one workbook, I have one data source which connects with 8 different pivot tables.

Can someone help me setup a continuous refresh of these pivot tables with respect to changes in the data source ?

Also, Can I freeze a specific value for pivot filter ?

Thanks,

Pranav