Sorry, INDIRECT does not work with closed workbooks. Do a Google Groups
search using "indirect" and "closed" as keywords and you will find some
workarounds, notably by John Walkenbach and Harlan Grove.
--
Vasant
http://google.com/groups?selm=3F5E56...9DB0%40msn.com
"jC!" wrote in message
om...
hi all,
hope someone can help on following:
trying to use the INDIRECT function within Excel 2003 to refer to an
other closed work book and i receive an #REF! error - i go as follow =
if
B1 ='C:\Documents and Settings\TestPlan\[Reports.xls]TestScripts'!F4
this will give me 294 as a result (the value in the respective cell,
which is correct)
however if
B1 =INDIRECT("'C:\Documents and
Settings\TestPlan\[Reports.xls]TestScripts'!F4")
this will give me a #REF! error
i tried adding the ~symbol to the 'quotes, but to no avail
any help is mostly appreciated and thanks in advance
cheers...
....jurgenC! :)