In my excel, there are more than one hundred cells which is referring to another file, official.xls:
=VLOOKUP(Date!G6,'P:\BASE\[Official.XLS]sheet1'!$A:$E,5,TRUE)
I would like to change it to the exact same file location:
P:\EXTEND
\official.xls
Hence:
=VLOOKUP(Date!G6,'P:\EXTEND\[Official.XLS]sheet1'!$A:$E,5,TRUE)
However, everytime when I change the cell, it prompt me in the window browser and asked me to
pick which file I would like to choose.
It's quite annoying that I have to pick p:\EXTEND\official.xls for >100 times.
Anyone can help me to turn the prompt off?
Really appreciated your help!
Regards,
Bryan