Excel will refresh this data whenever you open the spreadsheet ... Hereâ s an example of tracking the monthly highs and lows ...