The name already exists Excel how to stop VBA

1. 03-07-2015, 01:03 PM #1

   Table of Contents Show

   • "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to stop
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s
   • How do I get rid of VBA in Excel?
   • How do you resolve a conflict name in Excel?
   • Why is my name appearing in an Excel cell?
   

   Registered User

   

   ---

   "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to stop

   Hello

   When I try to copy a sheet, I get an alert pop-up that says The name 'a' already exists. Click Yes to use that version of the name, or click No to rename the version...
   If I click Yes, then it finds another 'name' that already exists. If I click Yes long enough I run out of these names and eventually it makes a copy of the sheet. Annoying to say the least.
   What is happening here and how do I mitigate this?

   Thx much

   Dave

   ---

2. 03-07-2015, 02:32 PM #2

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   Attaching a sample workbook enables others to work on your problem:

   To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

   Click on GO ADVANCED and use the paperclip icon to open the upload window.

   View Pic

   ---

3. 03-07-2015, 02:39 PM #3

   

   Registered User

   

   ---

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   example attached.example.xlsx

   So just to be clear - I right click on the CH13a tab for example and choose Move or Copy. I select the Create a copy box and choose where I want the copy to be inserted (doesn't matter for this example). That's when the problem starts occurring.

   Thx

   Last edited by Trismos; 03-07-2015 at 02:42 PM.

   ---

4. 03-07-2015, 02:47 PM #4

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   Hi Trismos,

   Click on your Formulas Tab and then on the Names Manager Icon. Look at all the names that have been created in your workbook. I expect these are creating the conflict. If you have a bunch of "#Ref", you should delete them and try your process again. See what happens.

   ---

5. 03-07-2015, 03:19 PM #5

   

   Registered User

   

   ---

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   Thanks for that Marvin. You are correct and my problem seems to have been resolved. I took out just the ones where #REF! was in the Value column.
   Do you know what's going on here then? Why or how are these #REF! values created? I have quite a few links between pages (information entered into a cell in sheet one will be common through out) drop down menus, formulas, charts, conditional formatting and a few other things related to data validation...... all my functionality seems to still be there, so what's with the REF?

   ---

6. 03-07-2015, 03:23 PM #6

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   #REF errors usually happen when you delete ranges or sheets that formulas are referencing.

   ---

7. 03-07-2015, 03:28 PM #7

   

   Registered User

   

   ---

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   I have upwards of 200 of these....

   ---

8. 03-07-2015, 03:35 PM #8

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   

   Originally Posted by Trismos

   

   I have upwards of 200 of these....

   Hmmm.. is that a question or just a statement.

   ---

9. 03-07-2015, 03:39 PM #9

   

   Registered User

   

   ---

   Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

   Well it could be either but what the heck; why do I have upwards to 200 of these? This report was first created back in 2007 and has gone through a lot of revisions. Have these REF errors simply followed along for the ride, slowly building up in the background without much of a consequence except this irritating little glitch?

   ---

10. 03-07-2015, 05:59 PM #10

    Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

    I think when you copy a whole sheet or even a range on a sheet that has extra stuff in it, like: Objects, Shapes, Named Ranges, Formulas, Formatting, Charts, etc... they get pasted also.

    When you define a named range it asks if it should be a worksheet or workbook range. I think this answer determines if it can go from worksheet or if it works from the entire workbook. I think this relates....

    I do know I once created a few shapes on a worksheet and copied this worksheet and ranges on it many times to other places. The workbook size got huge and I didn't have anything in any of the cells. I finally discovered Go To.. Objects and deleted all of them. There were hundreds...

    The bottom line is: Excel has lots of places to keep (hide

    

    ) stuff that is hard to unhide unless you know where to look.

    Hope you found and fixed your problem.

    ---

11. 10-22-2018, 02:23 PM #11

    

    Registered User

    

    ---

    Re: "The name 'such n such' already exists...' pop-up when trying to copy sheets. How to s

    I had 1,000 of these. You can delete all of them by doing the following:

    1. Click on the top one
    2. Press and Hold: Shift + Ctrl
    3. Scroll to the bottom
    4. Click the bottom line
    5. All should be selected, then delete

    ---

How do I get rid of VBA in Excel?

How do you resolve a conflict name in Excel?

Why is my name appearing in an Excel cell?