pivot table not refreshing new data

Hi can anyone help me, my pivots are not refreshing new data entered, im sure its to do with the fact that the formula is div/o due to the fact there is no data on certain dates, but this needs to be the case as they dont work every day

i thought i could go in a select refresh all and all my pivits would update but at the moment i have to go into total effectiveness and tick the new dats to update pivot

i have atttached a small example

Thanks