Results 1 to 2 of 2
2006-12-31, 11:28 #1
- Join Date
- Nov 2002
- London, Gtr London, England
- Thanked 0 Times in 0 Posts
Aborting a Dialogue box (2003 sr2)
A simple question... I have a sheet that holds formulae that I want to do a global change to, the change is to a reference that has now changed. If I type the wrong thing i.e something non-existent in the replace string a dialogue appears, this expects a file to be identified. However it is a typing mistake on my part. The string to be replaced occurs about 300 times in the sheet and Cancel, or Close or EScape only cancel the current replacement request, which means I have to press escape 300 times!! is there a magic shortcut that will mean "abort current instruction(s)" and take me out of the whole loop?
thank you, margie
2006-12-31, 11:46 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Aborting a Dialogue box (2003 sr2)
There's no really good way out of this, but you could use the following trick.
Let's say that you entered Blah in the 'Replace with' box, and Excel is now looking for a workbook named Blah.xls.
Start a second instance of Excel, and save the blank new workbook as Blah.xls.
Close the second instance of Excel again.
(You could also copy/paste an existing workbook in Windows Explorer and rename the duplicate to Blah.xls instead of starting a second instance of Excel)
Return to the original instance, and select Blah.xls in the dialog, then click OK.
The Replace operation should now continue without further prompting. Its result is nonsense, of course, but you can now use Undo (Ctrl+Z) to restore the previous situation, then try Edit | Replace again.