Name Manager in Excel

[gravisha]

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.

[#2]

@gravisha 

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.

NikolinoDE

I know I don't know anything (Socrates)