up vote 0 down vote favorite
2
share [g+] share [fb]

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?

link|improve this question
100% accept rate
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 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 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 at 15:12
2  
Are these things defined names on the workbook? If so, they will cause your error. – soandos Jan 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 at 17:31
show 7 more comments
feedback

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.

link|improve this answer
@soandos - if you enter your own version of this answer, I will delete mine and accept yours. – Wikis Jan 16 at 14:47
feedback

Your Answer

 
or
required, but never shown
discard

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