edit link source

[Joel]

i have 1 workbook that is my destination file (that contains formulas and
data from source file). And many workbooks as my source file. Im trying to
update my destination file everytime there is an update or "new source file"
created.

I tried using edit-link to change and update the source. I edited the
relevant spreadsheet, 1 of the cell formular to read the new source file and
tried updating. But the rest of the cell will not read the new source, only
the edited cell. What can i do besides using replace function, so that when i
"change" the new source in 1 cell, the rest of my spreadsheet will read the
same source name ? **(i cant change the new source as my other worksheets
will read.)

tks.

 

[macropod]

Hi Joel,

You could put the worksheet path and/or filename in a cell, then use the INDIRECT function in all the other cells to build their
references from that. However, if you do this, the links won't work unless the source workbook is open.

Cheers