Have you tried using the Edit | Links options off the menu?

You should be able to tell Excel to change all the links from one book to
another



"ww" wrote:

Hi all,

I have a problem I was hoping someone could help me with. What I'm doing is
using a =sumif() to pull some numbers from different files. On the files
that I'm pulling the information from I have two ranges named Code and
Current and we'll call the actual file names Table.xls, Table1.xls,
Table2.xls, etc. On the file that I'm trying to pull the information into I
have =sumif('Table.xls'!Code,A5,'Table.xls'!Current) in C5.
This pulls the information fine but I have 300 rows I have this formula in.
I want to be able to just put the file name like Table.xls in C4 and have it
update all the rows without having to change the formula and copy it down
each time I change the file name. That way I could just change the file name
from Table.xls to Table1.xls in C4 and have everything update automatically.
I tried =sumif($C$4!Code,A5,$C$4!Current) but that wasn't working work. Does
anybody know of a way to do this? Thanks for any help you can offer.

ww