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 how to copy a formula in Excel between workbooks without links, in a hassle-free fashion.
- Press Ctrl + ` or click the Show Formula icon under the FORMULAS tab. This will show formulas instead of cell values.
- Select cells with formulas to be copied, and copy them by pressing the Ctrl + C keys or the right-click menu.
- Open Notepad, or any basic word processor, and paste the data here.
- Select all ( Ctrl + A ) and copy ( Ctrl + C ).
- Activate the target workbook, select the top left cell of the range you want to place formulas in, and paste by pressing Ctrl + P or using the right-click menu.
- The copied data will not contain any links between workbooks.