Harlan & Laurent
I can't use ='G:\Operations\Timesheets\2005\[2005_abcd.xls]YTD'!$N$6
directly since I am trying to achieve automation so when new employees join
in their timesheet will automatically updated just by adding a name.

I suspect my answer may not make any sense to you (it doesn't to me!) but I
am looking for an alternative rather than typing the link.

Any suggestion will be appreciated. I'll try any alternative that you may
offer. Many many thanks.


"Harlan Grove" wrote:

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 ).