copying a sheet - getting an error

[phil-rge-ee]

excel 2007:
I have a workbook that has one sheet in it. It was started from using the
personal monthly budget template provided with excel. I inserted this
template and then edited it to my liking. It works great. No macros or vb
script, simply uses tables, formulas, and conditional formatting.
The problem is when I try to copy this sheet into the same workbook the
first copy works fine, then I try to make another copy and I get a warning
dialog box that says: the sheet you want to copy contains the name 'payment
date', which already exists on the destination worksheet. Do you want to use
this version of the name?

I dont understand what it's asking here....
1) I do not have the name payment_date anywhere in the sheet or in any
formula on the sheet.
2) even if I did the message makes no sense as of course the destination
sheet is going to have that name because its a copy of another sheet, it
should be the same with all the same names, so of course the destination
would have the same name.
3) why does the first copy of the sheet give no warning message at all, but
subsequent copies does gives the warning message.

Can someone explain this message, tell me why I'm getting it, and how to get
excel to stop warning me.
Thanks.

 

[Pete_UK]

Whether you have set it up or not, there is a named range called
payment_date in the file, and Excel will track which cell(s) on which sheet
this name refers to. The first time you use the file (with one sheet and
therefore one version of the name) there is no warning. However, when you
try to copy the file, then Excel will end up with two names that are the
same, so it is asking you what you want to do about this. You might want to
have two names, one in each sheet, so the payment_date in Sheet1 is
different than the payment_date in Sheet2, or you might want just one name
and for that to refer to the first, so Excel is giving you the choice.

I don't know the menu choices in Excel 2007, but with earlier versions you
can do Insert | Name | Define to see a list of the named ranges defined
within the file - there must be something similar within your version.

Hope this helps.

Pete

 

[phil-rge-ee]

Thanks, that did help. I was able to use the help file and find where in the
new 2007 menus the defined name ranges where (the name manager) and found
where the problem was. Thanks.

 

[Pete_UK]

Glad to help - thanks for feeding back.

Pete

Thanks, that did help. I was able to use the help file and find where in the
new 2007 menus the defined name ranges where (the name manager) and found
where the problem was. Thanks.







- Show quoted text -