External Reference Not Valid ?

D

dim

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
 
E

excelent

='C:\ProgramFiles\systems\My Program\Data1\[Book2.xls]Sheet1'!$A$2


"dim" skrev:
 
D

dim

Thanks, she's working now.

excelent said:
='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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Box - For Input Range can I use named range in another workbo 2
Cumulative formula for word table 0
Stopping reference following when rows are inserted. 3
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Designating a workbook reference base on a cells contents 2
Prevent List Box Reference from Changing when workbook closes? 3
Pulling Data from External Worksheets 4
Mapping integers to strings 6

Top