Formule gets overrided when refreshing web data

[Ragon]

Im importing web data and i have to trim it with a Macro, which it does effectivly. However if i use a formula to calculate some statistics, even if i place it outside of the range, it vanishes when refreshing the imported web data. How can i fix this?WHLdb (Automatisch opgeslagen).xlsm

I attached the file.

Thanks in advance

[dflak]

I'm not sure, but I think you might have to place the formulas off page.

[Ragon]

I'm not sure, but I think you might have to place the formulas off page.

I think ive tried it before but i'll give it another go. I tried to use cells which refer to the data trimmed on another sheet but it didnt work out back then either.