If you are the only user of that workbook and do not have a use for any of
the names, then they could be deleted. However, if the workbook is a shared
workbook that you call up from an intranet server, you could be deleting
someone else's names that they use. In the standard dialog box for Define
Names, there is a Refers To: box at the bodttom that shows the sheet and
range for each name. Try clicking on some of the names and see what they
reference. Maybe that will help you decide what to do.





"cardan" wrote in message
...
Hello,

I am working in an Excel Spreadsheet that is used as a template and
has about 30 page. I am revamping it and sometimes when I try to copy
a worksheet within the workbook, I get an error such as:

"A formula or sheet you want to move or copy contains the name '\P'
which already exists on the destination worksheet. Do you want to use
this version of the name?"
o To use the name as defined in the destination sheet, click Yes
o To rename the range referred to in the formula or worksheet, click
No, and enter a new name in the Name Conflict dialog box.

I have no clue what this means. I built the template and it is used
by a few other people but I am not sure how this got into my
workbook. I don't recall ever naming ranges.

When I copy and cell and hit F3, I get a very long list of Paste
Names. I am including them all below because I don't know if they are
unique to my spreadsheet or if someone can decipher what they mean.
They are separated by the comma.

\P, \PP, _1, _2, _3, _34536 , _346, _4, _5, _6, _7, A, asdf, asdfaf,
B, dfdgfh, FY4_, IFN, NvsElapsedTime, NvsEndTime, PED, PER, s,
SFD_HH_GL_CENTER, SFV_HH_GL_CENTER, W, Year

My questions a What do they mean? Can I get rid of them? Should
I get rid of them? How do I get rid of them?

Any feedback is greatly appreciated. Thank you in advance.