Copy and Paste between workbook

[Mandy]

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?

 

[Gary''''s Student]

copy as usual and then:

Edit > PasteSpecial > Value

 

[Mandy]

I tried that it didn't work

copy as usual and then:

Edit > PasteSpecial > Value
--
Gary''''s Student - gsnu200803

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?

 

[Gary''s Student]

What happened?
--
Gary''s Student - gsnu200803

I tried that it didn't work

copy as usual and then:

Edit > PasteSpecial > Value
--
Gary''''s Student - gsnu200803

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?

 

[Shane Devenshire]

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

 

[Gord Dibben]

If it didn't work, you may have two instances of Excel open with a workbook
in each instance.

In that case your Paste Special will not give you the regular menu with
"values" etc.

You could close one instance of Excel and open both workbooks in the same
instance.

Also see Shane's reply about breaking links.


Gord Dibben MS Excel MVP

I tried that it didn't work

copy as usual and then:

Edit > PasteSpecial > Value
--
Gary''''s Student - gsnu200803

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?