EXCEL question

[Jackie Wang]

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

[Jackie Wang]

I mean even if I do replace all, it still prompt me to pick the files for so many times.... any way to get around with this?

J. Byan