ExcelBanter - External Reference Not Valid ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - External Reference Not Valid ? (https://www.excelbanter.com/excel-worksheet-functions/171225-external-reference-not-valid.html)

dim

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

excelent

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

dim

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

All times are GMT +1. The time now is 07:09 PM.