I cannot understand why a cell B1 returns 0 when I refresh the sheet.
I get a daily share price from the internet. That share price is in cell a1. I track the share price on a daily basis, however, I want to record its highest price throughout the year. the formula i use is

=MAX(A1:B1)

However, if A1 has £6.45 when I refresh B1 will only return 0. I've checked the formatting of each cell, I even tried using the following: =IF($Y$1,0,MAX(A1:B1)) with 0 in Y1

I'm baffled

Thank you

Dave