Some functions, such as INDIRECT and SUMIF, need the linked workbooks open to
return a value. If your links are in formulas with this limitation, that
would cause the #VALUE error if the linked workbooks aren't also open.

SUMIF can be replaced with SUMPRODUCT, which does work with closed
workbooks. Without knowing the nature of your links (which formulas are using
them), it's hard to give specific advice.

Hope this helps,

Hutch

"Frustrated" wrote:

I need to find out how to have Workbook A update automatically when opened
with data from Workbook B. At this point when i open Workbook A it currently
asks if i would like for it to update and if i click yes, it doesn't update
it changes all my formulas to #VALUE. But if i go open Workbook B myself,
Workbook A corrects itself. How can i fix this?