Hi,
Try
=INDIRECT("'[temp.xls]125'!"&"A1")
Replace the 'temp.xls' with the file name you need and replace the cell
A1 with the cell you need.
Note that Indirect works only when the source workbook is open.
Govind.
Ken Cobler wrote:
> I am getting messed up on the grammar for this function. I am trying to
> refer to a Worksheet called "125" - - which is on a different (opened)
> Workbook.
>
> How do I use the INDIRECT function so that it will go to a specific
> Workbook, pick the correct '125' tab on that workbook, and return to me a
> fixed cell value?
>
> Thanks for your help. Excel Help is not clear about the grammar.
>
> Thanks.
Bookmarks