Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Already exists on the destination workbook
When I copy a worksheet into the same workbook I get a warning message that
states "a formula or sheet you want to move or copy contains the name 'wrn.Retirement._.Bonus.', which already exists on the destination worksheet." I don't have any formulas or Names with this 'wrn.Retirement._.Bonus. Does anyone know what this is and how do I get rid of it? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Already exists on the destination workbook
Excel is not very good at getting rid of named ranges that are no
longer required. If you click on Insert | Name | Define you will see a list of names in your workbook - if you don't need them, highlight each in turn and click on the Delete button. Hope this helps. Pete On Jul 11, 5:52*pm, ChrisP wrote: When I copy a worksheet into the same workbook I get a warning message that states "a formula or sheet you want to move or copy contains the name 'wrn.Retirement._.Bonus.', which already exists on the destination worksheet." I don't have any formulas or Names with this 'wrn.Retirement._.Bonus. Does anyone know what this is and how do I get rid of it? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Already exists on the destination workbook
Thank you for your response but I've already done that. I have no "Names"
that have wrn.Retirement._.Bonus. in them. "Pete_UK" wrote: Excel is not very good at getting rid of named ranges that are no longer required. If you click on Insert | Name | Define you will see a list of names in your workbook - if you don't need them, highlight each in turn and click on the Delete button. Hope this helps. Pete On Jul 11, 5:52 pm, ChrisP wrote: When I copy a worksheet into the same workbook I get a warning message that states "a formula or sheet you want to move or copy contains the name 'wrn.Retirement._.Bonus.', which already exists on the destination worksheet." I don't have any formulas or Names with this 'wrn.Retirement._.Bonus. Does anyone know what this is and how do I get rid of it? Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Already exists on the destination workbook
Excel creates names when it needs them. And some of those names are hidden from
the user. Get 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 And you may find a bunch of hidden names that you never knew existed. ps. I think some wrn.* names are created when you use Report Manager. (But I've seen them in other workbooks/worksheets when I never used Report Manager, too.) ChrisP wrote: Thank you for your response but I've already done that. I have no "Names" that have wrn.Retirement._.Bonus. in them. "Pete_UK" wrote: Excel is not very good at getting rid of named ranges that are no longer required. If you click on Insert | Name | Define you will see a list of names in your workbook - if you don't need them, highlight each in turn and click on the Delete button. Hope this helps. Pete On Jul 11, 5:52 pm, ChrisP wrote: When I copy a worksheet into the same workbook I get a warning message that states "a formula or sheet you want to move or copy contains the name 'wrn.Retirement._.Bonus.', which already exists on the destination worksheet." I don't have any formulas or Names with this 'wrn.Retirement._.Bonus. Does anyone know what this is and how do I get rid of it? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
Paste names from a source workbook to a destination | Excel Discussion (Misc queries) | |||
updating destination when I add a line to my source workbook | Excel Worksheet Functions | |||
Destination workbook formulae become #VALUE! | Excel Discussion (Misc queries) | |||
saving workbook to destination file automatically | Excel Worksheet Functions |