View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mandy Mandy is offline
external usenet poster
 
Posts: 55
Default 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?