Link to file

[fcohen]

Hi all,

I have this situation:
In cell A1: c:\test\myfile.xlsx

I want to have a formula in B1 that get's the value of C1 in myfile.xlsx but this must be updated if in A1 I change the file name.


Is this possible?

Thank you,
FC.

 

[Andrew Poulsom]

You can use INDIRECT, but the source workbook must be open. Why don't you just Edit Links and change the Source?

 

[fcohen]

Thank you Andrew for your answer,
I'm trying to do like this because I will build a table with several columns. In the first column I will insert the folder&file name to link and then in the other columns the formulas will be the same in each row of my table...

 

[Andrew Poulsom]

I don't see how that makes a difference, sorry.