Links to external files

[StewartCooke]

Can anybody suggest a way to link to cells in other workbooks without opening them.
The file-name of the link model changes depending on who is using the model so this is held in a seperate cell to the rest of the formula.eg. I've then been using =Indirect(c4,"y11"), where c4 holds the file name and "y11" is the cell reference. This works fine if the other file is in memory, but will error when it is closed. [I used to use the @@ command in Lotus, which worked ok]. Any Ideas ??

 

[Mudface]

Just copy the cells you want to link to and, in a new workbook, Paste Special- Paste Links. When you open up the new workbook, it will automatically update itself without you needing the source book open.

 

[StewartCooke]

That doesn't work because different users will select a different file to link to. I suppose I could use that and write a macro to find and replace filenames within the formula.