Advanced formula environment - not syncing formula if change made in main formula bar

Copper Contributor

HI team,

Have noticed when using Advanced formula environment, if a change to the formula is is made in main excel formula bar (so not in advanced formula environment), even if advanced formula environment add-in is closed and reopened the change to the formula isn't always reflected, almost as if the add-in caches but nothing triggers it to resync - this behavior seems to be intermittent but I cant find a pattern to trigger it



3 Replies

@Sergei Baklan 

thank you for reaching out. The issue ended up going away after a reload of the add-in following a restart of the excel session

best regards