#REF error
 

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.

#REF error
 

Check your other thread.

Todd Lietha wrote:

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

#REF error
 

Thank you.

"Dave Peterson" wrote:

Check your other thread.

Todd Lietha wrote:

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