+ Reply to Thread
Results 1 to 4 of 4

"Hidden" names

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2007
    Posts
    5

    "Hidden" names

    Hi there,
    this is my first post in the forum since I'm very new here. I need some help with apparently "hidden" names.

    When I copy a tab from one file to another, a window appears telling that in the destination file a name "XXX" already exists and ask if I want to keep the name or change it. Now, neither in the source file nor in the destination one there is any name "XXX" but if I try to write it, a link to an external file appears in the links section.
    How can I remove all these unknown names?

    Thanks a lot

    Fra

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: "Hidden" names

    If you will download the Name Manager add-in from Jan Karel Pieterse, there is the option to display hidden names and to delete them.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    01-23-2014
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: "Hidden" names

    Quote Originally Posted by Izandol View Post
    If you will download the Name Manager add-in from Jan Karel Pieterse, there is the option to display hidden names and to delete them.
    Can you please paste me the link?

    Thx

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: "Hidden" names


+ 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. replace all defined range names in the sheet that start with "Street" to "Road"
    By matrex in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-04-2016, 08:53 AM
  2. [SOLVED] Reverse personal names from "First Last" to "Last, First" and accommodate middle names
    By MrGadget6977 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-17-2013, 07:10 PM
  3. Excel Function that differentiates "male" from "female" names with 900+ names
    By doylehargrove in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2012, 06:00 PM
  4. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  5. Backup to specific folder if workbook names begins with "NSR" or "MAC"
    By GregR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2005, 08:06 PM

Tags for this Thread

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