Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Edit; Replace All (Windows 98; 2000)

    How can I stop or cancel an Edit Replace All function. As an example, if I had 1,00 cells that I wanted to change a file that the cell references and, by mistake, I didn't create that file yet, I would have to hit "Esc" or click on Cancel 1,000 times. Is there a way to abort the Edit Replace All when this mistake occurs? Please help.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit; Replace All (Windows 98; 2000)

    I don't understand your question. Edit/Replace All only works on the file that is active when it is executed. Therefore, it should be impossible for the file to not be created yet. Could you give a little more detail about exactly what you are doing?
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit; Replace All (Windows 98; 2000)

    The search and replace is being done to linked cells.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    New Lounger
    Join Date
    Mar 2003
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit; Replace All (Windows 98; 2000)

    Yes it is being done to linked cells.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit; Replace All (Windows 98; 2000)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 16:59. to update link to http://www.bmsltd.ie/)</P>The easiest is to open a new instance of Excel, create the file you inadvertantly didn't create, close that session and then try to cancel the S&R in the other session.

    Alternatively, use my flexfind utility which *can* be interrrupted by hitting control-break after OK-ing the file open dialog. Find it at http://www.bmsltd.ie/mvp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •