Bulk find and replace mistake

[ksh]

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?

 

[Rick Rothstein \(MVP - VB\)]

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

 

[T. Valko]

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).

 

[ksh]

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.

 

[Arvi Laanemets]

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.

 

[ksh]

Thank you. That does answer the question.

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.