Link to external workbook

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.
--
R Ormerod

\\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).



R Ormerod wrote:
>
> 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.
> --
> R Ormerod

--

Dave Peterson