Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I want to copy a sheet (within the same file, so simply using left mouse button and Ctrl) in Excel 2007, I get this pop up dialog:

Yes / No dialog

where Author is a specific field somewhere in the sheet I'm editing.

The catch is that I cannot get rid of this dialog. If I press Yes, I get the same dialog with a different field. I have no idea how many fields there are in this sheet, but these dialogs just keep popping up...

If I press No, I get:

Name conflict

If I press Cancel (I don't even know what I'm changing, so I don't want to change it!), I get:

Name not valid

even though I pressed Cancel! (Same happens if I press OK without entering anything. If I enter something, I go back to the first dialog with the next field.)

Since I want to get out of this, I use Task Manager to quit Excel and then get:

Cannot quit Excel!

To prevent me banging my head on the table, can anyone tell me how I can change the Excel sheet so that these pop ups stop occurring?

share|improve this question
    
What do you actually want to accomplish? Two copies of the same sheet in the same workbook? (to close excel, use task manager->end process for excel.exe) –  soandos Jan 12 '12 at 15:06
    
Yes, two copies of the same sheet. Thanks for the Task Manager tip, that is exactly what I had to do. –  Wikis Jan 12 '12 at 15:10
    
And so it's clear, you right clicked on the sheet tab, clicked move or copy, checked the create a copy box, picked your location, hit OK, and got these errors? –  soandos Jan 12 '12 at 15:12
2  
Are these things defined names on the workbook? If so, they will cause your error. –  soandos Jan 12 '12 at 15:28
2  
The best way to handle the first message box is to click Yes. You will get that message for every similarly-defined & used name... Use the Name Manager to see how many named ranges you have. –  Rachel Hettinger Jan 12 '12 at 17:31
show 7 more comments

1 Answer

up vote 0 down vote accepted

Go to Formulas -> Name Manager, select the whole list in the pop up box and press Delete.

share|improve this answer
    
@soandos - if you enter your own version of this answer, I will delete mine and accept yours. –  Wikis Jan 16 '12 at 14:47
    
With me it only worked when I close and reopen Excel after deleting the entries. –  Gerhard Powell Apr 11 at 19:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.