I have a sheet that thousands of cells in it are linked to a certain external workbook named F:\File1.xls.
Now I want to change the link to File2.xls on the same path. So what I did was simply find "File1.xls" and replace with "File2.xls".
Problem is that instead of typing "File2.xls" in the replace box, I mistakenly typed "Fiel2.xls" which is non-existent. So no excel asks me for the file for each individual cell that should be linked to. It entails that I press ESC for several thousands times.
Is there and easy way out?
Thanks.
Now I want to change the link to File2.xls on the same path. So what I did was simply find "File1.xls" and replace with "File2.xls".
Problem is that instead of typing "File2.xls" in the replace box, I mistakenly typed "Fiel2.xls" which is non-existent. So no excel asks me for the file for each individual cell that should be linked to. It entails that I press ESC for several thousands times.
Is there and easy way out?
Thanks.