Copy paste between workbooks yields Value only

[D Riggins]

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.

 

[NBVC]

Try copying the formula from the formula bar at the top of the sheet..

 

[Stefi]

Try to copy not the cell but the content of the formula bar!
Regards,
Stefi

„D Riggins†ezt írta:

 

[D Riggins]

Thanks, Unfortunately I need to copy a range of cells with different
formulas. Any other ideas?

 

[Stefi]

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:

 

[Bernard Liengme]

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