Copy formula to another workbook but refers to new workbook

[EasterGreen]

If I copy a formula from the worksheet 'List' in one workbook to the same named worksheet in another, say:
=sumif('Data'!$b$4:$b$44,'List'!$b4,'Data'!$c$4:$c$44)
It automatically inserts links to the old workbook:
=sumif('[Old book .xlsx]Data'!$b$4:$b$44,'[Old book .xlsx]List'!$b4,'[Old book .xlsx]Data'!$c$4:$c$44)

is there any way for a quick copy and paste to make it ignore the workbook references and go to the new workbook worksheets?

Sorry if not very clear.

Brian

 

[Surreybloke]

If you highlight and copy from the window at the top left of the screen, rather than directly from the cell, then Excel will copy the exact formula, rather than do what it is doing for you now and linking to the original spreadsheet.

 

[Sigh]

That's a very useful tip!

 

[Surreybloke]

My pleasure
I've received plenty of help on here, and still am so it's always nice to be able to help someone else.

 

[EasterGreen]

Thank you - very simple, but it works!