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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |