Creating links to a worksheet on a network.
 

Hi,

Can link to a file in any directory or on the network by manually finding it
and pressing OK, but have loads to do so was hoping to write the links
myself. Now I know that the following works for a directory on my hard disk:

=sum('c:\data\[13.xls]Sheet1'!e17:e19)

but how is this changed for \\Server\c\dir1\subdir2[file.xls]!e3.....??

Have tried a mass of options but no joy.... Also want to break up the
strings and concatenate them so that can just change 1 variable per worksheet
- that still works, right??

Many thanks in advance.....
Peter