Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |