+ Reply to Thread
Results 1 to 4 of 4

Cannot edit or delete Name manager in unprotected sheet

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    US
    MS-Off Ver
    O365 (PC) V 2308
    Posts
    62

    Cannot edit or delete Name manager in unprotected sheet

    How can I edit the existing name manager. My sheet is not protected with password. Still the edit and delete buttons are greyed out

    Thank you

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Cannot edit or delete Name manager in unprotected sheet

    does this link help?
    https://www.exceldemy.com/excel-name...te-greyed-out/
    or this one...
    https://www.excelforum.com/excel-gen...e-manager.html
    if not you might need to upload the workbook
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Banned User!
    Join Date
    03-11-2024
    Location
    usa
    MS-Off Ver
    CURRENT
    Posts
    23

    Re: Cannot edit or delete Name manager in unprotected sheet

    hi, mls_newbee
    It seems like there might be hidden or protected sheets linked to the Name Manager. Ensure all sheets are unprotected and there are no external references in your workbook. If the problem persists, try transferring the data to a new workbook to see if that resolves the issue.

  4. #4
    Registered User
    Join Date
    09-22-2010
    Location
    US
    MS-Off Ver
    O365 (PC) V 2308
    Posts
    62

    Re: Cannot edit or delete Name manager in unprotected sheet

    Thank you both. I could not resolve this issue. There is no protected sheet in my workbook and certainly it has references from one sheet to other.
    I just created new lists and used them as drop downs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Name manager can't edit scope range
    By seercoven in forum Excel General
    Replies: 8
    Last Post: 09-15-2022, 12:00 AM
  2. name manager - edit external links automatically
    By Efes in forum Excel General
    Replies: 3
    Last Post: 09-11-2018, 01:52 AM
  3. Vba to allow user to insert rows/columns but not delete on unprotected sheet
    By Nicola13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 06:19 AM
  4. Replies: 0
    Last Post: 07-13-2012, 06:01 AM
  5. Using Macros to add, delete and edit a CRM in an excel sheet
    By ste_mulv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2009, 02:43 PM
  6. [SOLVED] How do I Delete Sheet when it won't light up in the Edit menu?
    By CFP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2005, 09:45 PM
  7. Replies: 3
    Last Post: 08-08-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1