| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External Reference Not Valid ?
I keep getting errors for this external reference for my cell, and when I
don't get an error the cell says #REF instead of the data in the required cell in Book2. :-( ='[C:\ProgramFiles\systems\My Program\Data1\Book2.xls]Sheet1'!$A$2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
External Reference Not Valid ?
='C:\ProgramFiles\systems\My Program\Data1\[Book2.xls]Sheet1'!$A$2
"dim" skrev: I keep getting errors for this external reference for my cell, and when I don't get an error the cell says #REF instead of the data in the required cell in Book2. :-( ='[C:\ProgramFiles\systems\My Program\Data1\Book2.xls]Sheet1'!$A$2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
External Reference Not Valid ?
Thanks, she's working now.
"excelent" wrote: ='C:\ProgramFiles\systems\My Program\Data1\[Book2.xls]Sheet1'!$A$2 "dim" skrev: I keep getting errors for this external reference for my cell, and when I don't get an error the cell says #REF instead of the data in the required cell in Book2. :-( ='[C:\ProgramFiles\systems\My Program\Data1\Book2.xls]Sheet1'!$A$2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Reference is not valid | Links and Linking in Excel | |||
| 'reference is not valid' | Excel Discussion (Misc queries) | |||
| hyperlink reference not valid | Excel Worksheet Functions | |||
| ? Hyperlink; reference not valid ? | Excel Discussion (Misc queries) | |||
| Reference is not valid | Excel Worksheet Functions | |||
Hybrid Mode
