• Hidden defined name – how to delete ? (W2K, O2K, XL2K pro-UK sp2)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Hidden defined name – how to delete ? (W2K, O2K, XL2K pro-UK sp2)

    Author
    Topic
    #399777

    Hi,

    When using MS’s official tool for deletion of unwanted links – the dellinks.xla, I’ve come across somthing referred to as “Hidden defined name”.

    Apparently these cannot be deleted by the wizard – and they are not visible to the user…

    Would anyone know how to access these “items” – ultimately how to “terminate” them?

    Thanks

    Viewing 3 reply threads
    Author
    Replies
    • #774769

      Download my name manager from my site below. It shows all names, regardless of whether they are hidden or not.
      Another tool to check links is Bill Manville’s FINDLINK, available at http://www.bmsltd.ie/mvp%5B/url%5D

    • #774770

      Download my name manager from my site below. It shows all names, regardless of whether they are hidden or not.
      Another tool to check links is Bill Manville’s FINDLINK, available at http://www.bmsltd.ie/mvp%5B/url%5D

    • #775112

      Another Tool is Navigator Utilities which has a Name Navigator and a Link Navigator. It also has a sheet Navigator which helps you find hidden and password protected sheets (and removes the password for you).

    • #775113

      Another Tool is Navigator Utilities which has a Name Navigator and a Link Navigator. It also has a sheet Navigator which helps you find hidden and password protected sheets (and removes the password for you).

    Viewing 3 reply threads
    Reply To: Hidden defined name – how to delete ? (W2K, O2K, XL2K pro-UK sp2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: