Excel name manager is blank, but when tabs are tried moving or copying, ends up getting name (around 4k+ names) already exists. even after force close, and i look into the file, the name manager still remains blank with no names created.
Does the following macro help?
Dim n As Name
For Each n In ThisWorkbook.Names
n.Visible = Not n.Visible
If the there are sheet-local names they form part of a different collection and would need
For Each n In ActiveSheet.Names