Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BREAK A FIND/REPLACE OPERATION
I often get in the problem of having a wrong filename/range/reference
inserted while updating a formula by way of FIND/REPLACE. The cells, if in quite a large number, do cause inconvenience upon popup of UPDATE VALUES. Any idea how to break such an operation? Thanx in advance! -- Best Regards, Faraz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
BREAK A FIND/REPLACE OPERATION
Faraz
How about using the 'Formula Auditing' mode for find/replace. To activate/deactivate use keys Ctrl and ~ If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: I often get in the problem of having a wrong filename/range/reference inserted while updating a formula by way of FIND/REPLACE. The cells, if in quite a large number, do cause inconvenience upon popup of UPDATE VALUES. Any idea how to break such an operation? Thanx in advance! -- Best Regards, Faraz |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
BREAK A FIND/REPLACE OPERATION
How can Formula Auditing help. Let me explain the issue more via an example:
I have five files opened: a) Comparison; b) File1; c) File2; d) File3; e) File4; I am using 669 cells of each of the four columns of Comparison.xlsx by inserting a vlookup formula so as to get the relevant figures from File1.xlsx, File2.xlsx, File3.xlsx and File4.xlsx. Instead of inserting entering formulas for all the four columns, I inserted the same for the first column and copied the same for the rest of the three. However, I selected the second column later and replaced the string "File1" with "File2" so as to have the same working for File2. But while changing the formula for Column3 instead of replacing "File1" with "File3" I accidently entered "File03" in the Replace With. Now, Excel has the popup of UPDATE VALUES so as to have the File03 be found and opened for each and every of 669 cells. -- Best Regards, Faraz "Jacob Skaria" wrote: Faraz How about using the 'Formula Auditing' mode for find/replace. To activate/deactivate use keys Ctrl and ~ If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: I often get in the problem of having a wrong filename/range/reference inserted while updating a formula by way of FIND/REPLACE. The cells, if in quite a large number, do cause inconvenience upon popup of UPDATE VALUES. Any idea how to break such an operation? Thanx in advance! -- Best Regards, Faraz |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
BREAK A FIND/REPLACE OPERATION
In tghis case unfortunately the only way out I find is to open the Task
Manager and close EXCEL and loose work on all other opened files as well. -- Best Regards, Faraz "Faraz A. Qureshi" wrote: How can Formula Auditing help. Let me explain the issue more via an example: I have five files opened: a) Comparison; b) File1; c) File2; d) File3; e) File4; I am using 669 cells of each of the four columns of Comparison.xlsx by inserting a vlookup formula so as to get the relevant figures from File1.xlsx, File2.xlsx, File3.xlsx and File4.xlsx. Instead of inserting entering formulas for all the four columns, I inserted the same for the first column and copied the same for the rest of the three. However, I selected the second column later and replaced the string "File1" with "File2" so as to have the same working for File2. But while changing the formula for Column3 instead of replacing "File1" with "File3" I accidently entered "File03" in the Replace With. Now, Excel has the popup of UPDATE VALUES so as to have the File03 be found and opened for each and every of 669 cells. -- Best Regards, Faraz "Jacob Skaria" wrote: Faraz How about using the 'Formula Auditing' mode for find/replace. To activate/deactivate use keys Ctrl and ~ If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: I often get in the problem of having a wrong filename/range/reference inserted while updating a formula by way of FIND/REPLACE. The cells, if in quite a large number, do cause inconvenience upon popup of UPDATE VALUES. Any idea how to break such an operation? Thanx in advance! -- Best Regards, Faraz |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
BREAK A FIND/REPLACE OPERATION
From your post..
Instead of inserting entering formulas for all the four columns, I inserted the same for the first column and copied the same for the rest of the three. I would prefer --Build the formula in the 1st column (1st row) --Copy the formula to the next 3 columns (again only in the 1st row) --Edit the formulas in the 3 columns (only in the 1st row) --Select the 4 cells of the first row; and then drag down the selection as required.. If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: In tghis case unfortunately the only way out I find is to open the Task Manager and close EXCEL and loose work on all other opened files as well. -- Best Regards, Faraz "Faraz A. Qureshi" wrote: How can Formula Auditing help. Let me explain the issue more via an example: I have five files opened: a) Comparison; b) File1; c) File2; d) File3; e) File4; I am using 669 cells of each of the four columns of Comparison.xlsx by inserting a vlookup formula so as to get the relevant figures from File1.xlsx, File2.xlsx, File3.xlsx and File4.xlsx. Instead of inserting entering formulas for all the four columns, I inserted the same for the first column and copied the same for the rest of the three. However, I selected the second column later and replaced the string "File1" with "File2" so as to have the same working for File2. But while changing the formula for Column3 instead of replacing "File1" with "File3" I accidently entered "File03" in the Replace With. Now, Excel has the popup of UPDATE VALUES so as to have the File03 be found and opened for each and every of 669 cells. -- Best Regards, Faraz "Jacob Skaria" wrote: Faraz How about using the 'Formula Auditing' mode for find/replace. To activate/deactivate use keys Ctrl and ~ If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: I often get in the problem of having a wrong filename/range/reference inserted while updating a formula by way of FIND/REPLACE. The cells, if in quite a large number, do cause inconvenience upon popup of UPDATE VALUES. Any idea how to break such an operation? Thanx in advance! -- Best Regards, Faraz |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
BREAK A FIND/REPLACE OPERATION
Good approach. This is usually what I do, but IF troubled in such a condition
I think there is no other way. Thanx anyway, pal! -- Best Regards, Faraz "Jacob Skaria" wrote: From your post.. Instead of inserting entering formulas for all the four columns, I inserted the same for the first column and copied the same for the rest of the three. I would prefer --Build the formula in the 1st column (1st row) --Copy the formula to the next 3 columns (again only in the 1st row) --Edit the formulas in the 3 columns (only in the 1st row) --Select the 4 cells of the first row; and then drag down the selection as required.. If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: In tghis case unfortunately the only way out I find is to open the Task Manager and close EXCEL and loose work on all other opened files as well. -- Best Regards, Faraz "Faraz A. Qureshi" wrote: How can Formula Auditing help. Let me explain the issue more via an example: I have five files opened: a) Comparison; b) File1; c) File2; d) File3; e) File4; I am using 669 cells of each of the four columns of Comparison.xlsx by inserting a vlookup formula so as to get the relevant figures from File1.xlsx, File2.xlsx, File3.xlsx and File4.xlsx. Instead of inserting entering formulas for all the four columns, I inserted the same for the first column and copied the same for the rest of the three. However, I selected the second column later and replaced the string "File1" with "File2" so as to have the same working for File2. But while changing the formula for Column3 instead of replacing "File1" with "File3" I accidently entered "File03" in the Replace With. Now, Excel has the popup of UPDATE VALUES so as to have the File03 be found and opened for each and every of 669 cells. -- Best Regards, Faraz "Jacob Skaria" wrote: Faraz How about using the 'Formula Auditing' mode for find/replace. To activate/deactivate use keys Ctrl and ~ If this post helps click Yes --------------- Jacob Skaria "Faraz A. Qureshi" wrote: I often get in the problem of having a wrong filename/range/reference inserted while updating a formula by way of FIND/REPLACE. The cells, if in quite a large number, do cause inconvenience upon popup of UPDATE VALUES. Any idea how to break such an operation? Thanx in advance! -- Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW 2 BREAK AN OPERATION | Excel Discussion (Misc queries) | |||
How do I search and replace with a line break? | Excel Discussion (Misc queries) | |||
Is it possible to replace a series of characters by a page break? | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |