Forum Discussion
Pluschap
Jan 22, 2025Copper Contributor
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?
- Patrick2788Silver 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.