Vlookup showing full server name

[pdchislett]

Hi,

I have a simple vlookup formula which links to another file.

If I close the file and go back into it, instead of showing the path to the external file as...

Vlookup(A1,'M:\ABC\XYZ\example.xls

It shows....

'Vlookup(A1,'\\serverdetail\severdetail\ABC\XYZ\example.xls.

When I try to update links it doesnt recognise the file or if I open it manually it doesnt recognise that I have it open.

Any ideas?

Thanks

 

[Andrew Poulsom]

Which version of Excel are you using, because I can't reproduce that behaviour in Excel 2000 (the path doesn't change to a UNC)?

 

[pdchislett]

2003

 

[Andrew Poulsom]

Perhaps someone else can help then, as I don't have Excel 2003 in a network environment.

 

[GlennUK]

My disk/folder references stay OK and don't change to UNC. Is there something that you are doing that you haven't told us about?

 

[pdchislett]

No - don't think so. It doesn't happen on every file, just a few.

 

[GlennUK]

Do you always open your files from within Excel by pointing to the mapping drive rather than at a UNC? I would imagine that launching from a UNC in an Explorer window would confuse Excel.