+ Reply to Thread
Results 1 to 4 of 4

Can't Edit Names ::: Options Greyed Out :::

  1. #1
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Can't Edit Names ::: Options Greyed Out :::

    I am having an issue with my Excel 2010 workbook that is extremely frustrating.

    When I open my workbook, I am getting a "This workbook contains one or more links that can't be updated" message. I started getting this after I accidently deleted a worksheet and replaced it with a backup copy.
    When I use the Edit Links feature, it shows the file and location causing the "Error: Source not found." broken link.

    I managed to find the offenders ... references amongst different named ranges.

    The problem is ... I see the offending references in the Name Manager, but all options to do anything are greyed out. I can't edit, or delete, or anything with that particular name in an effort to resolve the bad link.

    What do I need to do to gain access to edit this name?

    If it matters, this particular name is listed several times but each referring to different workbook scopes. Of the numerous entries, one is valid.

    Jenn
    Last edited by JBeaucaire; 07-11-2012 at 08:22 PM. Reason: Corrected thread title to topic only, as per forum rules

  2. #2
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: Can't Edit Names ::: Options Greyed Out ::: Please Help!

    I am assuming the worksheet/workbook is protected. you should be able to edit once you unprotect.
    Regards,
    Vandan

  3. #3
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Can't Edit Names ::: Options Greyed Out ::: Please Help!

    Ahhhh ... I never thought of that! hehehe

  4. #4
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    [SOLVED] Re: Can't Edit Names ::: Options Greyed Out ::: Please Help!

    All good. Thanks for the suggestion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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