Hi Jethro

There is an option ToolsOptionsEditExtend List formats and Formulas
but on my copy of XL2002 it does not seem to do anything when checked as
opposed to unchecked.

in XL2003, there is a DataList option, which when invoked does add
formulae as you add to a list of data.
--
Regards

Roger Govier


"JethroUK©" wrote in message
...
i actually have misled - i'll try again:

when 'inserting' new rows - some machines (i have a class of 16)
automatically insert any formulae - some don't?

XL 2002

"Tom Ogilvy" wrote in message
...
| I have never seen it nor am I aware of any such setting. (I don't
know
| anything about xl2007 if that is what you are using).
|
| --
| Regards,
| Tom Ogilvy
|
|
|
|
|
| "JethroUK" wrote in message
| ...
| When copy/pasting rows i notice some machines copy existing
formulae &
| some don't
|
| Assume this is some sort of Excel settings
|
| Any Clues?
|
|
|