How to refresh formulas on copy / paste or formula change


#1

Hi,

before I could automatically refresh a cell on copy / paste a cell from antoher. But now, it didn't work

I have put excel on manual refresh, because when i open myu spreadsheet, all my formulas (a lot) were automatically refreshed. But i still want my cells refreshing when i make a copy paste or when i make a change in my formula

Is it possible ?

Best


#2

I founf the problem, on global http settings, i forgot to remove some data i use temporary on authentications.


#3

Great! If you want the Seotools formulas to behave like regular Excel formulas, you have the option of disabling async. The steps are described at the top of this page:
https://seotoolsforexcel.com/working-with-vba/