Calculate text

[Guest]

I have created a formula which specifies a path and cell link by
concatenating text.
eg ='L:\Site Changes\40043\[40043 Change Template.xls]Sheet1'!$C$4
by concatenating various parts of the formula from other cells.

How can I get this to calculate? I can paste special as values, but then I
have to click in each cell for it to calculate. Settings are set on
Autocalculate, but it wont do it, even if I save, close, reopen, or press F9
(and permutations thereof).

Help

 

[Guest]

Just to make sure I am not misunderstanding. Rather than having a straight
link in a cell to someplace else, you are combining text in a cell to
"dynamically" create a link. If this is correct, I believe that you will
have to have the Source file open for the destination to update. If you have
a straight link then I believe that you do not have to have the source file
open. I guess a workaround is to have all possible links in another sheet in
the destination file and then "dynamically" create links to the other sheet.

This is my conclusion after much testing, but I could be wrong.