Links to external files

StewartCooke · Mar 4th, 2002, 05:45 AM

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 · Mar 4th, 2002, 05:53 AM

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 · Mar 4th, 2002, 06:10 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 05:45 AM	#1
StewartCooke New Member Join Date: Mar 2002 Location: Leicestershire, England Posts: 48	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 ??

Mar 4th, 2002, 05:53 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.

Mar 4th, 2002, 06:10 AM	#3
StewartCooke New Member Join Date: Mar 2002 Location: Leicestershire, England Posts: 48	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.