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