| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the link?
As long as DataSource.xls is open, you could use:
=indirect("'[DataSource.xls]" & b1 & ".ABC'!$C$2") =indirect() won't work if the "sending" workbook is closed. Eric wrote: ='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but I would like to retrieve the value 6227 from cell B1 for this statement instead of manually input the value 6227 into the string. Does anyone have any suggestion? Thank you in advance Eric -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i edit link source in whole workbook? | Excel Discussion (Misc queries) | |||
| Link to external link | Excel Worksheet Functions | |||
| Add Permission did not work in "Allow User to Edit Ranges" | Excel Discussion (Misc queries) | |||
| Can't find Edit, links dialogue box to break the link | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
Hybrid Mode
