How to delete all defined names from a workbook?

They usually take the format of


*_FilterDatabase
*Print_Area
*Print_Titles
*wvu.*
*wrn.*
*!Criteria

most will recreate next time needed, but not guaranteed.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dmitry Kopnichev" <kopn@bk.ruDelete> wrote in message
news:e5Otd5s5FHA.3388@TK2MSFTNGP11.phx.gbl...
> Thanks.
> How to know which names Excel created? What exactly could I be breaking
that
> excel needs, if I delete those names?
> "Dave Peterson" <petersod@verizonXSPAM.net> ???????/???????? ? ????????
> ?????????: news:4374AB26.B07FC6BC@verizonXSPAM.net...
> > Be careful.
> >
> > Excel creates names that it uses (without your knowledge and without
your
> > permission).
> >
> > If you delete those names, you could be breaking something that excel
> needs.
> >
> > If I were you, I'd get a copy of 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
> >
> > You can delete just the names you want pretty easily.
> >
> >
> >
> > Dmitry Kopnichev wrote:
> > >
> > > Hello
> > > How to delete all defined names from a workbook?
> >
> > --
> >
> > Dave Peterson
>
>

Thanks!
What exactly could I be breaking that excel needs, if I delete those names?
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> сообщил/сообщила в
новостях следующее: news:O9rLqEt5FHA.4076@tk2msftngp13.phx.gbl...
> They usually take the format of
>
>
> *_FilterDatabase
> *Print_Area
> *Print_Titles
> *wvu.*
> *wrn.*
> *!Criteria
>
> most will recreate next time needed, but not guaranteed.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Dmitry Kopnichev" <kopn@bk.ruDelete> wrote in message
> news:e5Otd5s5FHA.3388@TK2MSFTNGP11.phx.gbl...
> > Thanks.
> > How to know which names Excel created? What exactly could I be breaking
> that
> > excel needs, if I delete those names?
> > "Dave Peterson" <petersod@verizonXSPAM.net> ???????/???????? ? ????????
> > ?????????: news:4374AB26.B07FC6BC@verizonXSPAM.net...
> > > Be careful.
> > >
> > > Excel creates names that it uses (without your knowledge and without
> your
> > > permission).
> > >
> > > If you delete those names, you could be breaking something that excel
> > needs.
> > >
> > > If I were you, I'd get a copy of 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
> > >
> > > You can delete just the names you want pretty easily.
> > >
> > >
> > >
> > > Dmitry Kopnichev wrote:
> > > >
> > > > Hello
> > > > How to delete all defined names from a workbook?
> > >
> > > --
> > >
> > > Dave Peterson
> >
> >
>
>