Name Manager

[Derek McGill]

In my Name Manager I have a defined name which can not be deleted or edited, Any ideas as to how to remove it ?

 

[Deepak]

What the error you are getting. Can we have that file.

 

[Derek McGill]

When i find last row in "D" to add an item, its at the end of the defined range, Ie row 30,000

 

[Monty]

Dear Derek.

Use this in name manager and check, it's dynamic to picup till the last row of your data.

=OFFSET($A$1,0,0,COUNTA($A:$A),1)

 

[Hui]

If the name refers to an Excel Table, yes you can see it in the Name Manager but you cannot edit it



Two things to note about this

1. Table 1 is an Excel Table , you see it in the Name Manager but can't edit it
2. The small Blue Holder in the lower left corner of cell C17 shows the extent of the table

If you have a lot of Blank rows in an Excel table, simply select them and delete them. The Name Manager will update the range automatically

 

[Derek McGill]

Hi Hui
Thanks for the information, I have now been able to remove 30,000 odd rows.
Derek

 

[AVK]

You remove table range.
Go to table > right click > select "Table" > convert to range > yes

 

[jamesexcel1970]

Hey Hui
Good one.Cheers

 

[Derek McGill]

You remove table range.
Go to table > right click > select "Table" > convert to range > yes

I use table for input of new "Players" and its used for Lookup it has to be sorted.