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