Link to external workbook

R

R Ormerod

I want to change a formula linking to a cell in a workbook on another server
so that the server name is used rather than the drive mapping.

I have tried the following but I keep getting 'File Not Found':

'\\Server Name:\Drive Name\......

(instead of 'G:\.....

Please advise.
 
D

Dave Peterson

\\Server Name:\Drive Name\

Doesn't look like a valid format...

I think I'd use windows start button|run
type in
\\servername
and point and click down the paths to find the correct workbook.

If you turn "View|toolbars|address bar", then you may be able to see the path
(or even copy|paste).
 
Top