View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
palcamb palcamb is offline
external usenet poster
 
Posts: 1
Default How to stop search / replace prosess in large excel worksheets

I use large worksheets with links to other workbooks stored in another path
on the computer.
If (or when) i write a wrong link in the "search for", and click on replace
all, there is no way to stop the prosess. Then i have to click cancel until
the prosess have reach the last link in the sheet - 100 or 1000 times
If anyone understand the problem, and have a solution - please respond