| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using variable in external links
Dear all,
Is is possible to use value store in other cells in external links? Say I have a list of filename on column A apple.xls orange.xls banana.xls ..... and thousands more. How can I build external links to these workbooks by formula easily? Like this for example, ='C:\apple.xls\Sheet1'!$A$4 ='C:\orange.xls\Sheet1'!$A$4 ='C:\banana.xls\Sheet1'!$A$4 Any help would be highly appreciated. Thanks & regards, Automne |
|
#2
|
|||
|
|||
|
See if the INDIRECT function will help.
On Sat, 5 Mar 2005 01:48:58 +0800, "automne" wrote: Dear all, Is is possible to use value store in other cells in external links? Say I have a list of filename on column A apple.xls orange.xls banana.xls .... and thousands more. How can I build external links to these workbooks by formula easily? Like this for example, ='C:\apple.xls\Sheet1'!$A$4 ='C:\orange.xls\Sheet1'!$A$4 ='C:\banana.xls\Sheet1'!$A$4 Any help would be highly appreciated. Thanks & regards, Automne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| external links | Excel Worksheet Functions | |||
| How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
| If I don't have children open I get #REF! where external links are | Excel Discussion (Misc queries) | |||
| Pivot tables, external data sources and ODBC links | Excel Worksheet Functions | |||
| Save External Link Values | Excel Discussion (Misc queries) | |||
Linear Mode
