XLOOKUP and VLOOKUP not refreshing unless I type the formula again

Hi there,   As explained in the title my main issue is that my xlookup and vlookup formulas aren't refreshing when I change the source data. The only way to have it showing new results instead of o...