| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the Source Address of a Link
I have this problem:
Book1 is my source and Book2 is my target. I have pasted the following link in Book2 which returns the cell value of C10 in Book1. This works fine for me. '[Book1.xls]Sheet1'!$C$10 However, if I try to change the above statement's cell address $C$10 to $C$20 (say), it won't link to Book1 C20, instead it gives a TEXT content as ='[Book1.xls]Sheet1'!$C$20 Can anyone help to solve this puzzle? Thank you. zhj23 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the source of a link | Excel Discussion (Misc queries) | |||
| changing a cell to changing the link | Excel Worksheet Functions | |||
| Changing the source of links. | Excel Discussion (Misc queries) | |||
| changing query source | Excel Worksheet Functions | |||
| worksheet copying, changing source link | Excel Worksheet Functions | |||
Threaded Mode
