When copying worksheets (especially multiple times on large spreadsheets), I
often get the following message:

"a form or sheet you want to move or copy contains the name
"wrn.Full._.TRAIL", which already exists on the destination worksheet. Do
you want to use this version of the name?"

If I click yes, I am presented with a number of other names (About 20) that
I don't recognize. Although the copy sheet operation works without causing
Excel to crash, I worry about the integrity of my worksheet.

Any others with this experience, and suggestions toresolve?

Excel creates hidden names when it wants. "wrn." can be created when you run
report manager. I've seen it other workbooks when I didn't use the report
manager, too.

I think I'd get a copy of Jan Karel Pieterse's (with Charles Williams and
Matthew Henson) Name Manager

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Then you can clean up those names nice and safely.



eddie_zoom wrote:

When copying worksheets (especially multiple times on large spreadsheets), I
often get the following message:

"a form or sheet you want to move or copy contains the name
"wrn.Full._.TRAIL", which already exists on the destination worksheet. Do
you want to use this version of the name?"

If I click yes, I am presented with a number of other names (About 20) that
I don't recognize. Although the copy sheet operation works without causing
Excel to crash, I worry about the integrity of my worksheet.

Any others with this experience, and suggestions toresolve?

--

Dave Peterson