+ Reply to Thread
Results 1 to 5 of 5

Deleting Excel Defined Names

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    10

    Deleting Excel Defined Names

    I opened an excel file I am working on and it has hundreds of lists in the Name Manager. 90% of these do not pertain to the particular file I am working on. If I delete the names, will it be deleted from all the Excel files for which it is used? Or is the deletion localized to my file only?

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Deleting Excel Defined Names

    Each workbook is separate, unless there's some sort of wacky VB programming class module to force that kind thing.

    It'd be the first time I ever saw something like that, but I'd like to believe everything is possible.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    02-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Deleting Excel Defined Names

    Ok. Just to make sure - I can feel safe deleting all the ones I don't need from this workbook?

  4. #4
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Re: Deleting Excel Defined Names

    Quote Originally Posted by diannal82 View Post
    Ok. Just to make sure - I can feel safe deleting all the ones I don't need from this workbook?
    Yes, you can delete them.

  5. #5
    Registered User
    Join Date
    02-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Deleting Excel Defined Names

    Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Error Message on Cell References, Range Names, Defined Names, etc.
    By BLS99covert in forum Excel General
    Replies: 2
    Last Post: 12-29-2014, 05:37 PM
  2. Replies: 1
    Last Post: 05-14-2012, 10:14 AM
  3. Excel defined names
    By obrien2003 in forum Excel General
    Replies: 4
    Last Post: 04-10-2008, 02:07 PM
  4. Print all defined names and references in Excel
    By l4ya in forum Excel General
    Replies: 1
    Last Post: 03-27-2008, 12:30 PM
  5. [SOLVED] Tranferring names defined in one excel workbook to another workboo
    By Dinesh in forum Excel General
    Replies: 1
    Last Post: 07-01-2006, 12:40 AM
  6. Deleting unused Defined Names in a workbook?
    By Mike Piazza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2005, 01:06 PM
  7. [SOLVED] Deleting Names in Excel 2003
    By steve_nelson in forum Excel General
    Replies: 2
    Last Post: 01-06-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1