Problem with indirect from cell on external worksheet

[Guest]

I am having a problem indirectly addressing a cell on a
second worksheet (that is open). I found this article
and when I tried the example it did now work similarly.

http://support.microsoft.com/?kbid=151323

When I simplified the example to indirect(a2) where a2
was '[book1.xls]sheet1'!a1 it also failed.

Thanks for your help.

 

[Harlan Grove]

I am having a problem indirectly addressing a cell on a
second worksheet (that is open). I found this article
and when I tried the example it did now work similarly.

http://support.microsoft.com/?kbid=151323

When I simplified the example to indirect(a2) where a2
was '[book1.xls]sheet1'!a1 it also failed.

How did it 'fail'? Did it return #REF!, some other value that wan't equal to
that of '[book1.xls]sheet1'!A1, Excel wouldn't allow the formula to be entered,
what?

 

[Guest]

I'm sorry - it failed with a #ref in the function. The
example as I understand it should have resulted in "This
is a test" in In Book2, Sheet1, cell B1

 

[Peo Sjoblom]

Works for me.. What failed, do you get a #REF error?
I named a workbook book1.xls, copied your example from your post and
it worked..

 

[Harlan Grove]

I'm sorry - it failed with a #ref in the function. The
example as I understand it should have resulted in "This
is a test" in In Book2, Sheet1, cell B1

I'm going to guess that Book2 hasn't been saved, so it doesn't have a file
extention. Try entering

[book2]Sheet1!B1

in cell A2 of the active worksheet in the active workbook. Then try

=INDIRECT(A2)