View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AliGoLightly AliGoLightly is offline
external usenet poster
 
Posts: 1
Default my vlookup path changes when I open the file

I have a VLOOKUP in workbook 'Report' which looks for data in workbook 'Data'.

both workbooks are stored in a common network drive \\office\reports\

the VLOOKUP is written to look in the network drive:
=vlookup(a2,'\\office\reports\[data.xlsx]sheet1'!a:f,6,false)

Often, when one of my team leaves the file, the VLOOKUP changes to
=vlookup(a2,'g:\[data.xlsx]sheet1'!a:f,6,false)

How do I stop it changing from the Network path to the mapped drive?