SU wrote...
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.
....

Any reason you're not simply using

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

?

If cell A1 is the result of a formula, then there are simply some
configurations of Windows and Excel/Office under which INDIRECT.EXT
doesn't work. Laurent Longre and I corresponded about this two years
ago, but there was no resolution. FWIW, it didn't work on my wife's Pc
running Windows Me and Excel 2000, but it works on the other PCs I use.

Alternatives:

http://groups-beta.google.com/group/...443753560f0075

(or http://makeashorterlink.com/?F2993260A ).