I have a similar problem, I have a large number of formulas that i need to
copy from one worksheet to another. Under the paste tab the Formula option is
greyed out. (i have checked in excel options\advanced\ cut, copy and paste
and all three options are ticked.)
I have saved the source workbook as a 2007 file too so that I am copying and
pasting to the same version of excel.
Any ideas


"cahduq" wrote:

I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?