Hi SU,

Firstly, the INDIRECT function doesn't have an '.EXT' extension.
Secondly, when used with external workbooks, the INDIRECT function only
works if the source workbook is open. If the source workbook is not open,
the INDIRECT function returns #REF!

Cheers


"SU" wrote in message
...
I am trying to use INDIRECT.EXT function to get values from a different
worksheet.

I am typing the path in a cell in the following format in cell A1:

"'G:\Operations\Timesheets\2005\[2005_abcd.xls]YTD'!$N$6"

and then using

INDIRECT.EXT(A1) function

but I am getting #REF instead of any values.

Can anybody help resolve this or suggest a better option. I have to type
the path there is no way around it. Please help.