Forum Discussion
Link from one Escel file to another
Hi, i have on Excel file linked to another Excel file, but when i open the target it doesnt update untill i open the source file. Anyone know how to update the target file without be necesary to ope...
It depends on the functions you're using.
Dynamic arrays and the following require the linked workbook be open:
AVERAGEIF, AVERAGEIFS, CELL, COUNTBLANK, COUNTIF, COUNTIFS, DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DSUM, GETPIVOTDATA, INDIRECT, OFFSET, SUMIF, SUMIFS