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

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

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?

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.

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

.
.
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.

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.

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?

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.

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

You are welcome.