Copy and Paste between workbook
 

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?

Copy and Paste between workbook
 

copy as usual and then:

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


"Mandy" wrote:

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?

Copy and Paste between workbook
 

I tried that it didn't work

"Gary''''s Student" wrote:

copy as usual and then:

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


"Mandy" wrote:

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?

Copy and Paste between workbook
 

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


"Mandy" wrote:

I tried that it didn't work

"Gary''''s Student" wrote:

copy as usual and then:

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


"Mandy" wrote:

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?

Copy and Paste between workbook
 

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?

Copy and Paste between workbook
 

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


On Tue, 9 Sep 2008 08:02:01 -0700, Mandy
wrote:

I tried that it didn't work

"Gary''''s Student" wrote:

copy as usual and then:

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


"Mandy" wrote:

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?