A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to delete all defined names from a workbook?



 
 
Thread Tools Display Modes
  #11  
Old November 11th, 2005, 03:44 PM
Dmitry Kopnichev
external usenet poster
 
Posts: n/a
Default How to delete all defined names from a workbook?

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



  #12  
Old November 11th, 2005, 04:04 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default 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" 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





  #13  
Old November 11th, 2005, 07:30 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default How to delete all defined names from a workbook?

I sent a message to Jan Karel. He would like to see your workbook.

You can send it to him at:





Dmitry Kopnichev wrote:

Hello
How to delete all defined names from a workbook?


--

Dave Peterson
  #14  
Old November 14th, 2005, 04:17 PM
Dmitry Kopnichev
external usenet poster
 
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







  #15  
Old November 14th, 2005, 04:20 PM
Dmitry Kopnichev
external usenet poster
 
Posts: n/a
Default How to delete all defined names from a workbook?

Thanks!
Does not publishing an e-mail address in a message a group cause spam to the
address?
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
I sent a message to Jan Karel. He would like to see your workbook.

You can send it to him at:





Dmitry Kopnichev wrote:

Hello
How to delete all defined names from a workbook?


--

Dave Peterson



  #16  
Old November 14th, 2005, 04:26 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default How to delete all defined names from a workbook?

Jan Karel told me it was ok to post that address. (I would have munged it,
too.)



Dmitry Kopnichev wrote:

Thanks!
Does not publishing an e-mail address in a message a group cause spam to the
address?
"Dave Peterson" ???????/???????? ? ????????
?????????: ...
I sent a message to Jan Karel. He would like to see your workbook.

You can send it to him at:





Dmitry Kopnichev wrote:

Hello
How to delete all defined names from a workbook?


--

Dave Peterson


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
not delete worksheets from names in a range DARREN FONG General Discussion 3 November 11th, 2005 06:31 PM
Using Defined Names in a Chart bobburg General Discussion 2 September 12th, 2005 12:07 AM
CHANGE COLUMN NAMES TO DEFINED NAMES David @ Elite General Discussion 1 October 5th, 2004 04:29 PM
Problem with Defined Names Joe Blow Worksheet Functions 1 October 1st, 2004 05:57 PM
Defined Names in an If Statement SharonSmith Worksheet Functions 3 March 25th, 2004 05:04 PM


All times are GMT +1. The time now is 10:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ╘2004-2024 OfficeFrustration.
The comments are property of their posters.