Hi Mandy,

Just do your regular copy and paste. Then choose Edit, Links, select the
reference to [Rebecca PTO.XLS] and click Change Source and find and click on
the current workbooks name.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Mandy" wrote in message
...
Is there a way to copy and paste between workbooks so that it does not
link
between the 2 so in the following formula:='[Rebecca PTO.xls]Totals'!J5
the [Rebecca PTO.XLS] will not appear?