Forum Discussion
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.
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)