A simple way to make pivot tables automatically refresh is to right click on them, and choose table options, then check the box for an automatic refresh and set the frequency!