+ Reply to Thread
Results 1 to 2 of 2

Difficulty breaking link possibly caused by "Name" function.

  1. #1
    Registered User
    Join Date
    07-21-2012
    Location
    Fayetteville, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Difficulty breaking link possibly caused by "Name" function.

    Alcon,

    I have researched a problem I am experiencing in Excel 2010 and have had problems in the past with previous versions. It seems that occasionally I run across a link that just refuses to break. During my research I have found some reports that this may be linked to the "Name" function. !!!Bing!!! the light comes on. When I copied my template to my new folder and tried to cut and paste data into it I got a message saying something like "A formula or sheet you want to move or copy contains the name "...", which already exists on the destination worksheet." and I opted to replace the existing name with the new one. Apparently I created an external link at that point and one that cannot now be broken unless I delete my named range and start over the naming process. I mention this here because I see lots of people having this problem and the stock answer is to goto the Edit Links menu and attempt to break the link. Try as they and I might, this doesn't work. I also saw a post about it being a phantom validation problem and that too panned out although I can see how the validation could be linked externally and create this problem.

    Does anyone know if this accurately describes the issue and is there a remedy besides re-creating the "Names"?

  2. #2
    Registered User
    Join Date
    07-21-2012
    Location
    Fayetteville, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Difficulty breaking link possibly caused by "Name" function.

    Update - made copy of file to play with. Deleted sheets until link was removed. Closed & re-opened w/o saving. Went to sheet where problem resided. Removed all validation. Still had link. Removed all names. Still had link. Removed all conditional formatting. Link disappeared!

    Re-opened file w/o saving. Went to sheet with problem. Under conditional formatting I reset all conditions and "applied" the changes. Link disappeared!

    Apparently the problem can manifest itself from Names, Validation and Conditional Formatting. Check all 3 when having this problem.

    Thanks MicroSoft!

+ 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. Having difficulty with VB on a button "Run-time error 1004"
    By andyaf in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2013, 02:34 AM
  2. Breaking a "Group Item" code in an invoice down into constituent items on seperate lines
    By big_mike_1974 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 04:51 PM
  3. Replies: 4
    Last Post: 01-19-2012, 08:48 AM
  4. Problem Combining "Paste Link" & "Insert Rows"
    By o'h3nry in forum Excel General
    Replies: 1
    Last Post: 05-14-2010, 03:15 PM
  5. vlookup problem, possibly due to "noise"
    By JPANDRE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2005, 08:40 AM

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