Find and Replace
You can use Edit/Replace/Options/Search in formulae/Replace all, but I don't
know any way to switch off prompt to update links.
Regards,
Stefi
€˛MarkN€¯ ezt Ć*rta:
Hello,
I have a load of workbooks in different locations where the location of one
of the links has changed. I'm not sure how to go about this but what I want
to be able to do is
-select a workbook but not be prompted to update links
-find any formulas with links including "Z:\" and replace with "F:\"
anywhere in the workbook.
--
Any help appreciated,
MarkN
|