| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste from ANOTHER WORKBOOK | Excel Discussion (Misc queries) | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
| Copy and paste from 1 workbook to another | Excel Worksheet Functions | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| copy\paste from one workbook to another | Excel Discussion (Misc queries) | |||
Linear Mode
