Copy the formula as it is. Select Edit Links, highlight the link you
want to change, select 'Change Source' and pick the spreadsheet you are
in. Click OK and you'll find the cell reference is in your current
spreadsheet.