G
Guest
Hi
Wonder if anyone of you encounter this problem before? When I try to copy
worksheet in a workbook, the following prompt comes up, indicating name
conflict.
"A formula or sheet you want to move or copy contains the name 'aaaa', 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"
When I clicked yes, another prompt comes up indicating other name conflicts,
so I had to click yes many times before I can succeed in copying the sheet.
This is extremely time-consuming, and I worry whether this could result in
errors.
Apparently, this problem arises because the workbook contain worksheets
which I have copied from other workbooks. Those other workbooks have
programs/macros/name inserted which I inherit over when I copy sheets over.
To solve the problem, I have tried deleting all names in my workbook, but
the problem still persist. It seems that the only solution I have is to re-do
my entire workbook (gasp!).
Really hope there are some kind souls out there who know a quick solution to
this problem.
Thanks.
Wonder if anyone of you encounter this problem before? When I try to copy
worksheet in a workbook, the following prompt comes up, indicating name
conflict.
"A formula or sheet you want to move or copy contains the name 'aaaa', 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"
When I clicked yes, another prompt comes up indicating other name conflicts,
so I had to click yes many times before I can succeed in copying the sheet.
This is extremely time-consuming, and I worry whether this could result in
errors.
Apparently, this problem arises because the workbook contain worksheets
which I have copied from other workbooks. Those other workbooks have
programs/macros/name inserted which I inherit over when I copy sheets over.
To solve the problem, I have tried deleting all names in my workbook, but
the problem still persist. It seems that the only solution I have is to re-do
my entire workbook (gasp!).
Really hope there are some kind souls out there who know a quick solution to
this problem.
Thanks.