I have to copy 120 thousand formulas from one xls file to another. After a simple copy-paste, the original file name is inserted into the formula, not good. I tried to remove it with Data - Links, but there was an error. So I decided to replace the = sign with q1g, so it is not recognized as an equasion, copy-pasted it, and tried to change q1g back to =. The problem is, an open dialog window pops up for every single formula. After I hit escape, it works, but I have to click Replace All again. Obviously, I do not want to do this 120000 times. How can I copy formulas without difficulties?
If you want to copy the formulas, just copy them "normally", i.e. with creating the links in the first step. Then try either of the following: