You may have noticed that Excel generates links between workbooks, when you copy and paste a formula from one to the other. These links between worksheets call the original workbook for the formula you need in the present workbook. To get rid of them, you need to break the links, or find and delete them manually. In this article we’re going to show you another method to copy a formula in Excel between workbooks without links, in a hassle-free fashion.
- Select the formula(s) you want to copy.
- Press the Ctrl + H keysto open the Find & Replace window. Alternatively, you can go to HOME > Find & Select > Replace
- Enter an equal sign ( = ) into the Find what box. Then, go to the Replace with field and press the space key to leave it empty.
- Click the Replace All button to replace all equal characters with spaces.
- When the formulas are still selected after the replace action, copy them by pressing Ctrl + C or using the right-click menu.
- Activate the target workbook, and select the top left cell of the range you want to place the formulas. Paste by pressing Ctrl + P or using the right-click menu.
- While copied formulas are still selected, open the Find & Replace window again. This time, go to the Find what box and press the Space key in and enter an equal sign into the Replace with field.
- Click the Replace All button to replace all space characters with equal characters. All copied text will show values of the formulas. .