Prev: Multiple condition countif for excel 2003
Next: Cell referncing
From: ChrisP on 11 Jul 2008 12:52
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!
From: Pete_UK on 11 Jul 2008 13:56
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 <Chr...(a)discussions.microsoft.com> 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!

From: ChrisP on 11 Jul 2008 14:33
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 <Chr...(a)discussions.microsoft.com> 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!
>
>
From: Dave Peterson on 11 Jul 2008 15:13
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 <Chr...(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: Multiple condition countif for excel 2003
Next: Cell referncing