Your problem doesn't sound like the way the OP described the problem. Yours
sounds like the function that in Excel 2003 was Tools/ Options/ Edit/ Extend
data range formats and formulas. I don't have Excel 2007, but isn't it:
Office button, Excel Options, Advanced tab,check Extend Data range formats
and formulas ?
--
David Biddulph

"Joaneee" wrote in message
...
I have the same problem (with Excel 2007). My worksheet has two columns
with
formulae, several others without. When I insert rows, even in between
existing rows, the formulae do not copy (the resulting cells are empty).
I
have checked my Excel options and can't find anything that would cause
this
behavior. (Used to be so easy...in older versions)!

Can anyone help?
--
Joaneee


"David Biddulph" wrote:

You say that the formulae don't copy. What is in the cells where the
formulae should be?
--
David Biddulph

"FlashGordon64" wrote in
message
...
I just re-installed Excel and the defaults that I am used to are not
active.
Now when I copy a column that has formulas in it the formulas don't
copy.
Any suggestions?