+ Reply to Thread
Results 1 to 11 of 11

Name Exists when Copying Worksheets. Cannot Figure out how to Erase

  1. #1
    Registered User
    Join Date
    07-26-2006
    Posts
    80

    Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    I have an odd situation. I am working on an existing model and when I try to copy a worksheet, I get an error message like "The name 'xxxxx' already exists. Click Yes to use that version of the name, or click No to rename the version of 'xxxxx' you're moving or copying." There are about 20 names and I am not sure what they refer to. I have to hit Yes 20 times to continue working. It's a minor annoyance, but I think it just crashed my Excel so now I need to solve the issue.

    When I go go into my Name Manager (Ctrl+F3) None of these names show up so I am not sure where they are or how to delete them. There are no macros in the workbook. Not sure how to diagnose. Any feedback helps.

    Thank you

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    787

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    Those names might be located in hidden, or "very hidden" sheets. They will not appear in the names manager if that's where they are.
    Pete

  3. #3
    Registered User
    Join Date
    07-26-2006
    Posts
    80

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    I don't have any hidden sheets as far as I can tell (right click sheet name, Unhide). Is there another layer of hidden sheets I need to find?

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,014

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    Any sheet that is "xlSheetVeryHidden" won't show by right clicking the sheet tab, then Unhide.

    Right click the sheet tab, click SHOW CODE.

    In the upper left pane is the list of sheets. With the VIEW PROPERTIES pane showing, click on each sheet name then look in the
    properties pane to determine is the sheet is xlSheetHidden or xlSheetVeryHidden.

  5. #5
    Registered User
    Join Date
    07-26-2006
    Posts
    80

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    Just got back to my desk. Thank you for the reply.

    I went into View Properties but nothing about sheets being hidden. I've attached a link to the model below. (could not get the attachment function to work)


    https://www.dropbox.com/sh/ndd3gi1rb...XPfFhUSea?dl=0

    Thanks again

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,014

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    .
    .
    Nothing xlSheetVeryHidden :
    .
    .

    xlHidden.jpg


    I reviewed your workbook and discovered a number of named ranges that were not being utilized. In the attached copy those are removed.
    See if it runs correctly (copy / paste) for you now.

    I didn't have any issues copy / paste with your download from dropbox before I cleaned it up.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-26-2006
    Posts
    80

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    I just downloaded the model that you attached and it works great!. Where did you find those named ranges that were not being utilized and you were able to remove? I couldn't find them through my Ctrl+F3 search.
    Thank you for your efforts. It is truly appreciated.

  8. #8
    Registered User
    Join Date
    07-26-2006
    Posts
    80

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    So I just read your message a bit more clearly. You did not get the "name exist error" when you opened it from dropbox? I just reopened it from dropbox and get the same error. Is it something within my version of Excel?

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,014

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    Is it something within my version of Excel?
    Doubtful. Probably something corrupt in the workbook itself. Perhaps the 'cleaning' I gave it did the trick ?

    The cleaner program found the spurious ranges.

  10. #10
    Registered User
    Join Date
    07-26-2006
    Posts
    80

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    Good to know. I just learned something today. Thank you for all your help. I will mark this solved.
    Thanks again!

  11. #11
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,014

    Re: Name Exists when Copying Worksheets. Cannot Figure out how to Erase

    You are welcome.

+ 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. Values are already exists in other worksheets
    By Neilesh Kumar in forum Excel General
    Replies: 1
    Last Post: 11-04-2016, 03:49 AM
  2. [SOLVED] Copying Sheet: Name already exists
    By cuznleroy in forum Excel General
    Replies: 4
    Last Post: 03-19-2014, 03:44 PM
  3. [SOLVED] button erase dont erase an image inserted on an image control
    By Nuno Neves in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 08:04 AM
  4. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  5. Copying row of data to new sheets if specific value exists in column
    By raz333 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2013, 03:53 PM
  6. [SOLVED] Copying row of data to new sheet if specific value exists in column
    By raz333 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-17-2013, 04:33 PM
  7. Worksheets Exists Code...
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2005, 05:05 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