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.

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.

Gord,

Appreciate your help and response. That was my first hunch. I searched for
any hidden worksheet but could not find one. I saw if the document is
protected for any changes. Nope. The document is not protected either.

Pls help.

"Gord Dibben" wrote:

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.

Maybe it was hidden using VBA's xlveryhidden method.

Try this macro.

Sub unhide()
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Sheets
sh.Visible = True
Next sh
End Sub

Or hit Alt + F11 to open VBE......CTRL + g to open Immediate window.

Paste this in and hit <enter

Sheets("Tables").Visible = true


Gord

On Thu, 24 May 2007 15:32:01 -0700, xlsstudent
wrote:

Gord,

Appreciate your help and response. That was my first hunch. I searched for
any hidden worksheet but could not find one. I saw if the document is
protected for any changes. Nope. The document is not protected either.

Pls help.

"Gord Dibben" wrote:

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.