Hi,

I am using Excel 2007. When I copied a formula from one workbook to another,
it pasted values of the copied cell and not the formula. I want it to paste
exactly (formula or text) what I copied to another workbook. Is there
somewhere in the Excel options that I need to change? I would like to set the
default to paste what I copied unless I want paste value then I can select
from paste special.

Thanks
Ashley

The norm when copying and pasting a formula from one workbook to another
workbook of the same version of Excel is for the result to be a formula.
Just as when you copy & paste within the same workbook, any non-absolute
cell references may change. So =SUM(A1:A10) copied from A11 to C11 will read
=SUM(C1:C11)

However, when you copy from a cell from XL 2007 to Xl 2003, you will the
value not the formula.

If you want to copy a formula (to XL 2003 or XL 2007) without any changes in
cell references do this:

1) Select the cell
2) Highlight everything in the Formula Bar and Copy (shortcut is Ctrl+V)
3) Press Esc ..... VERY IMPORTANT
4) Move to new locale and Paste

Alternatively: double click the cell to invoking Edit mode (or press F2) and
copy formula from cell. Then follow Steps 3 and 4

best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Ashley" wrote in message
...
Hi,

I am using Excel 2007. When I copied a formula from one workbook to
another,
it pasted values of the copied cell and not the formula. I want it to
paste
exactly (formula or text) what I copied to another workbook. Is there
somewhere in the Excel options that I need to change? I would like to set
the
default to paste what I copied unless I want paste value then I can select
from paste special.

Thanks
Ashley

Ashley,

You must have two Excel files opened in two Excel instances. There are two
ways to fix that problem.

First way: Press F2 in the cell that you want the formula copy from and
press Ctrl+C on your keyboard. Then press F2 in the cell that you want the
formula copy to and press Ctrl+P on your keyboard.

2nd way: Open the both Excel file in the same Excel instance. Then do the
copy and paste the way you were doing.

I hope this helps.

"Ashley" wrote:

Hi,

I am using Excel 2007. When I copied a formula from one workbook to another,
it pasted values of the copied cell and not the formula. I want it to paste
exactly (formula or text) what I copied to another workbook. Is there
somewhere in the Excel options that I need to change? I would like to set the
default to paste what I copied unless I want paste value then I can select
from paste special.

Thanks
Ashley

highlight your formula click copy then X out page - - when it asks to save
changes -- click cancell then paste your formula
--
grizz


"Ashley" wrote:

Hi,

I am using Excel 2007. When I copied a formula from one workbook to another,
it pasted values of the copied cell and not the formula. I want it to paste
exactly (formula or text) what I copied to another workbook. Is there
somewhere in the Excel options that I need to change? I would like to set the
default to paste what I copied unless I want paste value then I can select
from paste special.

Thanks
Ashley

if you highlite your formula click copy then X out your page - - when it
prompts you to save your settings click cancell then paste your formula
--
grizz


"Ashley" wrote:

Hi,

I am using Excel 2007. When I copied a formula from one workbook to another,
it pasted values of the copied cell and not the formula. I want it to paste
exactly (formula or text) what I copied to another workbook. Is there
somewhere in the Excel options that I need to change? I would like to set the
default to paste what I copied unless I want paste value then I can select
from paste special.

Thanks
Ashley