Excel Links reporting an error when they are correct

[Dagk]

Hi,

I have an excel file A which is linked to another excel file B. Every time file A is opened it complains that it cannot find the linked file but when you update the path it still complains that it cannot find the file. Anyone one know why this is happening? Thanks.

 

[ETID]

Can file A find file B if they are both opened?

 

[Dagk]

Yes. They can both find each other and some of the links appear to be working.

 

[ETID]

Is this link part of an operation formula in Book A...

=('C:\My Documents\[Book B.xls]Sheet1'!$A$1 * B1)/C1

as opposed to just the "link" formula that returns the value...

='C:\My Documents\[Book B.xls]Sheet1'!$A$1

 

[Dagk]

It is part of an opeartor formula e.g. it is subtracting one cell's value in file B from another cell's value in file B and displaying this final value in file A.

 

[ETID]

Try to doing the operation in book A after the values come in from the link(s)

That is... link the two values from B into seperate cells in Book A then perform the operation exclusivly in book A.

 

[ETID]

....or do all the clacs. in book B then link book A to the result.