Quite likely the Tables sheet is hidden.

FormatSheetUnhide and do your addition of values then re-define the reference
address to fit your new list.


Gord

On Thu, 24 May 2007 11:54:00 -0700, xlsstudent
wrote:

Thanks for all those who helped to find the data location of the list.

When I did the InsertName Define, I see the name of the list TBL_PEOPLE.
When I click on the name, it shows
=OFFSET(Tables!$D$1,1,0,COUNTA(Tables!$D:$D)-1,1)

However, I am not able to see any worksheet by name Tables. what should I do
to include few more values into this list? Pls help.