How do I copy and paste formulas to new workbook

When I copy and paste several cells of formulas and paste them into another workbook I get the formula but with a reference to the other worksheet

For example i get from =COUNTIF('Call 1'!D7:E7, "N") to =COUNTIF('[BLANK FORM.XLSM]Call 1!'D7:E7,"N")

How do I copy and paste formulas like that? I have several formulas I am doing at once, so copy and pasting individual formulas is not reasonable. Macros wouldn't be either because I have to make the change to about 80 workbooks and that would be to complicated for my staff to assist me with. None of them have messed with Macros.

Thanks FDibbins but as I mentioned "I have several formulas I am doing at once, so copy and pasting individual formulas is not reasonable." Any other ideas?