#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
|