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:

*

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

Bạn đang xem: Lỗi a formula or sheet you want to move or copy contains the name

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:

*

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

*

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:

*

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?


microsoft-excel microsoft-excel-2007
Share
Improve this question
Follow
edited Jan 12, 2012 at 15:15
Reinstate Monica - Goodbye SE
asked Jan 12, 2012 at 14:55
*

Reinstate Monica - Goodbye SEReinstate Monica - Goodbye SE
1,36788 gold badges2424 silver badges4242 bronze badges
13
| Show 8 more comments

3 Answers 3


Sorted by: Reset to default
Highest score (default) Date modified (newest first) Date created (oldest first)
9
I had the same problem, but Name Manager does not reveal all the names embedded in the sheet. Somehow I got a bunch of hidden names in the worksheet.

Here is how to unhide them

Sub ShowNames() Dim nmName As Name For Each nmName In ActiveWorkbook.Names nmName.Visible = True Next nmName End Sub Now, you can see again all names in Name Manager and delete them.


Share
Improve this answer
Follow
edited Mar 24, 2016 at 19:10
*

nixda
26.1k1616 gold badges103103 silver badges150150 bronze badges
answered Mar 24, 2016 at 18:51
*

Sandy PaternotteSandy Paternotte
10111 silver badge33 bronze badges
1
Add a comment |
2
Go to Formulas -> Name Manager, select the whole list in the pop up box and press Delete.

Xem thêm: Cách Thay Đổi Ngày Sinh Trên Facebook Bằng Điện Thoại Iphone, Android

You may also need to close and re-open the file to get rid of these messages.


Share
Improve this answer
Follow
edited Sep 15, 2015 at 10:35
*

bertieb
7,0393636 gold badges3939 silver badges5151 bronze badges
answered Jan 16, 2012 at 14:46
*

Reinstate Monica - Goodbye SEReinstate Monica - Goodbye SE
1,36788 gold badges2424 silver badges4242 bronze badges
3
Add a comment |
0
This error generally arises when there are some erroneous names in the worksheet. Press Ctrl+F3 (the Excel name manager box will show up). On the right hand side there will be a filter button - select "Names with error" and once all of them show up, delete the erroneous names.

Now try to copy the sheet.

Does it work?


Share
Improve this answer
Follow
edited Aug 13, 2015 at 6:01
Jamal
45511 gold badge66 silver badges1717 bronze badges
answered Aug 13, 2015 at 5:07
Amruddin HaiderzadaAmruddin Haiderzada
11
Add a comment |
Highly active question. Earn 10 reputation (not counting the association bonus) in order to answer this question. The reputation requirement helps protect this question from spam and non-answer activity.

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


The Overflow Blog
Featured on Meta
Related
0
Tool to automatically combine many large pivot table in many large Excel sheet?
9
Why does Excel now give me already existing name range warning on Copy Sheet?
6
How to reference same cell in previous sheet in Excel?
0
How do I stop Excel Auto Update?
0
Excel Data Validation List as Formula in "Source" Field?
3
Excel 2010: Create named range without a sheet reference in the formula
1
Prevent the user from moving, resizing and rotating input field in Excel 2016
Hot Network Questions more hot questions
Question feed
Subscribe to RSS
Question feed To subscribe to this RSS feed, copy and paste this URL into your RSS reader.


Super User
Company
Stack Exchange Network
Site design / logo © 2022 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2022.5.26.42234


Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.