Aladin,

On my version of Excel, Excel:Mac v.X on the Mac OS X v.10.2.8, the List
option is also under Insert.

I just tried using the List Manager and, much to my surprise, found that
formulas outside the List range indeed change when entering a new
record. Wow!

This being the case, I don't understand why the formulas within the
range don't also adjust. Doesn't quite make sense to me. Nevertheless,
this still can prove to be very useful.

Interesting, though, that in your version, formulas inside the range
aren't copied down.

In article ,
Aladin Akyurek wrote:

Domenic,

On my Excel:mac 2001 on MacOS 9.x, with a List option under Insert...

This version reads the List range in my Windows Excel 2003 file as an
ordinary range. When I convert the range into a list using Insert|List,
the following is the case:

The formulas outside List range change upon inputting a new record. The
funny thing is: the formulas inside the range are not copied down!

Aladin