Problem with indirect from cell on external worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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?
 
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
 
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..
 
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
Click to expand...

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)
 
Back
Top