Yes - that is similar to my situation.
I've played with it a bit more, and I've seen where sometimes the external
formula updated, and sometimes it did not.

It might be the case where the formula does not update if I insert multiple
rows at one time without actually putting data in them.

But I have seen it update the formula too - so I'll just have to keep an eye
on it and keep checking my formulas until I figure out what causes them not
to update - and then avoid doing that. Thanks for your help!

"NBVC" wrote:


I just did a quick test and created a list in XL2003

Simply

X Y
1 =A2
2 =A3
3 =A4


and then I have a Formula separately: =Sum(B2:B4)

When I add a row to the list, the formula updates to say =Sum(B2:B5)
as expected..

I saved the file and opened it in XL2007 and when I add a row to the
now "table" it updates the other formula to =Sum(B2:B6) as expected.

Is this a similar situation to yours?


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116220