Error message when copying a worksheet
Posted by Paul Bartells on July 10, 2000 1:12 PM
I needed to move a worksheet from an existing workbook to a new one, then use that sheet to create additional sheets in the new workbook (basically using it as a template). The move worked fine, but when I attempted to copy that sheet in the new workbook I got a message which I've seen in the past many times but have never really understood. The full text of the message follows:
A formula or sheet you want to move or copy contains the name 'wrn.Monthly._.Book.', which already exists on the destination worksheet. Do you want to use this version of the name?
- To use the name as defined in the destination sheet, click Yes.
- To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box.
If I click yes, the copy proceeds with no further messages, but I'm concerned that there may be something wrong behind the scene. I've been unable to find any explanation of the error or how to find the reference it mentions.
If anyone has any insight into this problem, please email me. Thanks.