#value! errors on cells with links to other spreadsheets

[lofquist]

I need some help. I have a series of files with links to other supporting files. If I have both of the linked files open values are updated with out any errors. If I open the primary file and leave the secondary files closed I get the #value! error in all of the linked cells. If I then open the secondary file the correct values are displayed.

Any help would be appreciated.
Thanks

 

[Aladin Akyurek]

I need some help. I have a series of files with links to other supporting files. If I have both of the linked files open values are updated with out any errors. If I open the primary file and leave the secondary files closed I get the #value! error in all of the linked cells. If I then open the secondary file the correct values are displayed.

Any help would be appreciated.
Thanks

You might be using formulas that require the target books to be open.

 

[lofquist]

This is one of the formulas:


=ROUND((SUMIF('C:\Documents and Settings\blofquist\Desktop\BUDGET\2006\200\HR\[200-PR.xls]Sheet1'!$B$20:$B$24,CONCATENATE("<",TEXT(E5,0)),'C:\Documents and Settings\blofquist\Desktop\BUDGET\2006\200\HR\[200-PR.xls]Sheet1'!$J$20:$J$24))/12,0)

 

[Aladin Akyurek]

This is one of the formulas:


=ROUND((SUMIF('C:\Documents and Settings\blofquist\Desktop\BUDGET\2006\200\HR\[200-PR.xls]Sheet1'!$B$20:$B$24,CONCATENATE("<",TEXT(E5,0)),'C:\Documents and Settings\blofquist\Desktop\BUDGET\2006\200\HR\[200-PR.xls]Sheet1'!$J$20:$J$24))/12,0)

SumIf cannot cope with closed books. Try:

=ROUND(SUMPRODUCT(--('C:\Documents and Settings\blofquist\Desktop\BUDGET\2006\200\HR\[200-PR.xls]Sheet1'!$B$20:$B$24 < E5),'C:\Documents and Settings\blofquist\Desktop\BUDGET\2006\200\HR\[200-PR.xls]Sheet1'!$J$20:$J$24)/12,0)

 

[lofquist]

Thanks!!!