named ranges in other workbooks

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

i have a range of cells whose values are validated from a list determined by
a name

the name is determined by a formula which references a range of cells in a
different workbook (i'm on a office network...)

the problem is:
if the other workbook is open (on my desktop?) the name is o.k. and the
validation is fine...
but:
if the other workbook is not open, the name results in an error

i didn't think that this is the way it's suppose to work...
AURGHH
 
Mark,
Do you use a full reference such as ='C:\Documents and Settings\Owner\My
Documents\Book1.xls'!profit
Bernard
 
yeah, i do...

=OFFSET('E:\@ Timesheets\[Job Nos for Timesheets.xls]Project
List'!$F$2,0,0,COUNTA('E:\@ Timesheets\[Job Nos for Timesheets.xls]Project
List'!$F$2:$F$130),1)
 
My guess is that OFFSET is one of those functions that need all files open.
Alternatively, experiment with a file that has no spaces in its name.
I try to avoid spaces in names because I have had network difficulties with
them.
Bernard

Mark Kubicki said:
yeah, i do...

=OFFSET('E:\@ Timesheets\[Job Nos for Timesheets.xls]Project
List'!$F$2,0,0,COUNTA('E:\@ Timesheets\[Job Nos for Timesheets.xls]Project
List'!$F$2:$F$130),1)



Bernard V Liengme said:
Mark,
Do you use a full reference such as ='C:\Documents and Settings\Owner\My
Documents\Book1.xls'!profit
Bernard

determined
Click to expand...
in
a and
the
Click to expand...
Click to expand...
 
Back
Top