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