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?