HOW 2 BREAK AN OPERATION
 

After creating a template consisting of thousands of links of a sheet in the
same workbook, I, upon updating the formula so as to link it with other sheet
used the Find & Replace mode as:
Find: "Sheet1"
But mistakenly, instead of "Sheet2", entered
Replace With: Shet2
Sure am in a troublesome mess of opening of Update Values dialogue box again
and again for each and every entry.

Any idea how to break such an operation?

--
Best Regards,
FARAZ A. QURESHI

HOW 2 BREAK AN OPERATION
 

It is EXCEL 2007 version.
--

Best Regards,
FARAZ A. QURESHI


"FARAZ QURESHI" wrote:

After creating a template consisting of thousands of links of a sheet in the
same workbook, I, upon updating the formula so as to link it with other sheet
used the Find & Replace mode as:
Find: "Sheet1"
But mistakenly, instead of "Sheet2", entered
Replace With: Shet2
Sure am in a troublesome mess of opening of Update Values dialogue box again
and again for each and every entry.

Any idea how to break such an operation?

--
Best Regards,
FARAZ A. QURESHI

HOW 2 BREAK AN OPERATION
 

Sometimes killing excel in the task manager is the best way.



FARAZ QURESHI wrote:

After creating a template consisting of thousands of links of a sheet in the
same workbook, I, upon updating the formula so as to link it with other sheet
used the Find & Replace mode as:
Find: "Sheet1"
But mistakenly, instead of "Sheet2", entered
Replace With: Shet2
Sure am in a troublesome mess of opening of Update Values dialogue box again
and again for each and every entry.

Any idea how to break such an operation?

--
Best Regards,
FARAZ A. QURESHI

--

Dave Peterson