Only way to refresh is to switch back and forth between sheets

Excel overlap.jpg