Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Unable to Break Links to another file

  1. #1
    Join Date
    7th May 2006
    Location
    Cardiff
    Posts
    7

    Unable to Break Links to another file

    Hi,

    Last week I copied a worksheet from one spreadsheet into another, and have since been working from the new one. When I open the file I get a message box asking if I want to Update links from the other workbook. But I've deleted all named ranges, formulae, shapes, everything that could possibly link to the other workbook. I've also (in my frustration) completely deleted the sheet that was originally copied and re-made it from scratch. But it STILL comes up with this update box. In Excel's Help it says to go to Edit/Links and press Break Link, which I have tried but it doesn't do a thing. The link is still sitting there in the display box in the Links window - it says that the Type is Worksheet, I don't know if this makes any difference that it's not a formula or anything?

    Also, in complete desperation when it wasn't deleting the link, I changed the source to a random file, so it now comes up with an error in updating (which it obviously would) however this doesn't have any effect on my file because as far as I can tell it no longer has links to the other file!

    I'm tempted to just go to the option that says don't show the Update prompt on opening (the file is to be handed in as coursework on Wednesday) but this doesn't solve the problem, only bypasses it!

    Each time I made a major change (e.g. recreating the copied worksheet, changing the source) I saved the file under a different name, so I have all old copies just incase I've completely messed it up!

    Any ideas what this link is up to?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th May 2006
    Location
    Cardiff
    Posts
    7

    Re: Unable to Break Links to another file

    After another hour of bashing my head (ouch) I decided to do some more googling (didn't find anything first time round) and this time actually found a good suggestion which worked!!!

    To get rid of unwanted links, save the file under the same name as the file it links to. So in my case, I created a new excel file called Link.xls, which was blank, then in the Edit/Links box changed the link to be to this new file called Link.xls. Then all I had to do was Save As and select Link.xls so that it is linked to itself!

    Everything seems to be working, all of the calculations are still there, macros work, etc. Hopefully this has sorted the problem.

    Thanks anyway, I'm really sorry - I hope I haven't wasted anyone's time!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,509

    Re: Unable to Break Links to another file

    Did you try Edit > Links > Change Source & then change the Source to the Workbook that you are using?
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  4. #4
    Join Date
    7th May 2006
    Location
    Cardiff
    Posts
    7

    Re: Unable to Break Links to another file

    Yep tried that and it did something strange - said something like it couldn't find certain sheets, for about 5 different sheets, so didn't change the link at all in the end.

    The way listed above seems to work though so changing the file name to be the same as the linked file seems to be the way forward rather than linking to the current file!

    Thanks for the response! Panic over thank goodness, it's all fixed now, hopefully nothing more can go wrong before the hand in date!!

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    9th November 2011
    Posts
    2

    Re: Unable to Break Links to another file

    this tread is already quite old but I will add a comment nonetheless...

    tip1: check the Conditional Formatting
    tip2: look for hidden and veryhidden sheets - use VBA editor to get to the "veryhidden" ones...

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,068

    Re: Unable to Break Links to another file

    Thanks, topic is now closed.
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Break External Links Across Multiple Workbooks
    By owadept in forum EXCEL HELP
    Replies: 3
    Last Post: March 12th, 2014, 19:10
  2. Move Sheet & Break Links But Retain Formatting
    By yashodharjain in forum EXCEL HELP
    Replies: 1
    Last Post: November 24th, 2007, 01:58
  3. Break Links With Vba
    By Thomas100 in forum EXCEL HELP
    Replies: 1
    Last Post: August 14th, 2007, 20:55
  4. Break Links
    By deanalt in forum EXCEL HELP
    Replies: 4
    Last Post: January 23rd, 2007, 03:33
  5. Links - Break Links - Values Lost
    By Phil_B in forum EXCEL HELP
    Replies: 1
    Last Post: November 18th, 2005, 19:10

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
  •  
porno