In my excel, there are more than one hundred cells which is referring to another file, official.xls:
I would like to change it to the exact same file location:
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!