Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy and paste formulas between workbooks?
I have 2 versions of a workbook. I've identified an error in some of the
formulas in one and having corrected them, I want to copy and paste into the other, but it only pastes the values. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy and paste formulas between workbooks?
EditPaste special
check Formula HTH -- AP "tezza" a écrit dans le message de news: ... I have 2 versions of a workbook. I've identified an error in some of the formulas in one and having corrected them, I want to copy and paste into the other, but it only pastes the values. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy and paste formulas between workbooks?
Thanks. I was having problems because I had 2 instances of Excel open and it
wont perform 'paste special-formulas' between the 2. However, now when I paste the formulas they refer back to the original workbook. I suspect I will have to use the replace function to get rid of all references? "Ardus Petus" wrote: EditPaste special check Formula HTH -- AP "tezza" a écrit dans le message de news: ... I have 2 versions of a workbook. I've identified an error in some of the formulas in one and having corrected them, I want to copy and paste into the other, but it only pastes the values. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy and paste formulas between workbooks?
You can try copying from the formula bar instead of copying the cell. Choose
a cell, highlight the formula in the formula bar and [Ctrl]+[C] to copy it. Then I find it's better for some reason to hit [Esc] to get out of copy mode and go to the other workbook, choose the cell where you want the formula to be and paste it in there through the formula bar also. This will make a literal copy without workbook references. Disadvantage is having to do it one formula at a time. "tezza" wrote: Thanks. I was having problems because I had 2 instances of Excel open and it wont perform 'paste special-formulas' between the 2. However, now when I paste the formulas they refer back to the original workbook. I suspect I will have to use the replace function to get rid of all references? "Ardus Petus" wrote: EditPaste special check Formula HTH -- AP "tezza" a écrit dans le message de news: ... I have 2 versions of a workbook. I've identified an error in some of the formulas in one and having corrected them, I want to copy and paste into the other, but it only pastes the values. Any ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy and paste formulas between workbooks?
Select the cells to copy.
EditReplace What: = With: xxx Replace all. Copy these over to new workbook. Reverse the editreplace on new workbook. Close source wookbook without saving. Gord Dibben MS Excel MVP On Thu, 6 Jul 2006 10:29:16 -0700, JLatham wrote: You can try copying from the formula bar instead of copying the cell. Choose a cell, highlight the formula in the formula bar and [Ctrl]+[C] to copy it. Then I find it's better for some reason to hit [Esc] to get out of copy mode and go to the other workbook, choose the cell where you want the formula to be and paste it in there through the formula bar also. This will make a literal copy without workbook references. Disadvantage is having to do it one formula at a time. "tezza" wrote: Thanks. I was having problems because I had 2 instances of Excel open and it wont perform 'paste special-formulas' between the 2. However, now when I paste the formulas they refer back to the original workbook. I suspect I will have to use the replace function to get rid of all references? "Ardus Petus" wrote: EditPaste special check Formula HTH -- AP "tezza" a écrit dans le message de news: ... I have 2 versions of a workbook. I've identified an error in some of the formulas in one and having corrected them, I want to copy and paste into the other, but it only pastes the values. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |