Share via

_Key1 copy issue

Anonymous
2017-09-13T13:46:39+00:00

I keep getting this error..."The name '_Key1' already exists. when copying a worksheet.  I have already tried all of the other suggestions and removed EVERYTHING from the formulas-named manager.  and there are NO entries left....how do I get rid of these annoying messages?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-13T20:10:03+00:00

    How many worksheets are in the workbook? Maybe try saving copies of the worksheets to a new workbook and see if that clears it up.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-09-13T20:05:35+00:00

    Yes there were hidden WS's...but I unhid and still no joy.  No named ranges and no links

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-09-13T18:34:28+00:00

    Are there any hidden worksheets in the workbook? They may have links on them. I had this same problem quite some time ago on some workbooks that I had, and I corrected it, but I currently forget what the solution was.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-09-13T18:22:18+00:00

    Hi Jason - thanks for the quick response!!

    It happens no matter what worksheet I try to copy. Yes it in the same workbook but this workbook was created from another that had links the I have already cleared...at least that I can see...  :-)  Worksheet name 'Capitol Labor Estimate 2019'

    Was this answer helpful?

    0 comments
  5. Anonymous
    2017-09-13T15:40:39+00:00

    Does this happen with only one specific worksheet? Are you copying it within the same workbook? What is the worksheet's name?

    Was this answer helpful?

    0 comments