View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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