| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro operation | Excel Worksheet Functions | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| what does $ operation mean | New Users to Excel | |||
| ilegal operation | Links and Linking in Excel | |||
| Conditional operation | Excel Worksheet Functions | |||
Linear Mode
