Heres my problem,

=sum([trackingtemplate.xls]sheet1!a4)
I have this formula but different cells, ie. a5 a6 a7. This is my template
program which is what I will be using year after year.

I need to now change the file to...
=sum([Payroll0910.xls]sheet1!a4)
I tried the replace key, but it wants me to go and locate the file for all
937 cells that have that in it. It is very inconveinent to do that.

Isn't there a easier way?

Thanks.