I'd like to copy the text of a formula in a cell, then paste that text into a cell in a different workbook, without the formula changing.

I can't use 'copy' then paste special xl paste formulas, because the reference changes when the formula is pasted into the other workbook.

What would be the best way of doing this?

To provide a simple example, let's say

cell A1 has the formula =C1+C2 in Sheet 1 of Book 1 (a new workbook).

if you copy cell A1 in Book 1, then paste that formula into cell D5 of Book 2 (another new worbook), the formula changes to "=F5+F6"

However, I need to be able to transfer the formula as it is, because Book 2 doesn't have the formula but it needs to be inserted into that book during an import process.

The real formula is a lot longer (over 60 arguments).

Please let me know if you'd like me to clarify the question further, thanks.