Hi there,

Thanks for your help with my other posts, all have been resolved splendidly.

I have a new issue now where data is being refreshed using the refresh button, but all formulas in the data explorer get blanked out. To get the formula to refresh I have to either open an existing formula box and click ok without making changes => all formulas refresh, or click on 'recalculate all fields'.

I have multiple copies of this file and it's only one on which this happens, I feel like there's a check box that needs checking but I've not found one. I've looked at the 'Recalculate on Open' fields and all the formula fields are checked... what am I doing wrong?

many thanks
L