Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste between workbooks yields Value only
When I copy a formula from an Excel 2003 workbook to another workbook
(running in a separate intsance of Excel) it pastes the values only (and I want the formula). After reading several of the posts here, I've gathered that this behavior is "normal". Is there any way to defeat this behavoir besides opening the two workbooks in the same instance of Excel? I really do want to be running the separate instance of Excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste between workbooks yields Value only
Try copying the formula from the formula bar at the top of the sheet... -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116157 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste between workbooks yields Value only
Try to copy not the cell but the content of the formula bar!
Regards, Stefi €˛D Riggins€¯ ezt Ć*rta: When I copy a formula from an Excel 2003 workbook to another workbook (running in a separate intsance of Excel) it pastes the values only (and I want the formula). After reading several of the posts here, I've gathered that this behavior is "normal". Is there any way to defeat this behavoir besides opening the two workbooks in the same instance of Excel? I really do want to be running the separate instance of Excel. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste between workbooks yields Value only
Thanks, Unfortunately I need to copy a range of cells with different
formulas. Any other ideas? "Stefi" wrote: Try to copy not the cell but the content of the formula bar! Regards, Stefi €˛D Riggins€¯ ezt Ć*rta: When I copy a formula from an Excel 2003 workbook to another workbook (running in a separate intsance of Excel) it pastes the values only (and I want the formula). After reading several of the posts here, I've gathered that this behavior is "normal". Is there any way to defeat this behavoir besides opening the two workbooks in the same instance of Excel? I really do want to be running the separate instance of Excel. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste between workbooks yields Value only
Open the destination file in the source instance, make copying, save and
close the destination file and reopen it in the second instance! Stefi €˛D Riggins€¯ ezt Ć*rta: Thanks, Unfortunately I need to copy a range of cells with different formulas. Any other ideas? "Stefi" wrote: Try to copy not the cell but the content of the formula bar! Regards, Stefi €˛D Riggins€¯ ezt Ć*rta: When I copy a formula from an Excel 2003 workbook to another workbook (running in a separate intsance of Excel) it pastes the values only (and I want the formula). After reading several of the posts here, I've gathered that this behavior is "normal". Is there any way to defeat this behavoir besides opening the two workbooks in the same instance of Excel? I really do want to be running the separate instance of Excel. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste between workbooks yields Value only
One way is:
- select he cell with the formula - highlight the entire formula in the Formula Bar and copy with CTRL+C - press ESC to preserve the formula in the cell - move to new workbook and paste (CTRL+V) Of course, all you cell references will be exactly as before-- they will not adjust to the new cell position best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "D Riggins" wrote in message ... When I copy a formula from an Excel 2003 workbook to another workbook (running in a separate intsance of Excel) it pastes the values only (and I want the formula). After reading several of the posts here, I've gathered that this behavior is "normal". Is there any way to defeat this behavoir besides opening the two workbooks in the same instance of Excel? I really do want to be running the separate instance of Excel. |
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) | |||
Why paste between workshhets yields values only | Excel Discussion (Misc queries) | |||
Can NOT copy / paste across workbooks | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) |