| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
