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