View Single Post
  #14   Report Post  
Dmitry Kopnichev
 
Posts: n/a
Default How to delete all defined names from a workbook?

Thanks!
What exactly could I be breaking that excel needs, if I delete those names?
"Bob Phillips" сообщил/сообщила в
новостях следующее: ...
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" wrote in message
...
Thanks.
How to know which names Excel created? What exactly could I be breaking

that
excel needs, if I delete those names?
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
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