+ Reply to Thread
Results 1 to 2 of 2

Can't delete named ranges - linking to other file

  1. #1
    Registered User
    Join Date
    11-09-2022
    Location
    Illinois
    MS-Off Ver
    Office 365
    Posts
    17

    Can't delete named ranges - linking to other file

    I have an issue where the named ranges are duplicated. I had 2 spreadsheet open at the same time with same named ranges. File names were different.
    When I created the named ranges, only 1 file was open at a time.

    If I go into the Name Manager, I see the ones linking to an external file (deleted file) but I am unable to edit or delete them.

    Any ideas what I can do without starting from scratch?
    The ones referencing F:\ need to be removed but the Delete button is unusable.

    NamedError.JPG

  2. #2
    Registered User
    Join Date
    11-09-2022
    Location
    Illinois
    MS-Off Ver
    Office 365
    Posts
    17

    Re: Can't delete named ranges - linking to other file

    Figured this out on my own.

    Issue: Somehow a tab from one spreadsheet overwrote an existing one and pulled over the Named Ranges. Once I deleted that tab, the other ranges dissappeared.

+ 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] Can't delete named ranges using VBA
    By frankt68 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-02-2021, 05:38 AM
  2. [SOLVED] Linking a formula to named ranges in another workbook
    By Tetnus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2020, 08:59 PM
  3. [SOLVED] How to delete strange named ranges?
    By jaryszek in forum Excel General
    Replies: 17
    Last Post: 12-20-2018, 04:52 AM
  4. Replies: 2
    Last Post: 08-27-2018, 03:15 AM
  5. [SOLVED] Macro to delete 2 named ranges
    By bevc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2016, 02:37 AM
  6. Dynamic Named Ranges - LINKING
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2006, 03:50 PM
  7. Linking to named ranges in another workbook
    By KG in forum Excel General
    Replies: 4
    Last Post: 03-29-2006, 10:10 PM

Tags for this Thread

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