Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error
I'm trying to copy a tab in a workbook but keep getting error messages, it's
the same error messages just with a different name in them. If I keep clicking yes then it will copy the sheet, but I have to click yes many times because it continues to pop up with different names. I don't know what's going on or why it's saying this but I'd like to fix it so that it doesn't happen anymore. Here's 2 examples of error messages that pop up... "A formula or sheet you want to move or copy contains the name 'Last_Row', which already exists on the destination worksheet. Do you want to use this version of the name? To use teh name as defined in teh 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." "A formula or sheet you want to move or copy contains the name 'LN', which already exists on the destination worksheet. Do you want to use this version of the name? To use teh name as defined in teh 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." The other names that it shows are 'Number_of_Payments', 'Payment_Date', 'Print_Area_Reset', 'Spec9.10', 'Total_Payment', 'Values_Entered', Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error
It is taking issue with some named ranges that you have defined in the
worksheet you are copying. Are you copying to another workbook? -- HTH... Jim Thomlinson "lightbulb" wrote: I'm trying to copy a tab in a workbook but keep getting error messages, it's the same error messages just with a different name in them. If I keep clicking yes then it will copy the sheet, but I have to click yes many times because it continues to pop up with different names. I don't know what's going on or why it's saying this but I'd like to fix it so that it doesn't happen anymore. Here's 2 examples of error messages that pop up... "A formula or sheet you want to move or copy contains the name 'Last_Row', which already exists on the destination worksheet. Do you want to use this version of the name? To use teh name as defined in teh 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." "A formula or sheet you want to move or copy contains the name 'LN', which already exists on the destination worksheet. Do you want to use this version of the name? To use teh name as defined in teh 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." The other names that it shows are 'Number_of_Payments', 'Payment_Date', 'Print_Area_Reset', 'Spec9.10', 'Total_Payment', 'Values_Entered', Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error
No, I am copying to the same workbook...I've gotten this error message before
with different names in it. Do you know how to fix it? Thanks! "Jim Thomlinson" wrote: It is taking issue with some named ranges that you have defined in the worksheet you are copying. Are you copying to another workbook? -- HTH... Jim Thomlinson "lightbulb" wrote: I'm trying to copy a tab in a workbook but keep getting error messages, it's the same error messages just with a different name in them. If I keep clicking yes then it will copy the sheet, but I have to click yes many times because it continues to pop up with different names. I don't know what's going on or why it's saying this but I'd like to fix it so that it doesn't happen anymore. Here's 2 examples of error messages that pop up... "A formula or sheet you want to move or copy contains the name 'Last_Row', which already exists on the destination worksheet. Do you want to use this version of the name? To use teh name as defined in teh 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." "A formula or sheet you want to move or copy contains the name 'LN', which already exists on the destination worksheet. Do you want to use this version of the name? To use teh name as defined in teh 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." The other names that it shows are 'Number_of_Payments', 'Payment_Date', 'Print_Area_Reset', 'Spec9.10', 'Total_Payment', 'Values_Entered', Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |