Hi there.

I have a spreadsheet (which i will call file A) that by using the
formula SUMIF retrieve some information from an other spreadsheet (file
B) which contains reference to another file (file C).

the formula in file A works fine if file B is open (please note that I
don't have access to file C) but whenever file B is closed it shows the
error "#VALUE!". As I have dozens of files B (one for each day) I cannot
open them all and I was wondering if there is a way to solve my
problem.

I hope I was clear enough...

Rgds

Massi


--
massi
------------------------------------------------------------------------
massi's Profile: http://www.excelforum.com/member.php...o&userid=29202
View this thread: http://www.excelforum.com/showthread...hreadid=489446