#REF error

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

Guest

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.
 
Check your other thread.

Todd said:
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.
Click to expand...
 
Thank you.

Dave Peterson said:
Check your other thread.

Todd said:
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.
Click to expand...
Click to expand...
 
Back
Top