#REF error

[Todd Lietha]

I have two workbooks in the same directory. "C:\Todd 2"

In wkbk1 i am creating references to cells in wkbk2 using INDIRECT [for
reasons that i'll save you the details of here].

In wkbk1, if I enter =[wkbk2.xls]sheet1!A6 it resolves correctly.
Likewise, in wkbk1 if I enter =INDIRECT("[wkbk2.xls]"&G10&"!A6") it
resolves correctly, **if wkbk2 is already open** Note: G10 contains the
literal sheet1

But, if I save wkbk1, close both workbooks, and reopen just wkbk1, I get a
#REF error.

 

[Dave Peterson]

Check your other thread.

I have two workbooks in the same directory. "C:\Todd 2"

In wkbk1 i am creating references to cells in wkbk2 using INDIRECT [for
reasons that i'll save you the details of here].

In wkbk1, if I enter =[wkbk2.xls]sheet1!A6 it resolves correctly.
Likewise, in wkbk1 if I enter =INDIRECT("[wkbk2.xls]"&G10&"!A6") it
resolves correctly, **if wkbk2 is already open** Note: G10 contains the
literal sheet1

But, if I save wkbk1, close both workbooks, and reopen just wkbk1, I get a
#REF error.

 

[Todd Lietha]

Thank you.

Check your other thread.

I have two workbooks in the same directory. "C:\Todd 2"

In wkbk1 i am creating references to cells in wkbk2 using INDIRECT [for
reasons that i'll save you the details of here].

In wkbk1, if I enter =[wkbk2.xls]sheet1!A6 it resolves correctly.
Likewise, in wkbk1 if I enter =INDIRECT("[wkbk2.xls]"&G10&"!A6") it
resolves correctly, **if wkbk2 is already open** Note: G10 contains the
literal sheet1

But, if I save wkbk1, close both workbooks, and reopen just wkbk1, I get a
#REF error.