Hi. This is Pritesh from India. I need to know whether after using "=Sum(if("
formuls (array), which is linked to external file, can we change it's source
file by "Edit Links Change Source"?

In other words, I have used "=Sum(if(" formula to derive values from
external excel file (used array method in it). Now I want to change source
file from Jul06 to new file Aug06. I am doing this by going to Edit Links
Change Source, but, getting error "Reference is not valid. Reference must be
to an open worksheet"

How can I resolve this. Please help.