Forum Discussion
gravisha
Sep 13, 2022Copper Contributor
Name Manager in Excel
I notice in Name Manager a range has been defined with a Name (not done by me). I am unable to delete / edit this name. As a result my formula are not working as intended outside this range.
NikolinoDE
Sep 13, 2022Platinum Contributor
Select the existing table name (e.g. Sheet1, Sheet2, Sheet3, etc.) and convert the table back into a range. Once you have done this, the table will disappear from the name manager.
Then you can go ahead and create a new table.
Info. Knowledge of the Excel version as well as the operating system and the storage medium would be an advantage. A photo with the error message or the names manager would be of additional benefit...for you :).
Since the Excel versions and those of the operating system sometimes behave differently, the proposed solution is also different in each case.
Hope I could help you with this information.
I know I don't know anything (Socrates)