updating links to external data source

[maksinx]

Hello everyone,

I have a file called analysis and it has some formulas in it,which is linked to other data sources, where it gets data from company server,
i have nearly 40 rows of formula for each supplier and each customer
therefore below stated formula is used nearly 80 times,

what i want to do is to change the main data excel file, name sheet name as well but that time my all working formulas will return #ref.

is there any quicker way to change the link other source of data rather than changing the whole cell formulas manualy.

if you need further information please let me know.

thanks

sample formula is stated as below;

SUMPRODUCT(('C:\2007\Share\[ TRACKING 2007.xls]JUN 2007'!$J$2:$J$500="n/a")*('C:\2007\Share\[ TRACKING 2007.xls]JUN 2007'!$R$2:$R$500="not shipped")*(('C:\2007\Share\[ TRACKING 2007.xls]JUN 2007'!$AE$2:$AE$500="shirts")*('C:\2007\Share\[ TRACKING 2007.xls]JUN 2007'!$W$2:$W$500)))-I9

[Bob Phillips]

Just use Find & Replace Ctrl-H.

[maksinx]

dear xld,

it didnt work as i expected.Is there another way of doing it?

i had to complete afew step in order toget a result.

[Bob Phillips]

We don't have enough detail to give a meaningful answer. My attempt didn't work, presumably beacuse there is something that we (I) do not yet know.

[maksinx]

i think my reply seem offensive,which i didnt mean sorry about that
i will give you a further information hopefully within today.

thanks

[Bob Phillips]

Not at all mate, just trying to point out that just saying it didn't work does enlighten us too much. When someone suggests something, if it doesn't work, then it is best to say what happened, what you tried besides etc. In other words, the more info the better.