Dears,
Briefly, I've several functions in workbook1 and all of them would be automaically updated whenever I press Update without open my data source file such as VLOOKUP, HLOOKUP, INDEX & MATCH....etc. except AVERAGEIFS, I have to open my data source file to update its value.
And I don't wont to open the source file to update averageifs formulas.
BR.
