How to change the Tables! ?

[Guest]

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

When I did the Insert>Name> 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 Dibben]

Quite likely the Tables sheet is hidden.

Format>Sheet>Unhide and do your addition of values then re-define the reference
address to fit your new list.


Gord

 

[Guest]

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]

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