I have an excel workbook linked to several other workbooks (all of which
change names - i.e. a date indexing: filename_date.xls). They also live on
different servers, so I am trying to set the full server names
\\server\folder\etc. If I use the defined path, i.e. W:\, indirect works,
but when I change the the W:\ to \\server\folder, it doesn't - I get #REF!

I need to use the full server path becuase the file will be shared among
others who have different paths set up

Thanks!