Forum Discussion

gravisha's avatar
gravisha
Copper Contributor
Sep 13, 2022

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.

excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Sep 13, 2022

    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)

     

Resources