Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CALCULATE A LINK to a value
THANKS FRANK!!! YOUR SOLUTION WORKED AFTER INSTALLING THE
ADDIN!! -----Original Message----- Hi if the other workbook is opened you can use INDIRECT. In this case use: =INDIRECT("[test.xls]sheet1'!b4") But I would expect that the other workbook is closed (as the above INDIRECT function has no value). See:http://tinyurl.com/2c62u for some alternatives accessing closed workbooks. In your example INDIRECT.EXT (from the Morefunc.xll should work). So try (after installing this add-in): =INDIRECT.EXT("'c:\"& a1 & "\[test.xls]sheet1'!b4") -- Regards Frank Kabel Frankfurt, Germany aL wrote: Column 'A1' contains 08-09-03 Cell 'B1' contains "='c:\"& a1 & "\[test.xls]sheet1'!b4 The end result of b1 is ='c:\08-09-03\[test.xls]sheet1'! b4 I've been able to create the link. However it does not access the value that the link points to. Can this be corrected? Thanks in advance . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to link a few cell to Calculate | Excel Worksheet Functions | |||
Link or Calculate? | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
how do i link 3 worhseets to calculate into one | Excel Worksheet Functions |