Forum Discussion

Pluschap's avatar
Pluschap
Copper Contributor
Jan 22, 2025

Name Manager does not list all names it has remembered.

There was a table in my workbook called Category.  I deleted the table, then created a set of cascading drop-down tables, which the app named as Table1 thru Table6

I then set out to rename the tables with their column headers.  This worked fine except for Table1, which I was unable to rename as Category to replace the deleted table, so I renamed it as Categories.

 

My workbook now has only the names shown in this screen shot:

When I try to change the name of the Categories table to Category,

the app consistently returns:

Note that this set of tables is the only content of the workbook, There are no cells anywhere, and never have been, which reference the Category label.

I have been programming since 1970.  No compiler or interpreter I have ever worked with has ever exhibited this behavior.  If I delete a named variable, the name should immediately be available for reuse.  How do I work around this defect?

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    The usual fix is to close/re-open the workbook and then try to re-name the table again.

    I think this quirk happens every now and then because the name of the table which is stored in the file's workbook.xml is not deleted.  Closing/Re-opening the workbook updates the xml.

Resources