I have a linked workbook that uses the following functions:
VLOOKUP - Works Fine when updating
SUM - Works Fine when updating
SUMIF - Returns Error if Source Workbook(s) isn't Active
DSUM - Returns Error if Source Workbook(s) isn't Active
The source workbooks are rather large, and I cannot open them simultaneously without the system becoming hopelessly slow or hanging up.
Any suggestions on how to overcome these problems ?
Thanks in advance