Can’t copy Formulas from one workbook to another

Do you have the two workbooks open in separate instances of Excel?

To paste formulas, you need both workbooks open in the same instance.