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 open the source file??
1 Reply
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
