I just did a find and replace on a large section of formulas. Unfortunately I
made a typo and the sheet name is not correct. Is there a way other than
hitting cancel for every entry to get out of the update values cancel loop
that results in this situation?

I'm not sure what dialog you are in where you can cancel the Replace
function one-at-a-time, but two thoughts come to mind for you to try...

1. Hit the Esc key. Does that cancel out the entire dialog box?

2. If not, let the replace go through for all the cells and then re-run it
to replace the mistake with the correct text.

Rick


"ksh" wrote in message
...
I just did a find and replace on a large section of formulas. Unfortunately
I
made a typo and the sheet name is not correct. Is there a way other than
hitting cancel for every entry to get out of the update values cancel loop
that results in this situation?

Hello and thank you for your quick response. I didn't explain well enough.
The typo I made was the name of a workbook that is used in the formulas in
all of the cells I tried ot update. The update values is because it won't
just default to the incorrect name. It knows the workbook doesn't exist so
it wants me to pick the correct workbook. The problem is that it does each
update individually.

"Rick Rothstein (MVP - VB)" wrote:

I'm not sure what dialog you are in where you can cancel the Replace
function one-at-a-time, but two thoughts come to mind for you to try...

1. Hit the Esc key. Does that cancel out the entire dialog box?

2. If not, let the replace go through for all the cells and then re-run it
to replace the mistake with the correct text.

Rick


"ksh" wrote in message
...
I just did a find and replace on a large section of formulas. Unfortunately
I
made a typo and the sheet name is not correct. Is there a way other than
hitting cancel for every entry to get out of the update values cancel loop
that results in this situation?

You can try doing Undo if you haven't done a bunch of stuff afterwards and
maxed out the Undo stack to where the Find/Replace has been "bumped" off the
stack.

You could close the file without saving changes (you'll lose any work you've
done but it might be worth the trouble).

--
Biff
Microsoft Excel MVP


"ksh" wrote in message
...
I just did a find and replace on a large section of formulas. Unfortunately
I
made a typo and the sheet name is not correct. Is there a way other than
hitting cancel for every entry to get out of the update values cancel loop
that results in this situation?

Hi

Close excel from Task Manager, and then reopen the file.

When replacing many formulas, do it block-wise. Replacing 1/4 of datarange
at once, and repeating this 4 times, may take 10th of time, you need to do
it at one go, sometimes.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"ksh" wrote in message
...
I just did a find and replace on a large section of formulas. Unfortunately
I
made a typo and the sheet name is not correct. Is there a way other than
hitting cancel for every entry to get out of the update values cancel loop
that results in this situation?

Thank you. That does answer the question.

"Arvi Laanemets" wrote:

Hi

Close excel from Task Manager, and then reopen the file.

When replacing many formulas, do it block-wise. Replacing 1/4 of datarange
at once, and repeating this 4 times, may take 10th of time, you need to do
it at one go, sometimes.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"ksh" wrote in message
...
I just did a find and replace on a large section of formulas. Unfortunately
I
made a typo and the sheet name is not correct. Is there a way other than
hitting cancel for every entry to get out of the update values cancel loop
that results in this situation?