Thread: External Reference Not Valid ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default 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
Reply With QuoteReply With Quote