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.
|